MySQL Backup and Recovery: Tools and Techniques
General backup best practices:
what to backup, why, and when;
backup schedules and retention policies;
documentation and test of recovery procedures;
Overview, analysis and comparison of various methods of backups:
full backup vs incremental backup;
binary backup vs logical backup;
cold backup vs hot backup.
Overview on differences between storage engines, and how that affects the choice of backup.
file system snapshot ( LVM and XFS snapshot );
backup from slave;
EBS snapshot ( in the cloud ).
Zmanda Recovery Manager (ZRM) for MySQL
ZRM with XtraBackup (and streaming)
Recovery procedure depending from method(s)/tool(s) used for backup.
Point in time recovery using binlog and/or replication.