作为一线运维或者DBA对数据备份绝对不会陌生,mysqldump、xtrabackup等常见备份姿势更是非常熟悉,还有很多商业备份工具以及其他的开源备份工具,所谓的冷备、热备、增量备份什么的,各种名词直接晃悠的你头疼。接下来跟着我继续踩一遍软件安装的坑吧。
创新互联致力于互联网品牌建设与网络营销,包括网站制作、网站设计、SEO优化、网络推广、整站优化营销策划推广、电子商务、移动互联网营销等。创新互联为不同类型的客户提供良好的互联网应用定制及解决方案,创新互联核心团队十多年专注互联网开发,积累了丰富的网站经验,为广大企业客户提供一站式企业网站建设服务,在网站建设行业内树立了良好口碑。操作系统: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
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm2、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源,然后开始安装软件,下载什么很慢,并且出现以下报错,于是我们就采取下载文件的方式
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安装
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: 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_64percona-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安装的时候出现的依赖软件包,根据提示安装相关的软件即可,例如:
yum install -y perl-DBD-MySQL perl-Time-HiRes再执行rpm安装命令
rpm -ivh percona-xtrabackup-22-2.2.13-1.el6.x86_64.rpm安装成功,就可以备份测试了!
另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。