Percona XtraBackup

A complete and open source online backup solution for all versions of MySQL.

Non-blocking backups for maximum database performance

Ensure your applications remain fully available — and guarantee the consistency and safety of your data files — with Percona XtraBackup.

Designed to make backups a seamless procedure without disrupting the performance of your server in a production environment, Percona XtraBackup empowers you to:

Complete backups quickly and reliably
Ensure uninterrupted transaction processing during backups
Save on disk space and network bandwidth
Automate backup verification
Benefit from faster restore time and higher uptime

“Meta users create a vast amount of data every day. To make sure that data is stored reliably, we back up our databases daily. Meta was an early adopter of incremental backups in Percona XtraBackup.”

– Vamsi Ponnekanti, Meta Engineering

Key features included in Percona XtraBackup

Create hot InnoDB backups without pausing your database
Make incremental backups of MySQL
Stream compressed MySQL backups to another server
Move tables between MySQL servers on-line
Create new MySQL replication replicas easily
Backup MySQL without adding load to the server
Backup locks are a lightweight alternative to FLUSH TABLES WITH READ LOCK available in Percona Server 5.6+. Percona XtraBackup uses them automatically to copy non-InnoDB data to avoid blocking DML queries that modify InnoDB tables.
Percona XtraBackup performs throttling based on the number of IO operations per second.
Percona XtraBackup skips secondary index pages and recreates them when a compact backup is prepared.
Percona XtraBackup can export individual tables even from a full backup, regardless of the InnoDB version.
Tables exported with Percona XtraBackup can be imported into Percona Server 5.1, 5.5 or 5.6+, or MySQL 5.6+.