MySQL Forums
Forum List  »  Replication

Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
Posted by: Rick James
Date: April 14, 2013 01:04PM

bin.000003 is shorter than 335782050, correct?
The Master crashed, correct?
You have sync_binlog = OFF, correct?

The CHANGE MASTER to position 0 (or 4) of bin.000004 is safe and the 'right' thing to do.

The Master sends replication stuff to the slaves and simultaneously writes it to the binlog. With sync_binlog=OFF, the last block(s) may not be flushed to disk be fore the crash.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
1168
April 14, 2013 01:04PM


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.