Re: Backup servers which are replicated

[Dupont Jean]

Thanks for your response

I have read this documentation and I think that I have found the response about "how to backup". I will stop the replication on the slave (mysqladmin stop-slave), backup the databases with mysqldump (mysqldump --databases --add-drop-database --single-transaction $db) and restart the replication (mysqladmin start-slave).

But I have doubts about the recovery. How I will process for the recovery in case of Slave loss and in case of Master loss?

Regards