MySQL Error 1236 on slave
Date: February 20, 2013 03:31AM
I am trying to setup a replication with 1 master and 1 slave, but i seem to be receiving the following 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.000003' at 513, the last event read from '.\mysql-bin.000003' at 513, the last byte read from '.\mysql-bin.000003' at 120.'"
I can't seem to find why i am receiving this error, i have tried looking at various place on the internet for a solution but i can't seem to find one, Any ideas what is causing this and how i can fix this?
NOTE: I am using a master with server version 5.6 with a slave which has the version 5.5 could this be the issue?
Update:Managed to fix it by adding the line "binlog-checksum=none" to my configuration file(my.conf/my.ini), i guess the different server versions was the issue?
Edited 3 time(s). Last edit at 02/20/2013 03:47AM by J M.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.