MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
2709
Frwa Onto
April 13, 2013 01:03PM
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
1195
Rick James
April 14, 2013 01:04PM
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
1242
Frwa Onto
April 14, 2013 10:38PM
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
1291
Rick James
April 15, 2013 10:02PM
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
1093
Frwa Onto
April 16, 2013 10:18PM
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
2337
Rick James
April 17, 2013 08:51PM
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
1082
Frwa Onto
April 18, 2013 02:48AM
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
904
Rick James
April 18, 2013 09:54PM
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
906
Frwa Onto
April 18, 2013 10:04PM
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
1020
Rick James
April 19, 2013 10:16PM
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
902
Frwa Onto
April 20, 2013 09:29PM
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
980
Rick James
April 21, 2013 07:30PM
Re: Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/?
926
Frwa Onto
April 22, 2013 07:18AM


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.