MySQL Forums
Forum List  »  Replication

Replication after dump
Posted by: eli na
Date: April 18, 2011 02:36PM

Hi all,

I have a system configured with two databases and replication setup between them. Normally, the system will write to one db and replication insures that the other db is updated. The system will automatically switch to db 2 in the event of failure of db 1. However, when db 1 is up again, I need to smoothly switch to it without shutting down the system. My solution is to:
1) memorize the position of the bin log in db 2
2) dump db 2 data (without locking tables)
3) copy the dump to db 1 and update it
4) start the replication on db 1 by pointing to db 2 bin log position

* I can't lock all tables while performing the dump because it will hinder access to my system.
* The table engines that i'm using are a mixture of InnoDB and MyISAM.

Is this solution good, and if not your suggestions are welcomed.

Thanks in advance for your help

Options: ReplyQuote

Written By
Replication after dump
April 18, 2011 02:36PM
April 27, 2011 07:52AM

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.