Mysql – Slave can not handle replication events with the checksum that master is configured to log

MySQLreplication

My slave is not connecting to the master and is showing the 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.000002' a'

I have tried set global binlog_checksum='NONE'; and it works fine in masters but when I try to change slaves's cnf file binlog_checksum=none it fails and MySQL won't start after restarting it.

What can I do to resolve this?

Best Answer

Is your slave of older version than master? Say 5.5 or less. As you say set global binlog_checksum='NONE'; fails on slave => you're on older slave and that is not required on slave as well.

Related Question