Lock, Stock and Backup: Data Guaranteed
summary
Recommends a three-part approach: binary log streaming for point‑in‑time recovery, plus mydumper (parallel logical dumps but no streaming) for quick partial restores and xtrabackup (fast InnoDB physical backups, supports parallel on‑the‑fly encryption) for full restores. Advises snapshots (LVM on slaves due to doubled IO, ZFS native preferred, AWS EBS/GCP snapshots copy blocks to cloud storage), strict RPO/RTO planning, automated monitoring and regular restore tests, and careful key management because GPG can triple backup time versus native parallel encryption.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 1:35Why take backups
- 8:16MyDumper
- 15:11ExtraBackup
- 20:24F filesystem snapshots
- 26:01Cloud backup solutions
- 29:20Monitoring and testing
- 36:38Security
- 41:17Conclusion
related talks
51mMySQL Backups
31mHighly Efficient backups with Percona Xtrabackup
27mBackup and Restore: Discover Best Practices for a Distributed Database Backup Strategy
38mProtecting Database Backups From Ransomware and Malicious Intent
29mYou Don't Need a Database Backup Policy
50mWeb-Scale Backups for MySQL
45mMySQL backups strategy, tools, recovery scenarios
56mPostgreSQL Backup Strategies