mysql同步复制抛Got fatal error 1236 Slave can not handle replication events with the checksum
来源:互联网 发布:avr单片机微信群 编辑:程序博客网 时间:2024/06/06 00:19
做主主同步时,
基本信息:1.master1 mysql版本是5.6.12
2.master2 mysql版本时5.5.36
一:在master1做同步复制成功。
二:在master2做同步复制失败。
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Slave can not handle replication events with the checksum that master is configured to log; the first event 'mysql-bin.000011' at 120, the last event read from './mysql-bin.000011' at 120, the last byte read from './mysql-bin.000011' at 120.'
解决办法1:
master2的数据库换成5.6.12;
解决办法2:
在master1中设置binlog_checksum =none;
参数资料:http://blog.csdn.net/wantingtingting/article/details/41944047
1 0
- mysql同步复制抛Got fatal error 1236 Slave can not handle replication events with the checksum
- mysql同步复制报Slave can not handle replication events with the checksum that master 错误
- error 1236 from master when reading data from binary log: 'Slave can not handle replication events w
- Got fatal error 1236 from master when reading data from binary log: ‘Slave can not handle replicatio
- MySQL Group Replication Got fatal error 1236
- Received error packet: errno = 1236, sqlstate = HY000 errmsg = Slave can not handle replication even
- Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Slave can not h
- Got fatal error 1236 from master when reading data from binary log: 'A slave with the same server_uu
- Mysql 复制 配置详解, Replication with Master/Slave
- mysql故障~Got fatal error 1236 解决方法
- Got fatal error 1236
- mysql主从同步失败Last_IO_Error: Got fatal error 1236 from master解决方法
- mysqldump: Got error: 1290: The MySQL server is running with the --secure-file-priv option so it can
- mysql的master和slave同步(replication)
- 故障案例:主从同步报错Fatal error: The slave I/O thread stops because master and slave have equal MySQL server
- 故障案例:主从同步报错Fatal error: The slave I/O thread stops because master and slave have equal MySQL server
- mySQL主从失败 错误Got fatal error 1236解决方法
- MySQL主从失败 错误Got fatal error 1236解决方法
- opencv 读取 yuv(4:2:0)
- 2015-1-14 皇御贵金属晚评 日内金银大幅回落 关注数据能否提振
- easy ui datagrid checkbox 默认选中问题
- Fedora21安装unrar
- Linux文件系统启动过程及login的实现 (busybox)
- mysql同步复制抛Got fatal error 1236 Slave can not handle replication events with the checksum
- 将华氏温度转换成摄氏温度或将摄氏温度转化成华氏温度。(需考虑多种不合法的情况尽量转化为合法的)
- RocketMQ在Windows平台下环境搭建
- 设计模式初探
- iOS学习笔记(结构体运用到frame)
- select、poll、epoll之间的区别总结
- js 中{},[]中括号,大括号使用详解
- Day7-文本编辑之输入特定字符
- How to write ANSI C programs by using Visual C++