Highly Efficient backups with Percona Xtrabackup
summary
Percona XtraBackup performs physical hot backups by copying InnoDB data files and redo logs and then requiring a prepare step to apply those logs for a consistent restore. Two binaries historically exist, xtrabackup and innobackupex, merged from 2.3, and supported for MySQL 5.5/5.6 with 5.7 planned. Features include full, incremental and partial backups, streaming, compression, parallel copy and remote SSH delivery. Incrementals work because incremental uses InnoDB change tracking. Watch for permission errors, mismatched log sizes, and large prepare times unless you use memory, parallelism or compression.
AI-written summary · about
chapters (8)
- 0:00Percona XtraBackup intro
- 6:54XtraBackup install & compat
- 10:40Full backup workflow
- 13:52Backup prep & restore
- 17:33Incremental & partial backups
- 23:32Streaming & compression
- 26:00Common issues
- 30:15Bug reporting and future improvements
related talks
54mPercona XtraBackup Advanced Features
46mLock, Stock and Backup: Data Guaranteed
50mWeb-Scale Backups for MySQL
15mPercona Database Distributions - An Overview
24mMariabackup: too rarely used
51mMySQL Backups
39mPhysical Backups with Percona Backup for MongoDB
43mBacking up Nextcloud-Consistent Backup and Restore of Application Data