在Red Hat Enterprise Linux Server release 5.7 (Tikanga)上使用RPM方式安装Percona Xtrabackup 2.4.6时遇到了一些问题,特意总结在此。
Percona XtraBackup 安装介绍篇 http://www.linuxidc.com/Linux/2017-07/145638.htm
[root@DB-Server tmp]#yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL
安装相关依赖组件时,遇到conflict with file的错误,如上截图所示,然后安装Percona Xtrabackup 2.4.6是就会遇到下面错误:
[root@DB-Server tmp]# rpm -ivh percona-xtrabackup-24-2.4.6-2.el5.x86_64.rpm
warning: percona-xtrabackup-24-2.4.6-2.el5.x86_64.rpm: Header V4 DSA signature: NOKEY, key ID cd2efd2a
error: Failed dependencies:
libev.so.4()(64bit) is needed by percona-xtrabackup-24-2.4.6-2.el5.x86_64
perl(DBD::mysql) is needed by percona-xtrabackup-24-2.4.6-2.el5.x86_64
如上所示,既然缺少组件,那么安装libev.x86_64, 如下所示,本地yum源安装libev.so.4失败,只能从网上下载libev-4.15-1.el5.rf.x86_64.rpm,网址为
可以到Linux公社资源站下载:
------------------------------------------分割线------------------------------------------
免费下载地址在 http://linux.linuxidc.com/
用户名与密码都是www.linuxidc.com
具体下载目录在 /2017年资料/7月/13日/RHEL 5.7 使用rpm安装XtraBackup问题总结/
下载方法见 http://www.linuxidc.com/Linux/2013-07/87684.htm
------------------------------------------分割线------------------------------------------
[root@DB-Server tmp]# yum -y install libev.x86_64
Loaded plugins: product-id, security, subscription-manager
Updating Red Hat repositories.
Setting up Install Process
No package libev.x86_64 available.
Nothing to do
[root@DB-Server tmp]# rpm -ivh libev-4.15-1.el5.rf.x86_64.rpm
warning: libev-4.15-1.el5.rf.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 6b8d79e6
Preparing... ########################################### [100%]
1:libev ########################################### [100%]
[root@DB-Server tmp]# yum list | grep "perl-DBD-MySQL"
perl-DBD-MySQL.x86_64 3.0007-2.el5 media
[root@DB-Server tmp]# yum install perl-DBD-MySQL
安装 perl-DBD-MySQL时,就会遇到大量类似下面错误
file /usr/bin/msql2mysql from install of mysql-5.0.77-4.el5_6.6.x86_64 conflicts with file from package MySQL-client-advanced-5.6.20-1.rhel5.x86_64
file /usr/bin/mysql from install of mysql-5.0.77-4.el5_6.6.x86_64 conflicts with file from package MySQL-client-advanced-5.6.20-1.rhel5.x86_64
file /usr/bin/mysql_find_rows from install of mysql-5.0.77-4.el5_6.6.x86_64 conflicts with file from package MySQL-client-advanced-5.6.20-1.rhel5.x86_64
file /usr/bin/mysql_waitpid from install of mysql-5.0.77-4.el5_6.6.x86_64 conflicts with file from package MySQL-client-advanced-5.6.20-1.rhel5.x86_64
file /usr/bin/mysqlaccess from install of mysql-5.0.77-4.el5_6.6.x86_64 conflicts with file from package MySQL-client-advanced-5.6.20-1.rhel5.x86_64
遇到这个错误是因为没有安装MySQL-shared-compat组件,安装了MySQL-shared-compat-advanced-5.6.20-1.rhel5.x86_64.rpm后,然后使用yum install perl-DBD-MySQL就不会遇到conflict with file的错误
[root@DB-Server tmp]# rpm -qa | grep -i mysql
MySQL-server-advanced-5.6.20-1.rhel5
MySQL-client-advanced-5.6.20-1.rhel5
[root@DB-Server tmp]# rpm -ivh MySQL-shared-compat-advanced-5.6.20-1.rhel5.x86_64.rpm
Preparing... ########################################### [100%]
1:MySQL-shared-compat-adv########################################### [100%]
[root@DB-Server tmp]# yum install perl-DBD-MySQL
[root@DB-Server tmp]# rpm -ivh percona-xtrabackup-24-2.4.6-2.el5.x86_64.rpm
warning: percona-xtrabackup-24-2.4.6-2.el5.x86_64.rpm: Header V4 DSA signature: NOKEY, key ID cd2efd2a
Preparing... ########################################### [100%]
1:percona-xtrabackup-24 ########################################### [100%]
[root@DB-Server tmp]#
更多XtraBackup相关教程见以下内容:
MySQL管理之使用XtraBackup进行热备 http://www.linuxidc.com/Linux/2014-04/99671.htm
使用Xtrabackup进行MySQL备份 http://www.linuxidc.com/Linux/2016-11/137734.htm
MySQL开源备份工具Xtrabackup备份部署 http://www.linuxidc.com/Linux/2013-06/85627.htm
MySQL Xtrabackup备份和恢复 http://www.linuxidc.com/Linux/2011-12/50275.htm
Percona Xtrabackup 安装 http://www.linuxidc.com/Linux/2016-11/137735.htm
使用XtraBackup 备份MySQL数据库 http://www.linuxidc.com/Linux/2016-12/138688.htm
使用Xtrabackup进行MySQL数据库全备和全备还原 http://www.linuxidc.com/Linux/2016-11/137736.htm
XtraBackup备份原理和实战详解 http://www.linuxidc.com/Linux/2017-04/142477.htm
Percona XtraBackup 实现全备&增量备份与恢复 http://www.linuxidc.com/Linux/2017-03/142380.htm
来源: http://www.linuxidc.com/Linux/2017-07/145637.htm