Shulou(Shulou.com)06/01 Report--

As a front-line operation and maintenance staff or DBA is no stranger to data backup, mysqldump, xtrabackup and other common backup postures are even more familiar. There are many commercial backup tools and other open source backup tools, such as cold backup, hot backup, incremental backup and so on. Various nouns directly give you a headache. Next, follow me to continue to step on the software installation pit.

Operating system: CentoS 6.7

Xtrabackup version: 2.2.13

MySQL version: 5.6.30

Official website document: https://www.percona.com/doc/percona-xtrabackup/2.2/installation/yum_repo.html

The common installation methods are source code package, yum and RPM, etc. What is more troublesome to compile source code? there may be dependency problems in rpm package installation. At the beginning of this article, we choose to use 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_64percona-xtrabackup-20-debuginfo.x86_64 2.0.8-587.rhel5 percona-release-x86_64percona-xtrabackup-20-test.x86_64 2.0.8-587.rhel5 percona-release-x86_64percona-xtrabackup-21.x86_64 2.1.9-746.rhel5 percona-release-x86_64percona-xtrabackup-21-debuginfo.x86_64 2.1.9-746.rhel5 percona-release-x86_64percona-xtrabackup-22.x86_64 2.2.13-1.el5 percona-release-x86_64percona-xtrabackup-22-debuginfo.x86_64 2.2.13-1. El5 percona-release-x86_64percona-xtrabackup-debuginfo.x86_64 2.3.2-1.el5 percona-release-x86_64percona-xtrabackup-test.x86_64 2.3.2-1.el5 percona-release-x86_64percona-xtrabackup-test-21.x86_64 2.1.9-746.rhel5 percona-release -x86_64percona-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

Configure the yum source according to the documentation, and then start to install the software, download what is slow, and the following error occurs, so we take the way to download the file

Total size: 19 MTotal download size: 4.8 MIs this ok [y Errno N]: yDownloading 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. Download files using wget and install them with rpm

Wgetroot@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: NOKEYerror: 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_64percona-xtrabackup-22 x86 million 64 2.2.13-1.el6 percona -release-x86_64 4.8MInstalling for dependencies: Percona-Server-shared-51 x86'64 5.1.73-rel14.12.625.rhel6 percona-release-x86_64 2.1m perl-DBD-MySQL x86'64 4.013-3.el6 Base 134k perl-Time-HiRes x86x644 144.el6 base 1.9721-144.el6 base 49 kUpdating for dependencies: perl x86_ 64 4144.el6 base 5.10.1-144.el6 base 10m perl-Compress-Raw-Zlib x8628 64 1purl 2.021-144.el6 base 70k perl-Compress- Zlib x86164 2.021-144.el6 base 46k perl-IO-Compress-Base x86164 2.021-144.el6 base 70k perl-IO-Compress-Zlib x861464 2.021-144.el6 base 136k perl-Module-Pluggable x861561purl 3.90-144.el6 base 41k perl-Pod-Escapes x861461perl-Pod-Simple 1.04-144.el6 base 33k perl-Pod-Simple x861561purl 3.13-144.el6 Base 213k perl-libs x861164purl 5.10.1-144.el6 base 579k perl-version x862864 3Ru 0.77-144.el6 base 52k

A dependency error occurred during the installation of the rpm package. We checked the dependent packages that appeared during the installation of yum, and installed the relevant software according to the prompts, for example:

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

Then execute the rpm installation command

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

If the installation is successful, you can back up the test!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.