Innodb Hot Backup for a Replicated Slave
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.
Subject
Views
Written By
Posted
Innodb Hot Backup for a Replicated Slave
5839
January 11, 2008 03:34PM
3108
February 18, 2008 04:28AM
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.