Web‑Scale Backups for MySQL

on YouTube ↗50m

" summary

Compares backup tools for large-scale MySQL (mysqldump, mydumper, mylvmbackup, Percona XtraBackup and commercial options) and discusses how to choose among them. Covers techniques to optimize backups of very large datasets and addresses issues such as server locking and other operational problems that occur during backup of high-load MySQL servers.

AI-written summary · about

" chapters (11)

1. 0:00Introduction
2. 1:10Logical vs physical backups
3. 4:02Backup tools overview
4. 10:22MySQL Enterprise Backup
5. 14:32Compression and restore speed
6. 18:48Backup locks
7. 27:19Partial backups and restore
8. 30:51Incremental backups
9. 33:21Backup integrity checks
10. 36:11Cloud storage backups
11. 44:46Q&A

" related talks

• 53mMySQL DevOpsV. Fedorkov, A. Raspopina · DevOps Pro Moscow 2019
• 52mOrganizing reliable backups for a web projectAnton Baranov · РИТ++ 2016
• 59mTaking Care of Backups with LaravelFreek van der Herten · PHP UK Conference 2017
• 01h 02mScaling One of the Largest On-prem Managed MySQL Fleets in IndiaVaidyanathan Subramanian · Percona Live 2022
• 43m50 Shades of BackupSebastian Feldmann · Dutch PHP Conference 2017
• 27mBackup and Restore: Discover Best Practices for a Distributed Database Backup StrategyValentin Kulichenko, Alan Caldera · Distributed SQL Summit 2022
• 30mManaging Postgres at scale: Challenges, Tools & TechniquesKaren Jex · POSETTE: An Event for Postgres 2025
• 19mMove to the Cloud with Zero DowntimeSébastien Giraud · MariaDB OpenWorks 2023