Regarding master failover
Dear mysql experts,
Regarding records missing when master failed,
I have a master slave setup(1 master and 2 slaves testing purpose), whem master down some of the records are not replicating to the slave, then I am making one of the slave as master. if downed master up then adding as slave that time I am getting duplicate records if I use auto-increament key. How to solve this issue?
Mainly when master down some records(last event) are not replicating to the slave. is there any method to do without missing any records(synchronous between master and slave) or any way to get those records to the slave during the master failore?
Subject
Written By
Posted
Regarding master failover
June 05, 2009 04:50AM
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.