mysql 备份工具 Percona XtraBackup

说明：

下载地址：https://www.percona.com/downloads/XtraBackup/LATEST/

手册说明：https://www.percona.com/doc/percona-xtrabackup/LATEST/index.html

原理介绍：http://www.cnblogs.com/zhoujinyi/p/5888271.html

下载了完整包，解压后看介绍：

The percona-xtrabackup-24 package contains the latest Percona XtraBackup GA binaries and associated files.

The percona-xtrabackup-24-debuginfo package contains the debug symbols for binaries in percona-xtrabackup-24.

The percona-xtrabackup-test-24 package contains the test suite for Percona XtraBackup.

The percona-xtrabackup-2x package contains the older version of the Percona XtraBackup.

安装：

这里直接安装

rpm -ivh percona-xtrabackup-24-2.4.6-2.el6.x86_64.rpm

warning: percona-xtrabackup-24-2.4.6-2.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
libev.so.4()(64bit) is needed by percona-xtrabackup-24-2.4.6-2.el6.x86_64
perl(DBD::mysql) is needed by percona-xtrabackup-24-2.4.6-2.el6.x86_64
rsync is needed by percona-xtrabackup-24-2.4.6-2.el6.x86_64

提示如上，首先安装libev，在 http://rpmfind.net/linux/rpm2html/search.php?query=libev&submit=Search+...&system=&arch= 

搜索下载 ftp://rpmfind.net/linux/dag/redhat/el6/en/x86_64/dag/RPMS/libev-4.15-1.el6.rf.x86_64.rpm

rpm -ivh libev-4.15-1.el6.rf.x86_64.rpm 
yum install "perl(DBD::mysql)"
yum install rsync
rpm -ivh percona-xtrabackup-24-2.4.6-2.el6.x86_64.rpm

备份：

完全备份：

xtrabackup --user=root --password=password --backup --target-dir=/data/backups/