返回列表 发帖

[软件故障] 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
复制代码
欢迎光临:逐梦论坛

返回列表

Powered by Discuz! 7.2   论坛QQ群:逐梦论坛群

© 2001-2021 Comsenz Inc. 鲁公网安备 37120302000001号