Buy Percona ServicesBuy Now!

Percona XtraBackup Feature Comparison

Percona XtraBackup is an open source, free MySQL® hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. It has been downloaded over 800,000 times since its release.

Feature Percona XtraBackup MySQL Enterprise Backup
(InnoDB Hot Backup)
License GPL Proprietary
Price Free Included in subscription at $5000 per Server
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 3
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 slave backups
Compact backups 5
Buffer pool state backups
Individual tables export 6
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
Tape backups with Oracle Secure Backup
  • [1] InnoDB tables are still locked while copying non-InnoDB data.
  • [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] Backup locks is 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.




General Inquiries

For general inquiries, please send us your question and someone will contact you.