Got fatal error 1236 from master when reading data from binary log

634828354發表於2017-08-25
GoErrorAST
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 'mysqlbin.000031' at 120, the last event read from 'D:\mysql-5.6.17-winx64\mysql-5.6.17-winx64\data\mysqlbin.000031' at 120, the last byte read from 'D:\mysql-5.6.17-winx64\mysql-5.6.17-winx64\data\mysqlbin.00003'

原因：這個錯誤一般出現在master5.6,slave在低版本的情況下。這是由於5.6使用了crc32做binlog的checksum

解決方法：在主機配置檔案中增加如下：
【mysqld】
binlog-checksum = none 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30046312/viewspace-2144147/，如需轉載，請註明出處，否則將追究法律責任。

相關文章