Backup servers which are replicated
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
Subject
Views
Written By
Posted
Backup servers which are replicated
2055
April 28, 2015 08:51AM
1160
May 11, 2015 12:14PM
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.