MySQL Forums
Forum List  »  Replication

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
2250
November 30, 2010 06:06PM
753
December 01, 2010 02:40PM
679
December 01, 2010 03:09PM
1006
December 05, 2010 01:10PM
662
December 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.