mysql 备份工具 Percona XtraBackup

2018年7月4日 0 条评论 271 次阅读 0 人点赞

说明:

下载地址: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/

Sevenfal

这个人太懒什么东西都没留下

文章评论(0)