安装perl-DBD-MySQL报错：Requires: libmysqlclient.so.18

问题：通过源码安装pt-table-sync和pt-table-checksum时，perl Makefile.PL执行异常。

安装perl-DBD-MySQL过程报错：

# yum install -y perl-DBD-MySQL
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.023-6.el7 will be installed
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.64-1.el7 will be installed
Removing mariadb-libs.x86_64 1:5.5.64-1.el7 - u due to obsoletes from installed mysql-community-libs-5.7.19-1.el7.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.64-1.el7 will be installed
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.60-1.el7_5 will be installed
Removing mariadb-libs.x86_64 1:5.5.60-1.el7_5 - u due to obsoletes from installed mysql-community-libs-5.7.19-1.el7.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.60-1.el7_5 will be installed
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.56-2.el7 will be installed
Removing mariadb-libs.x86_64 1:5.5.56-2.el7 - u due to obsoletes from installed mysql-community-libs-5.7.19-1.el7.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.56-2.el7 will be installed
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64
--> Finished Dependency Resolution
Error: Package: perl-DBD-MySQL-4.023-6.el7.x86_64 (base-el7)
           Requires: libmysqlclient.so.18(libmysqlclient_18)(64bit)
Error: Package: perl-DBD-MySQL-4.023-6.el7.x86_64 (base-el7)
           Requires: libmysqlclient.so.18()(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

解决方案：

1、从官网下载对应环境的rpm包  Software Downloads - Percona

2、按顺序安装rpm包

# rpm -ivh Percona-XtraDB-Cluster-shared-compat-57-5.7.28-31.41.2.el7.x86_64.rpm
warning: Percona-XtraDB-Cluster-shared-compat-57-5.7.28-31.41.2.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:Percona-XtraDB-Cluster-shared-com################################# [100%]

# rpm -ivh Percona-XtraDB-Cluster-shared-57-5.7.28-31.41.2.el7.x86_64.rpm
warning: Percona-XtraDB-Cluster-shared-57-5.7.28-31.41.2.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY
Preparing...                          ################################# [100%]

3、安装perl-DBD-MySQL

# yum install -y perl-DBD-MySQL
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.023-6.el7 will be installed
--> Finished Dependency Resolution

...

Warning: RPMDB altered outside of yum.
  Installing : perl-DBD-MySQL-4.023-6.el7.x86_64                                                                                                                                                              1/1 
  Verifying  : perl-DBD-MySQL-4.023-6.el7.x86_64                                                                                                                                                              1/1 

Installed:
  perl-DBD-MySQL.x86_64 0:4.023-6.el7                                                                                                                                                                             

Complete!

解决。