16.3.1 Using Replication for Backups

16.3.1.1 Backing Up a Slave Using mysqldump
16.3.1.2 Backing Up Raw Data from a Slave

To use replication as a backup solution, replicate data from the master to a slave, and then back up the data slave. The slave can be paused and shut down without affecting the running operation of the master, so you can produce an effective snapshot of live data that would otherwise require the master to be shut down.

How you back up a database depends on its size and whether you are backing up only the data, or the data and the replication slave state so that you can rebuild the slave in the event of failure. There are therefore two choices: