- 5.3 Example Backup and Recovery Strategy
- 5.3.1 Backup Policy
- 5.3.2 Using Backups for Recovery
- 5.3.3 Backup Strategy Summary
In case of an operating system crash or power failure,
InnoDB itself does all the job of recovering
data. But to make sure that you can sleep well, observe the
following guidelines:
Always run the MySQL server with the
--log-binoption, or even--log-bin=, where the log file name is located on some safe media different from the drive on which the data directory is located. If you have such safe media, this technique can also be good for disk load balancing (which results in a performance improvement).log_nameMake periodic full backups, using the mysqldump command shown earlier in Section 5.3.1, “Backup Policy”, that makes an online, nonblocking backup.
Make periodic incremental backups by flushing the logs with
FLUSH LOGSor mysqladmin flush-logs.
