patternsqlMinor
Slave can not handle replication events with the checksum that master is configured to log
Viewed 0 times
cantheeventshandlewithslavelogreplicationchecksummaster
Problem
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
What can I do to resolve this?
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?
Solution
Is your slave of older version than master? Say 5.5 or less.
As you say
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.Context
StackExchange Database Administrators Q#124056, answer score: 4
Revisions (0)
No revisions yet.