Percona XtraBackup Feature Comparison
The following chart compares features of Percona XtraBackup with features of MySQL Enterprise Backup (InnoDB Hot Backup):
| Feature | Percona XtraBackup | MySQL Enterprise Backup (InnoDB Hot Backup) |
|---|---|---|
| License |
GPL |
Proprietary |
| Price |
Free |
|
| Open source |
|
|
| Streaming and encryption formats |
Open source |
Proprietary |
| Supported MySQL flavors |
Percona Server, MySQL, MariaDB |
MySQL |
| Non-blocking InnoDB backups 1 |
|
|
| Blocking MyISAM backups |
|
|
| Incremental backups |
|
|
| Full compressed backups |
|
|
| Incremental compressed backups |
|
|
| Fast incremental backups 2 |
|
|
| Incremental backups with archived logs |
|
|
| Backup locks 8 |
|
|
| Encrypted backups |
|
|
| Streaming backups |
|
|
| Parallel local backups |
|
|
| Parallel streaming backups |
|
|
| Parallel compression |
|
|
| Parallel encryption |
|
|
| Parallel apply-log |
|
|
| Parallel copy-back |
|
|
| Partial backups |
|
|
| Throttling 4 |
|
|
| Point-in-time recovery support |
|
|
| Safe secondary backups |
|
|
| Compact backups 5 |
|
|
| Buffer pool state backups |
|
|
| Individual tables export |
|
|
| Individual partitions export |
|
|
| Restoring tables to a different server 7 |
|
|
| Data & index file statistics |
|
|
| InnoDB secondary indexes defragmentation |
|
|
| rsync support to minimize lock time |
|
|
| Improved FTWRL handling |
|
|
| Backup history table |
|
|
| Backup progress table |
|
|
| Offline backups |
|
|
| Backup to tape media managers |
|
|
- [1] InnoDBtables are still locked while copying non-InnoDBdata.
- [2] Fast incremental backups are supported for Percona Server with XtraDB changed page tracking enabled.
- [3] Percona XtraBackup supports encryption with any kinds of backups. MySQL Enterprise Backup only supports encryption for single-file backups.
- [4] Percona XtraBackup performs throttling based on the number of IO operations per second. MySQL Enterprise Backup supports a configurable sleep time between operations.
- [5] Percona XtraBackup skips secondary index pages and recreates them when a compact backup is prepared. MySQL Enterprise Backup skips unused pages and reinserts on the prepare stage.
- [6] Percona XtraBackup can export individual tables even from a full backup, regardless of the InnoDB version. MySQL Enterprise Backup uses InnoDB 5.6 transportable tablespaces only when performing a partial backup.
- [7] Tables exported with Percona XtraBackup can be imported into Percona Server 5.1, 5.5 or 5.6+, or MySQL 5.6+. Transportable tablespaces created with MySQL Enterprise Backup can only be imported to Percona Server 5.6+, MySQL 5.6+ or MariaDB 10.0+.
- [8] Lock table for backup
Non-blocking backups for InnoDB and XtraDB databases
Percona XtraBackup is open source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. Percona XtraBackup has been downloaded more than 800,000 times since its release.