Re: Exec_Master_Log_Pos doesn't move (invalid position?)
Posted by:
Rick James
Date: October 27, 2012 12:16PM
> The bin log is the same in the master and the slave
That's a coincidence. They work independently.
> start second slave at the coordinates taken on the first step
Did not need to do that -- the coordinates were part of the snapshot (assuming you copied the entire tree over)
> invalid position
Is it pointing to a position off the end of the binlog? If so, that is an indication of the Master crashing with sync_binlog=OFF. The cure is to CHANGE MASTER (on the Slave) to set it to the start of the next binlog. (POS = 0 or 4 -- either works.)
> reset the slave
I've never done this. I don't know what it is for.
Subject
Views
Written By
Posted
6334
October 26, 2012 04:11PM
Re: Exec_Master_Log_Pos doesn't move (invalid position?)
2826
October 27, 2012 12:16PM
2901
October 27, 2012 02:10PM
2006
October 28, 2012 10:03AM
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.