Mysql 版本:
mysql-5.6.15-win32
mysql-5.1.56-win32
配置好mysql的主从之后,执行
show slave status \G;
命令时发现
Slave_IO_Running: No.
错误信息为
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.000001' a'
Error log
Error reading packet from server:
Slave can not handle replication events with the checksum that master is configured to log
原因为5.6向5.1同步时,5.6使用了crc32做binlog的checksum,我们把master的binlog-checksum设置为none
binlog-checksum = none
然后
net stop master
net start master
stop slave
change master...// 重新设置binlog的读取位置
start slave
show slave status\G;
发现
Slave_IO_Running: Yes
Slave_SQL_Running: Yes