MySQL Backup and Recovery: Tools and Techniques

Database Administration
3 December 14:00 - 17:00 @ Orchard 1

General backup best practices:

what to backup, why, and when;
backup schedules and retention policies;
documentation and test of recovery procedures;
archiving
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.

Methods:

file system snapshot ( LVM and XFS snapshot );
backup from slave;
EBS snapshot ( in the cloud ).
Tools:

mysqldump
XtraBackup
mydumper
mylvmbackup
mysqlhotcopy
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.

Speakers

René Cannaò
Senior Operational DBA, PalominoDB
Speaker Biography: 
René has 10 years of working experience as System, Network and Database Administrator mainly on Linux/Unix platform. In the last 4-5 years his experience was focused mainly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle and now as Senior Operational DBA at PaolominoDB. In this period he build an analytic and problem solving mindset and he is always eager to take on new challenges, especially if they are related to high performance.