Skip navigation links

MySQL Forums :: Replication :: MySQL Error 1236 on slave


Advanced Search

MySQL Error 1236 on slave
Posted by: J M ()
Date: February 20, 2013 03:31AM

Hi,

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?

Thanks.



Edited 3 time(s). Last edit at 02/20/2013 03:47AM by J M.

Options: ReplyQuote


Subject Views Written By Posted
MySQL Error 1236 on slave 5151 J M 02/20/2013 03:31AM
Re: MySQL Error 1236 on slave 2790 Rick James 02/22/2013 10:20PM


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.