Board logo

标题: [软件故障] MySQL Got error 28 from storage engine (1030) Slave...checksum的解决方法 [打印本页]

作者: shillan    时间: 2018-7-19 11:17     标题: MySQL Got error 28 from storage engine (1030) Slave...checksum的解决方法

现象:MySQL主从数据库同步时报错:
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:
数据库换成一致版本。
解决办法2:
在master的my.cnf或my.ini中设置
  1. binlog_checksum=none
复制代码





欢迎光临 逐梦论坛 (http://temp2023.zhumeng.org/) Powered by Discuz! 7.2