MySQL Forums :: Replication :: Replication after dump


Advanced Search

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

Note:
* 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


Subject Views Written By Posted
Replication after dump 1684 eli na 04/18/2011 02:36PM
Re: Replication after dump 545 Rick James 04/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.