Percona Xtrabackup

1.1关于Percona Xtrabackup

Percona Xtrabackup是目前唯一一款开源，免费的mysql热备软件，它可以对InnoDB和XtraDB数据库执行无阻塞（non-blocking）的备份操作。

使用Percona Xtrabackup可以获得以下好处：

• 快速、可靠完成备份
• 备份期间不间断事务处理
• 节省磁盘空间和网络带宽
• 自动备份校验
• 快速恢复保证更高的运行时间

Percona Xtrabackup适用于所有版本的Percona Server, MySQL, and MariaDB的热备份，它可以执行连续，压缩和增量的mysql备份。它完全支持对InnoDB，XtraDB andHailDB存储引擎的无阻塞备份，另外它可以对MyISAM , Merge and Archive存储引擎实现备份，但在备份结束时要有短暂的写锁。备份内容包括分区表、触发器和数据库其他附件（and database options）。

MySQL Backup Tool Feature Comparison

Features	Percona XtraBackup	MySQL Enterprise Backup (InnoDB Hot Backup)
License	GPL	Proprietary
Price	Free	$5000 per server
Open source	Yes
Streaming and encryption formats	Open source	Proprietary
Supported MySQL flavors	Percona Server, MySQL, MariaDB	MySQL
Non-blocking InnoDB backups	Yes	Yes
Blocking MyISAM backups	Yes	Yes
Incremental backups	Yes	Yes
Full compressed backups	Yes	Yes
Incremental compressed backups	Yes
Fast incremental backups	Yes
Incremental backups with archived logs	Yes
Encrypted backups	Yes	Yes
Streaming backups	Yes	Yes
Parallel local backups	Yes	Yes
Parallel streaming backups	Yes
Parallel compression	Yes	Yes
Parallel encryption	Yes	Yes
Parallel apply-log	Yes
Parallel copy-back		Yes
Partial backups	Yes	Yes
Throttling	Yes	Yes
Point-in-time recovery support	Yes	Yes
Safe slave backups	Yes
Compact backups	Yes	Yes
Buffer pool state backups	Yes
Individual tables export	Yes	Yes
Individual partitions export	Yes
Restoring tables to a different server	Yes	Yes
Data & index file statistics	Yes
InnoDB secondary indexes defragmentation	Yes
rsync support to minimize lock time	Yes
Improved FTWRL handling	Yes
Backup history table		Yes
Backup progress table		Yes
Offline backups		Yes
Tape backups with Oracle Secure Backup		Yes

What are the features of Percona XtraBackup?