MySQL Forums
Forum List  »  Backup

Backup servers which are replicated
Posted by: Dupont Jean
Date: April 28, 2015 08:51AM

Hello,

We have setup a replication between two mysql servers.
Now, we want to backup these servers. For the moment, we use mysqldump on the master and on the slave. (mysqldump --databases --add-drop-database $db > $FILE)

Is it the good way to backup?
And, what is the best way to restore the slave if it fall (and the master remains up)?
What is the method to restore the master if it fall (and the slave remains up)?
What is the best way to restore the two servers if they fall at the same time?
Thanks in advance for your help

Regards

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup servers which are replicated
2073
April 28, 2015 08:51AM


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.