MySQL Forums :: Replication :: MySQL Replication


Advanced Search

MySQL Replication
Posted by: Ryan Palacios ()
Date: November 30, 2010 06:06PM

Hello Guys,

We have a disaster recovery exercise coming up soon. As part of the exercise, we need to backup and restore two databases. The challenge I have at the moment is that the these databases are being replicated. The mysql servers have multiple replication roles. i.e. master/slave (California) and master/slave in (Dallas).

My questions are:

1. What is the mysqldump command I can use to backup multiple databases?
2. Is it best to stop all replication prior to the backup or after?
3. What is the best way to start replication again after the databases have been restored without having to recreate it?

Thanks in advance,

-rp

Options: ReplyQuote


Subject Views Written By Posted
MySQL Replication 2211 Ryan Palacios 11/30/2010 06:06PM
Re: MySQL Replication 747 Shawn Taylor 12/01/2010 02:40PM
Re: MySQL Replication 673 Ryan Palacios 12/01/2010 03:09PM
Re: MySQL Replication 996 Rick James 12/05/2010 01:10PM
Re: MySQL Replication 653 Ryan Palacios 12/06/2010 09:46AM


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.