Percona XtraBackup介绍

Percona XtraBackup开源的、免费的mysql热备软件，可以执行无阻塞备份InnoDB和XtraDB数据库。

 

Percona XtraBackup有以下优点：

·备份快速、可靠 ·备份期间，不影响事务连续性

·节省磁盘空间和网络带宽

·自动验证备份

·快速还原，降低系统停机时间

Percona XtraBackup支持Percona Server, MySQL, 和MariaDB所有版本的热备。支持流、压缩和增量mysql备份。

 

Percona XtraBackup的一些特性：

·创建innodb的hot备份，不需要停数据库

·增量备份mysql

·支持流压缩，将mysql并备份到其他服务器上

·在不同mysql服务器上，在线移动表

·易于创建mysql复制slaves

·备份mysql时，不会增加负载

 

Percona XtraBackup包含以下工具：

·innobackupex ： 提供了一个脚本集合，可以备份整个mysql数据库实例（包含myisam、innodb和xtradb表的数据库）。

·xtrabackup ： 编译过的c二进制文件，只能copy innodb和xtradb的数据

·xbcrypt ： 加密和解密备份文件

·xbstream ： 支持stream和文件抽取的工具（以xbstream格式抽取）

 

Percona XtraBackup和MySQL Enterprise Backup特性比较

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 [1]	Yes	Yes
Blocking MyISAM backups	Yes	Yes
Incremental backups	Yes	Yes
Full compressed backups	Yes	Yes
Incremental compressed backups	Yes
Fast incremental backups [2]	Yes
Incremental backups with archived logs	Yes
Encrypted backups	Yes	Yes [3]
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 [4]	Yes	Yes
Point-in-time recovery support	Yes	Yes
Safe slave backups	Yes
Compact backups [5]	Yes	Yes
Buffer pool state backups	Yes
Individual tables export	Yes	Yes [6]
Individual partitions export	Yes
Restoring tables to a different server [7]	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