enterprise backup和xtrabackup是都是用来做mysql物理备份的
enterprise backup,需要从oracle购买mysql enterprise
xtrabackup是第三方percona公司的产品,物理备份工具
支持流、增量、压缩、多线程(并行)等功能
对innodb支持全量和增量,对myisam仅支持全量
xtrabackup 8.0仅支持mysql 8.0,xtrabackup 2.4支持mysql5.7
percona官网下载软件包
percona-xtrabackup-24-2.4.20-1.el6.x86_64.rpm
percona-xtrabackup-80-8.0.13-1.el6.x86_64.rpm
强行安装:rpm -ivh --nodeps percona-xtrabackup-80-8.0.13-1.el6.x86_64.rpm
安装完成后就可以直接使用xtrabackup命令
xtrabackup特点
1 物理备份
2 支持热备份
3 支持增量备份
4 支持快追踪(仅xtraDB)
xtrabackup rpm包包含的命令(用xtrabackup就足够了):
a compiled C binary that provides functionality to backup a whole MySQL database instance with MyISAM, InnoDB, and XtraDBtables.
utility used for encrypting and decrypting backup files.
utility that allows streaming and extracting files to/from the xbstream format.
utility used for downloading and uploading full or part of xbstream archive from/to cloud.
innobackupex是xtrabackup的perl整合脚本,功能更强大