作为一线运维或者DBA对数据备份绝对不会陌生，mysqldump、xtrabackup等常见备份姿势更是非常熟悉，还有很多商业备份工具以及其他的开源备份工具，所谓的冷备、热备、增量备份什么的，各种名词直接晃悠的你头疼。接下来跟着我继续踩一遍软件安装的坑吧。
操作系统：CentoS 6.7
Xtrabackup版本：2.2.13
MySQL版本：5.6.30
官网文档：https://www.percona.com/doc/percona-xtrabackup/2.2/installation/yum_repo.html
常见的安装方式有源码包和yum以及RPM等方式，源码编译什么比较麻烦，rpm包安装可能会出现依赖性的问题，本文中刚开始选择了用yum的方式，
1、Install the Percona repository
|
1
|
yum
install
http:
//www
.percona.com
/downloads/percona-release/redhat/0
.1-3
/percona-release-0
.1-3.noarch.rpm
|
2、Testing the repository
Make sure packages are now available from the repository, by executing the following command:
yum list | grep percona
You should see output similar to the following:
... percona-xtrabackup-20.x86_64 2.0.8-587.rhel5 percona-release-x86_64 percona-xtrabackup-20-debuginfo.x86_64 2.0.8-587.rhel5 percona-release-x86_64 percona-xtrabackup-20-test.x86_64 2.0.8-587.rhel5 percona-release-x86_64 percona-xtrabackup-21.x86_64 2.1.9-746.rhel5 percona-release-x86_64 percona-xtrabackup-21-debuginfo.x86_64 2.1.9-746.rhel5 percona-release-x86_64 percona-xtrabackup-22.x86_64 2.2.13-1.el5 percona-release-x86_64 percona-xtrabackup-22-debuginfo.x86_64 2.2.13-1.el5 percona-release-x86_64 percona-xtrabackup-debuginfo.x86_64 2.3.2-1.el5 percona-release-x86_64 percona-xtrabackup-test.x86_64 2.3.2-1.el5 percona-release-x86_64 percona-xtrabackup-test-21.x86_64 2.1.9-746.rhel5 percona-release-x86_64 percona-xtrabackup-test-22.x86_64 2.2.13-1.el5 percona-release-x86_64
3、install the packages
You can now install Percona XtraBackup by running:
yum install percona-xtrabackup-22
根据文档配置yum源，然后开始安装软件，下载什么很慢，并且出现以下报错，于是我们就采取下载文件的方式
|
1
2
3
4
5
6
7
8
9
10
|
Total size: 19 M
Total download size: 4.8 M
Is this ok [y
/N
]: y
Downloading Packages:
http:
//repo
.percona.com
/release/6/RPMS/x86_64/percona-xtrabackup-22-2
.2.13-1.el6.x86_64.rpm: [Errno 14] PYCURL ERROR 18 -
"transfer closed with 884350 bytes remaining to read"
Trying other mirror.
Error Downloading Packages:
percona-xtrabackup-22-2.2.13-1.el6.x86_64: failure: percona-xtrabackup-22-2.2.13-1.el6.x86_64.rpm from percona-release-x86_64: [Errno 256] No
more
mirrors to try.
|
4、使用wget下载文件 用rpm安装
|
1
|
wget
|
|
1
2
3
4
5
|
root@username1-pc ~]
# rpm -ivh percona-xtrabackup-22-2.2.13-1.el6.x86_64.rpm
warning: percona-xtrabackup-22-2.2.13-1.el6.x86_64.rpm: Header V4 DSA
/SHA1
Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
perl(DBD::mysql) is needed by percona-xtrabackup-22-2.2.13-1.el6.x86_64
perl(Time::HiRes) is needed by percona-xtrabackup-22-2.2.13-1.el6.x86_64
|
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
percona-xtrabackup-22 x86_64 2.2.13-1.el6 percona-release-x86_64 4.8 M
Installing
for
dependencies:
Percona-Server-shared-51 x86_64 5.1.73-rel14.12.625.rhel6 percona-release-x86_64 2.1 M
perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k
perl-Time-HiRes x86_64 4:1.9721-144.el6 base 49 k
Updating
for
dependencies:
perl x86_64 4:5.10.1-144.el6 base 10 M
perl-Compress-Raw-Zlib x86_64 1:2.021-144.el6 base 70 k
perl-Compress-Zlib x86_64 2.021-144.el6 base 46 k
perl-IO-Compress-Base x86_64 2.021-144.el6 base 70 k
perl-IO-Compress-Zlib x86_64 2.021-144.el6 base 136 k
perl-Module-Pluggable x86_64 1:3.90-144.el6 base 41 k
perl-Pod-Escapes x86_64 1:1.04-144.el6 base 33 k
perl-Pod-Simple x86_64 1:3.13-144.el6 base 213 k
perl-libs x86_64 4:5.10.1-144.el6 base 579 k
perl-version x86_64 3:0.77-144.el6 base 52 k
|
在rpm包安装的时候出现依赖报错，我们检查了yum安装的时候出现的依赖软件包，根据提示安装相关的软件即可，例如：
|
1
|
yum
install
-y perl-DBD-MySQL perl-Time-HiRes
|
再执行rpm安装命令
|
1
|
rpm -ivh percona-xtrabackup-22-2.2.13-1.el6.x86_64.rpm
|
安装成功，就可以备份测试了！
本文转自 tianya1993 51CTO博客，原文链接：http://blog.51cto.com/dreamlinux/1964776，如需转载请自行联系原作者
