Re: Innodb Hot Backup for a Replicated Slave

[Richard Zybert]

I just set-up something really simple that does the job for us. Maybe it would help you.

1) Set-up an additional replication slave - 'backup slave' - only for this purpose.
It may be on the same machine or somewhere else. It is not accessed by anybody and is read_only. It's only function is to maintain a copy of the original dataset.

2) To do a backup - stop the 'backup slave' and copy the complete data directory,
then restart the 'backup slave'

As the backup slave is not used for anything else it can be stopped at any time.
After re-start it catches up with the master and we have a 'snapshot' of data
that we can write anywhere. Recovery means simply connecting to the backup data.

No additional software is needed, all of this is handled by a few lines of shell script.