CentOS下使用yum方式安装percona xtrabackup步骤
编辑/etc/yum.repos.d/Percona.repo,加入以下内容:
#vi /etc/yum.repos.d/Percona.repo
[percona]
name = CentOS $releasever - Percona
baseurl=http://repo.percona.com/centos/$releasever/os/$basearch/
enabled = 1
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-percona
gpgcheck = 0
进入/etc/pki/rpm-gpg目录,新建文件RPM-GPG-KEY-percona,加入如下内容:
[root@test rpm-gpg]# vi
/etc/pki/rpm-gpg/RPM-GPG-KEY-percona
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v1.4.9 (GNU/Linux)
mQGiBEsm3aERBACyB1E9ixebIMRGtmD45c6c/wi2IVIa6O3G1f6cyHH4ump6ejOi
AX63hhEs4MUCGO7KnON1hpjuNN7MQZtGTJC0iX97X2Mk+IwB1KmBYN9sS/OqhA5C
itj2RAkug4PFHR9dy21v0flj66KjBS3GpuOadpcrZ/k0g7Zi6t7kDWV0hwCgxCa2
f/ESC2MN3q3j9hfMTBhhDCsD/3+iOxtDAUlPMIH50MdK5yqagdj8V/sxaHJ5u/zw
YQunRlhB9f9QUFfhfnjRn8wjeYasMARDctCde5nbx3Pc+nRIXoB4D1Z1ZxRzR/lb
7S4i8KRr9xhommFnDv/egkx+7X1aFp1f2wN2DQ4ecGF4EAAVHwFz8H4eQgsbLsa6
7DV3BACj1cBwCf8tckWsvFtQfCP4CiBB50Ku49MU2Nfwq7durfIiePF4IIYRDZgg
kHKSfP3oUZBGJx00BujtTobERraaV7lIRIwETZao76MqGt9K1uIqw4NT/jAbi9ce
rFaOmAkaujbcB11HYIyjtkAGq9mXxaVqCC3RPWGr+fqAx/akBLQ2UGVyY29uYSBN
eVNRTCBEZXZlbG9wbWVudCBUZWFtIDxteXNxbC1kZXZAcGVyY29uYS5jb20+iGAE
ExECACAFAksm3aECGwMGCwkIBwMCBBUCCAMEFgIDAQIeAQIXgAAKCRAcTL3NzS79
Kpk/AKCQKSEgwX9r8jR+6tAnCVpzyUFOQwCfX+fw3OAoYeFZB3eu2oT8OBTiVYu5
Ag0ESybdoRAIAKKUV8rbqlB8qwZdWlmrwQqg3o7OpoAJ53/QOIySDmqy5TmNEPLm
lHkwGqEqfbFYoTbOCEEJi2yFLg9UJCSBM/sfPaqb2jGP7fc0nZBgUBnFuA9USX72
O0PzVAF7rCnWaIz76iY+AMI6xKeRy91TxYo/yenF1nRSJ+rExwlPcHgI685GNuFG
chAExMTgbnoPx1ka1Vqbe6iza+FnJq3f4p9luGbZdSParGdlKhGqvVUJ3FLeLTqt
caOn5cN2ZsdakE07GzdSktVtdYPT5BNMKgOAxhXKy11IPLj2Z5C33iVYS**TelJ
b2qHvcg9XDMhmYJyE3O4AWFh3no3Jf4ypIcABA0IAJO8ms9ov6bFqFTqA0UW2gWQ
cKFN4Q6NPV6IW0rV61ONLUc0VFXvYDtwsRbUmUYkB/L/R9fHj4lRUDbGEQrLCoE+
/HyYvr2rxP94PT6Bkjk/aiCCPAKZRj5CFUKRpShfDIiow9qxtqv7yVd514Qqmjb4
eEihtcjltGAoS54+6C3lbjrHUQhLwPGqlAh8uZKzfSZq0C06kTxiEqsG6VDDYWy6
L7qaMwOqWdQtdekKiCk8w/FoovsMYED2qlWEt0i52G+0CjoRFx2zNsN3v4dWiIhk
ZSL00Mx+g3NA7pQ1Yo5Vhok034mP8L2fBLhhWaK3LG63jYvd0HLkUFhNG+xjkpeI
SQQYEQIACQUCSybdoQIbDAAKCRAcTL3NzS79KlacAJ0aAkBQapIaHNvmAhtVjLPN
wke4ZgCePe3sPPF49lBal7QaYPdjqapa1SQ=
=qcCk
-----END PGP PUBLIC KEY BLOCK-----
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
"RPM-GPG-KEY-percona" [New] 30L, 1710C written
:wq保存退出。
接下来就可以用yum进行安装了
[root@test rpm-gpg]# yum -y install percona-xtrabackup
Loaded plugins: fastestmirror
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: centos.ustc.edu.cn
* epel: del-mirrors.extreme-ix.org
* extras: centos.ustc.edu.cn
* updates: centos.ustc.edu.cn
percona | 2.9 kB 00:00
percona/primary_db | 234 kB 00:01
Resolving Dependencies
--> Running transaction check
---> Package percona-xtrabackup.x86_64 0:2.3.10-1.el6 will be installed
--> Processing Dependency: rsync for package: percona-xtrabackup-2.3.10-1.el6.x86_64
--> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-2.3.10-1.el6.x86_64
--> Running transaction check
---> Package libev.x86_64 0:4.03-3.el6 will be installed
---> Package rsync.x86_64 0:3.0.6-12.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================================================
Installing:
percona-xtrabackup x86_64 2.3.10-1.el6 percona 5.3 M
Installing for dependencies:
libev x86_64 4.03-3.el6 epel 113 k
rsync x86_64 3.0.6-12.el6 base 335 k
Transaction Summary
=============================================================================================================================================================
Install 3 Package(s)
Total download size: 5.8 M
Installed size: 6.1 M
Downloading Packages:
(1/3): libev-4.03-3.el6.x86_64.rpm | 113 kB 00:01
(2/3): percona-xtrabackup-2.3.10-1.el6.x86_64.rpm | 5.3 MB 00:07
(3/3): rsync-3.0.6-12.el6.x86_64.rpm | 335 kB 00:00
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 531 kB/s | 5.8 MB 00:11
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID 0608b895: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-6
Importing GPG key 0x0608B895:
Userid : EPEL (6)
Package: epel-release-6-8.noarch (@extras)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-6
warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-percona
Importing GPG key 0xCD2EFD2A:
Userid: "Percona
MySQL Development Team "
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-percona
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : libev-4.03-3.el6.x86_64 1/3
Installing : rsync-3.0.6-12.el6.x86_64 2/3
Installing : percona-xtrabackup-2.3.10-1.el6.x86_64 3/3
Verifying : rsync-3.0.6-12.el6.x86_64 1/3
Verifying : libev-4.03-3.el6.x86_64 2/3
Verifying : percona-xtrabackup-2.3.10-1.el6.x86_64 3/3
Installed:
percona-xtrabackup.x86_64 0:2.3.10-1.el6
Dependency Installed:
libev.x86_64 0:4.03-3.el6 rsync.x86_64 0:3.0.6-12.el6
Complete!
[root@test rpm-gpg]# yum -y install percona-toolkit
Loaded plugins: fastestmirror
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: centos.ustc.edu.cn
* epel: del-mirrors.extreme-ix.org
* extras: centos.ustc.edu.cn
* updates: centos.ustc.edu.cn
Resolving Dependencies
--> Running transaction check
---> Package percona-toolkit.x86_64 0:3.0.9-1.el6 will be installed
--> Processing Dependency: perl(IO::Socket::SSL) for package: percona-toolkit-3.0.9-1.el6.x86_64
--> Running transaction check
---> Package perl-IO-Socket-SSL.noarch 0:1.31-3.el6_8.2 will be installed
--> Processing Dependency: perl-Net-SSLeay >= 1.35-10.el6_8.1 for package: perl-IO-Socket-SSL-1.31-3.el6_8.2.noarch
--> Processing Dependency: perl(Net::LibIDN) for package: perl-IO-Socket-SSL-1.31-3.el6_8.2.noarch
--> Running transaction check
---> Package perl-Net-LibIDN.x86_64 0:0.12-3.el6 will be installed
---> Package perl-Net-SSLeay.x86_64 0:1.35-10.el6_8.1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================================================
Installing:
percona-toolkit x86_64 3.0.9-1.el6 percona 7.1 M
Installing for dependencies:
perl-IO-Socket-SSL noarch 1.31-3.el6_8.2 base 70 k
perl-Net-LibIDN x86_64 0.12-3.el6 base 35 k
perl-Net-SSLeay x86_64 1.35-10.el6_8.1 base 174 k
Transaction Summary
=============================================================================================================================================================
Install 4 Package(s)
Total download size: 7.4 M
Installed size: 7.9 M
Downloading Packages:
(1/4): percona-toolkit-3.0.9-1.el6.x86_64.rpm | 7.1 MB 00:19
(2/4): perl-IO-Socket-SSL-1.31-3.el6_8.2.noarch.rpm | 70 kB 00:00
(3/4): perl-Net-LibIDN-0.12-3.el6.x86_64.rpm | 35 kB 00:00
(4/4): perl-Net-SSLeay-1.35-10.el6_8.1.x86_64.rpm | 174 kB 00:00
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 352 kB/s | 7.4 MB 00:21
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : perl-Net-LibIDN-0.12-3.el6.x86_64 1/4
Installing : perl-Net-SSLeay-1.35-10.el6_8.1.x86_64 2/4
Installing : perl-IO-Socket-SSL-1.31-3.el6_8.2.noarch 3/4
Installing : percona-toolkit-3.0.9-1.el6.x86_64 4/4
Verifying : percona-toolkit-3.0.9-1.el6.x86_64 1/4
Verifying : perl-Net-SSLeay-1.35-10.el6_8.1.x86_64 2/4
Verifying : perl-Net-LibIDN-0.12-3.el6.x86_64 3/4
Verifying : perl-IO-Socket-SSL-1.31-3.el6_8.2.noarch 4/4
Installed:
percona-toolkit.x86_64 0:3.0.9-1.el6
Dependency Installed:
perl-IO-Socket-SSL.noarch 0:1.31-3.el6_8.2 perl-Net-LibIDN.x86_64 0:0.12-3.el6 perl-Net-SSLeay.x86_64 0:1.35-10.el6_8.1
Complete!
[root@test rpm-gpg]# innobackupex --version
innobackupex version 2.3.10 Linux (x86_64) (revision id: bd0d4403f36)
[root@test rpm-gpg]# pt-online-schema-change --version
pt-online-schema-change 3.0.8