Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Lock, Stock and Backup: Data Guaranteed

Lock, Stock and Backup: Data Guaranteed

 26 April - 3:30 PM - 4:20 PM @ Ballroom B
Experience level: 
50 minutes conference
Tools and Techniques
High Availability


Backups are crucial in a world where data is digital and uptime is revenue. Environments are no longer bound to traditional data centers, and span multiple cloud providers as well a plethora of heterogeneous environments. We need bulletproof backups and impeccable recovery processes. This talk aims to answer the big question "how should I backup my MySQL databases?" by providing 3-2-1 backup designs, best practices and real-world solutions leveraging key technologies, automation techniques and major cloud provider services. Topics include: 1. Backup and Recovery Primer 2. Binary Log Backups 3. Logical Backups with Mydumper 4. Physical Backups with Xtrabackup 5. Leveraging Snapshots - 6.1 LVM Snapshots - 6.2 ZFS / ZVOL Snapshots (ZFS on Linux) - 6.3 AWS: Amazon S3 & EBS Snapshots - 6.4 GCP: Google Cloud Storage and Compute Engine Snapshots 7. "3-2-1" in the Cloud 8. Monitoring, Testing and Recovery 9. Encryption and Security


Jervin Real's picture

Jervin Real

Engineer Engineering Engineers, Percona


Jervin is a member of the Technical Services at Percona where he partners with its customers on building reliable and highly performant MySQL infrastructures while also doing other fun stuff like watching cat videos on the internet, reading bugs for novels, and playing around servers for numbers.

Andrew Moore's picture

Andrew Moore

MySQL Practice Manager, Percona


Loves MySQL, Dolphins and reading.

Share this talk