作為一線運維或者DBA對數(shù)據(jù)備份絕對不會陌生，MySQLdump、xtrabackup等常見備份姿勢更是非常熟悉，還有很多商業(yè)備份工具以及其他的開源備份工具，所謂的冷備、熱備、增量備份什么的，各種名詞直接晃悠的你頭疼。接下來跟著我繼續(xù)踩一遍軟件安裝的坑吧。

創(chuàng)新互聯(lián)建站專注于鳳縣網(wǎng)站建設(shè)服務(wù)及定制，我們擁有豐富的企業(yè)做網(wǎng)站經(jīng)驗。 熱誠為您提供鳳縣營銷型網(wǎng)站建設(shè)，鳳縣網(wǎng)站制作、鳳縣網(wǎng)頁設(shè)計、鳳縣網(wǎng)站官網(wǎng)定制、小程序制作服務(wù)，打造鳳縣網(wǎng)絡(luò)公司原創(chuàng)品牌,更為您提供鳳縣網(wǎng)站排名全網(wǎng)營銷落地服務(wù)。

操作系統(tǒng)：CentoS 6.7

Xtrabackup版本：2.2.13

MySQL版本：5.6.30

官網(wǎng)文檔：https://www.percona.com/doc/percona-xtrabackup/2.2/installation/yum_repo.html 

常見的安裝方式有源碼包和yum以及RPM等方式，源碼編譯什么比較麻煩，rpm包安裝可能會出現(xiàn)依賴性的問題，本文中剛開始選擇了用yum的方式，

1、Install the Percona repository

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

  根據(jù)文檔配置yum源，然后開始安裝軟件，下載什么很慢，并且出現(xiàn)以下報錯，于是我們就采取下載文件的方式

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安裝

wget

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

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包安裝的時候出現(xiàn)依賴報錯，我們檢查了yum安裝的時候出現(xiàn)的依賴軟件包，根據(jù)提示安裝相關(guān)的軟件即可，例如：

yum  install -y  perl-DBD-MySQL  perl-Time-HiRes

再執(zhí)行rpm安裝命令

rpm  -ivh   percona-xtrabackup-22-2.2.13-1.el6.x86_64.rpm

安裝成功，就可以備份測試了！