[MySQL] CentOS7安装percona-xtrabackup时/etc/my.cnf冲突报错解决

系统管理员 2022-06-07 07:17 409阅读 0赞

环境：  
CentOS7.3 + mysql-community-5.7

[root@mysql-02 ~]# cat /etc/redhat-release
    CentOS Linux release 7.3.1611 (Core)
    [root@mysql-lh02 ~]# rpm -qa | grep -i mysql
    perl-DBD-MySQL-4.023-5.el7.x86_64
    mysql-community-client-5.7.19-1.el7.x86_64
    mysql-community-libs-compat-5.7.19-1.el7.x86_64
    mysql-community-common-5.7.19-1.el7.x86_64
    mysql-community-server-5.7.19-1.el7.x86_64
    [root@mysql-02 ~]#

安装percona-xtrabackup时冲突报错

[root@mysql-02 ~]# yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm
    [root@mysql-lh02 ~]# yum list | grep percona-xtrabackup
    percona-xtrabackup.x86_64                   2.3.9-1.el7                percona-release-x86_64
    percona-xtrabackup-22.x86_64                2.2.13-1.el7               percona-release-x86_64
    percona-xtrabackup-22-debuginfo.x86_64      2.2.13-1.el7               percona-release-x86_64
    percona-xtrabackup-24.x86_64                2.4.8-1.el7                percona-release-x86_64
    percona-xtrabackup-24-debuginfo.x86_64      2.4.8-1.el7                percona-release-x86_64
    percona-xtrabackup-debuginfo.x86_64         2.3.9-1.el7                percona-release-x86_64
    percona-xtrabackup-test.x86_64              2.3.9-1.el7                percona-release-x86_64
    percona-xtrabackup-test-22.x86_64           2.2.13-1.el7               percona-release-x86_64
    percona-xtrabackup-test-24.x86_64           2.4.8-1.el7                percona-release-x86_64
    [root@mysql-02 ~]# yum install percona-xtrabackup-24
    Loaded plugins: fastestmirror, langpacks
    Loading mirror speeds from cached hostfile
    Resolving Dependencies
    --> Running transaction check
    ---> Package percona-xtrabackup-24.x86_64 0:2.4.8-1.el7 will be installed
    --> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-24-2.4.8-1.el7.x86_64
    --> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-24-2.4.8-1.el7.x86_64
    --> Running transaction check
    ---> Package libev.x86_64 0:4.15-7.el7 will be installed
    ---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed
    --> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-5.el7.x86_64
    --> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-5.el7.x86_64
    --> Running transaction check
    ---> Package Percona-Server-shared-56.x86_64 0:5.6.37-rel82.2.el7 will be installed
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    =============================================================================================
     Package                     Arch      Version               Repository                 Size
    =============================================================================================
    Installing:
     percona-xtrabackup-24       x86_64    2.4.8-1.el7           percona-release-x86_64    7.4 M
    Installing for dependencies:
     Percona-Server-shared-56    x86_64    5.6.37-rel82.2.el7    percona-release-x86_64    618 k
     libev                       x86_64    4.15-7.el7            extras                     44 k
     perl-DBD-MySQL              x86_64    4.023-5.el7           base                      140 k
    
    Transaction Summary
    =============================================================================================
    Install  1 Package (+3 Dependent packages)
    
    Total download size: 8.1 M
    Installed size: 35 M
    Is this ok [y/d/N]: y
    Downloading packages:
    (1/4): libev-4.15-7.el7.x86_64.rpm                                    |  44 kB  00:00:02    
    (2/4): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm                          | 140 kB  00:00:02    
    warning: /var/cache/yum/x86_64/7/percona-release-x86_64/packages/Percona-Server-shared-56-5.6.37-rel82.2.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
    Public key for Percona-Server-shared-56-5.6.37-rel82.2.el7.x86_64.rpm is not installed
    (3/4): Percona-Server-shared-56-5.6.37-rel82.2.el7.x86_64.rpm         | 618 kB  00:00:05    
    (4/4): percona-xtrabackup-24-2.4.8-1.el7.x86_64.rpm                   | 7.4 MB  00:00:33    
    ---------------------------------------------------------------------------------------------
    Total                                                        250 kB/s | 8.1 MB  00:00:33    
    Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Percona
    Importing GPG key 0xCD2EFD2A:
     Userid     : "Percona MySQL Development Team <mysql-dev@percona.com>"
     Fingerprint: 430b df5c 56e7 c94e 848e e60c 1c4c bdcd cd2e fd2a
     Package    : percona-release-0.1-4.noarch (installed)
     From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-Percona
    Is this ok [y/N]: y
    Running transaction check
    Running transaction test
    
    
    Transaction check error:
      file /etc/my.cnf from install of Percona-Server-shared-56-5.6.37-rel82.2.el7.x86_64 conflicts with file from package mysql-community-server-5.7.19-1.el7.x86_64
    
    Error Summary
    -------------
    
    [root@mysql-02 ~]#

解决办法：

补充安装

[root@mysql-02 ~]# rpm -ivh mysql-community-libs-compat-5.7.19-1.el7.x86_64.rpm
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:mysql-community-libs-compat-5.7.1################################# [100%]
    [root@mysql-02 ~]#

然后再次安装percona-xtrabackup成功

[root@mysql-02 ~]# yum install percona-xtrabackup-24
    Loaded plugins: fastestmirror, langpacks
    Loading mirror speeds from cached hostfile
    Resolving Dependencies
    --> Running transaction check
    ---> Package percona-xtrabackup-24.x86_64 0:2.4.8-1.el7 will be installed
    --> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-24-2.4.8-1.el7.x86
    --> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-24-2.4.8-1.el7._64
    --> Running transaction check
    ---> Package libev.x86_64 0:4.15-7.el7 will be installed
    ---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ==============================================================================================
     Package                     Arch         Version             Repository                    Si
    ==============================================================================================
    Installing:
     percona-xtrabackup-24       x86_64       2.4.8-1.el7         percona-release-x86_64       7.4
    Installing for dependencies:
     libev                       x86_64       4.15-7.el7          extras                        44
     perl-DBD-MySQL              x86_64       4.023-5.el7         base                         140
    
    Transaction Summary
    ==============================================================================================
    Install  1 Package (+2 Dependent packages)
    
    Total size: 7.5 M
    Installed size: 31 M
    Is this ok [y/d/N]: y
    Downloading packages:
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
    Warning: RPMDB altered outside of yum.
    ** Found 3 pre-existing rpmdb problem(s), 'yum check' output follows:
    ipa-client-4.4.0-12.el7.centos.x86_64 has installed conflicts freeipa-client: ipa-client-4.4.0.el7.centos.x86_64
    ipa-client-common-4.4.0-12.el7.centos.noarch has installed conflicts freeipa-client-common: iplient-common-4.4.0-12.el7.centos.noarch
    ipa-common-4.4.0-12.el7.centos.noarch has installed conflicts freeipa-common: ipa-common-4.4.0.el7.centos.noarch
      Installing : libev-4.15-7.el7.x86_64                                                       1
      Installing : perl-DBD-MySQL-4.023-5.el7.x86_64                                             2
      Installing : percona-xtrabackup-24-2.4.8-1.el7.x86_64                                      3
      Verifying  : perl-DBD-MySQL-4.023-5.el7.x86_64                                             1
      Verifying  : percona-xtrabackup-24-2.4.8-1.el7.x86_64                                      2
      Verifying  : libev-4.15-7.el7.x86_64                                                       3
    
    Installed:
      percona-xtrabackup-24.x86_64 0:2.4.8-1.el7                                                 
    
    Dependency Installed:
      libev.x86_64 0:4.15-7.el7                  perl-DBD-MySQL.x86_64 0:4.023-5.el7             
    
    Complete!
    [root@mysql-02 ~]#