MySQL Forums
Forum List  »  Backup

Innodb Hot Backup for a Replicated Slave
Posted by: Doug Hairfield
Date: January 11, 2008 03:34PM

Is it possible to backup a replicated MySQL5 slave with INNODB Hot Backup AND restore it and reactive replication in the event that something happens to the DB? Will the backup provide the needed replication logs to restart the replication?

Basically I want to have a backup/restore strategy for our slave servers in the event of something happening to the DB instead of having to just reaload from the Master. I ask this because we are doing a datasplit and have run some stuff against the slave that would take a very long time to redo if we lost the DB and had to start over.

Options: ReplyQuote

Written By
Innodb Hot Backup for a Replicated Slave
January 11, 2008 03:34PM

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.