Percona XtraBackup Advanced Features
summary
Percona XtraBackup: practical expert capabilities for backup and recovery of MySQL/MariaDB. Covers features and advanced techniques of Percona XtraBackup, how it handles hot backups, incremental backups, streaming, and restores to minimize downtime and ensure data integrity.
AI-written summary · about
chapters (29)
- 0:00Introduction
- 2:13What is Percona XtraBackup
- 4:00InnoDB principles
- 6:10Hot backup operation
- 7:14Incremental backups
- 8:40Non-standard data issues
- 10:26Main commands and tools
- 11:48Streaming mode examples
- 12:10System load minimization
- 15:22Linux cache optimization
- 15:45Parallel copying
- 17:50Server locks during copy
- 19:59Lock issues solution
- 21:50Lock-free backups
- 22:11Statistics for analysis
- 24:17Partial table copy
- 26:23Metadata import/export
- 28:54Partial database backups
- 31:05Partition copying
- 33:33Point-in-time recovery
- 35:41Backups in replication
- 37:06New streaming format
- 38:11Built-in compression
- 42:27Buffer pool recovery
- 43:34Fast incremental backups
- 45:24Compact backups
- 46:29Built-in encryption
- 46:49Key features overview
- 47:54Q&A
related talks
31mHighly Efficient backups with Percona Xtrabackup
24mPercona Server for MySQL Advantage
45mMySQL backups strategy, tools, recovery scenarios
15mPercona Database Distributions - An Overview
50mWeb-Scale Backups for MySQL
38mIs Percona XtraDB Cluster Right for Any Application
46mLock, Stock and Backup: Data Guaranteed
24mMariabackup: too rarely used