mysql异步同步报错Last_IO_Error: Got fatal error 1236 from master when reading

Last_IO_Errno: 1236
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.000087’ at 120, the last event read from ‘./mysql-bin.000087’ at 120, the last byte read from ‘./mysql-bin.000087′ at 120.’

原因:这个错误一般出现在master5.6,slave在低版本的情况下。这是由于5.6使用了crc32做binlog的checksum

保持版本一致即可

原创.转载请注明出处:www.tuike8.com
推课吧(tuike8) » mysql异步同步报错Last_IO_Error: Got fatal error 1236 from master when reading

发表评论

提供最优质的资源集合

立即查看 了解详情