Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2015
    Posts
    2

    Unanswered: 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

  2. #2
    Join Date
    Apr 2015
    Posts
    2

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •