Today is World Backup Day, so I thought I would use the opportunity to discuss some best practices and general considerations regarding backing up MySQL instances. While I focus on MySQL, several of these tips apply to backups in general.
Backup your data
Before heading into the gory details, let’s first take a look at the best practices at a high level:
- Make sure you can restore your backups:
- Document and script the restore procedures. Do you know the steps required to restore a full backup – or a single table?
- Keep copies of the backups off-site. Do you have a copy of your backup if the data center becomes unavailable for example due to a fire?
- Validate your …