Session
MySQL Backup and Recovery: Tools and Techniques

Sponsors

October 25th, 11:45 PM
Fleet Suite

Abstract

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.

Slides

Download Slides

Speaker

René Cannao

Senior Operation DBA, PalominoDB

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.