MySQL Forums
Forum List  »  Replication

multiple slave error: bogus data in log event
Posted by: Javier Cañete
Date: August 12, 2016 12:29PM

hello, we have one master and two slaves and as soon as the slaves start to replicate, we get this error in one slave only (the other keeps running):

Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'bogus data in log event; the first event 'mysql-bin.000002' at 211200498, the last event read from '/var/lib/mysql/binlog/mysql-bin.000002' at 211359690, the last byte read from '/var/lib/mysql/binlog/mysql-bin.000002' at 211359709.'

We can prevent this error in two ways:

- having only one slave (not an option, we need two of them)
- setting slave_compressed_protocol=1 (not an option, too much cpu usage)

So we think that the issue is in some way related to the binlog concurrence reading by the slave server I/O thread.

mysql-community-server-5.7.12-1
Red Hat Enterprise Linux Server release 6.5 (Santiago)

Any ideas to fix this issue?
Regards.

Options: ReplyQuote


Subject
Views
Written By
Posted
multiple slave error: bogus data in log event
5001
August 12, 2016 12:29PM


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.