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 |