HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

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

Submitted by: @import:stackexchange-dba··
0
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 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 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.