MySQL Forums
Forum List  »  Replication

How to resync the databases after a period of offline
Posted by: Madeleine Thach
Date: September 28, 2006 03:01AM

Although we are able to start replication between master and master, it seems impossible to get the databases to resync with each other after a failure of one master.

I'd like to find a procedure to force the databases to replicate regardless of the position of one master. Kind of like a force handshake to reset all the counter and make sure the data are the same across. It seems that when one database is offline for a while for some unknown reasons the "position" of the other master is lost, and they no longer replicate the records after it becomes online again. We can reset the database, but the lost record will never resync, so we now have 2 non-identical databases.

The only way so far that we can reset the database is to make a dump from one and restore it to the other one. This is not a feasible way in the production environment.

Any suggestions are very much appreciated. Please give a step by step resolution. Thanks.

Options: ReplyQuote

Written By
How to resync the databases after a period of offline
September 28, 2006 03:01AM

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.