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
原创粉丝点击