关于Percona XtraBackup
Percona XtraBackup是全球唯一免费的MySQL热备软件,它实现了InnoDB和XtraDB数据库引擎的无阻塞热备。
掌握 Percona XtraBackup你可以获取下面一些优势:
① 备份过程迅速、可靠,
②在备份过程中的事务等原子操作不会被打断,
③节省磁盘空间和网络带宽,
④自动备份验证,
⑤能够更快更安全的恢复备份。
Percona XtraBackup 对MySQL的衍生版本都适用,包括 Percona Server,MySQL和 MariaDB,并且在每个版本上表现都能流畅、高效,实现增量备份这个特性功能。
MySQL Backup Tool Feature(工具特色)
License GPL 许可证遵守GPLPrice Free 免费
Streaming and encryption formats Open source 流式操作和压缩技术开源
Supported MySQL flavors MySQL, Percona Server, MariaDB, Percona XtraDB Cluster, MariaDB
Supported operating systems Linux
Non-blocking InnoDB backups Yes InnoDB表无阻塞备份
Blocking MyISAM backups Yes innobackupex集成了MyISAM等其他引擎备份方法,不过要注意会阻塞
Incremental backups Yes 支持增量备份
Full compressed backups Yes 支持全备压缩备份
Incremental compressed backups Yes 支持增量压缩备份
Fast incremental backups Yes 支持快速增量备份
Incremental backups with archived logs feature in Percona Server Yes
Incremental backups with REDO log only
Backup locks Yes
Encrypted backups Yes
Streaming backups Yes
Parallel local backups Yes
Parallel compression Yes
Parallel encryption Yes
Parallel apply-log Yes
Parallel copy-back Partial backups Yes 支持并行复制
Partial backups of individual partitions Yes 支持单独数据库备份
Throttling Yes
Backup image validation
Point-in-time recovery support Yes 支持时间点恢复
Safe slave backups Yes
Compact backups Yes
Buffer pool state backups Yes
Individual tables export Yes
Individual partitions export Yes
Restoring tables to a different server Yes 支持异地恢复备份
Data & index file statistics Yes
InnoDB secondary indexes defragmentation Yes 支持InnoDB secondary indexes碎片整理
rsync support to minimize lock time Yes
Improved FTWRL handling Yes
Backup history table Yes
Backup progress table
Offline backups Backup to tape media managers
Cloud backups support
External graphical user interfaces to backup/recovery Zmanda Recovery Manager for MySQL
What are the features of Percona XtraBackup?(这些特性是什么,拥有这些特性我们能做什么事?)
①创建一个InnoDB的热备数据时不需要终止数据库服务②实现MySQL增量备份
③可以流式压缩备份到另一台机器
④在线移动表数据
⑤更简单容易的创建主从
⑥备份并不会增加服务器的负载
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29418060/viewspace-1673318/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29418060/viewspace-1673318/