LP #1031427: Painful Yum dependencies on CentOS6.3

**Reported in Launchpad by Ryan Lowe last update 18-01-2018 08:15:51

(Probably a Percona-Server packaging issue, but reporting it here because it manifests in a percona-toolkit install)

I have a stock CentOS6.3 install

%> cat /etc/centos-release
CentOS release 6.3 (Final)

%> uname -r
2.6.32-220.el6.x86_64

With the Percona Yum repository package:

%> yum info percona-release
Loaded plugins: fastestmirror, priorities, security
Loading mirror speeds from cached hostfile

• base: mirror.stanford.edu
• extras: mirrors.kernel.org
• updates: mirrors.kernel.org
  68 packages excluded due to repository priority protections
  Installed Packages
  Name : percona-release
  Arch : x86_64
  Version : 0.0
  Release : 1
  Size : 3.6 k
  Repo : installed
  Summary : Percona RPM repository
  URL : http://www.percona.com/percona-lab.html
  License : GPL version 2
  Description : Percona release file. This package contains yum
  : configuration for the Percona RPM Repository, as well as the public
  : GPG keys used to sign them.

I have the following packages installed:

%> rpm -qa |grep -i percona
Percona-Server-client-55-5.5.25a-rel27.1.277.rhel6.x86_64
percona-release-0.0-1.x86_64
Percona-Server-shared-55-5.5.25a-rel27.1.277.rhel6.x86_64
Percona-Server-server-55-5.5.25a-rel27.1.277.rhel6.x86_64

(installed via: `yum install Percona-Server-client-55 Percona-Server-server-55`)

Trying to install percona-toolkit, I get the following:

%> yum install percona-toolkit
...
Transaction Check Error:
file /usr/lib64/libmysqlclient.so from install of Percona-Server-shared-51-5.1.63-rel13.4.443.rhel6.x86_64 conflicts with file from package Percona-Server-shared-55-5.5.25a-rel27.1.277.rhel6.x86_64
file /usr/lib64/libmysqlclient_r.so from install of Percona-Server-shared-51-5.1.63-rel13.4.443.rhel6.x86_64 conflicts with file from package Percona-Server-shared-55-5.5.25a-rel27.1.277.rhel6.x86_64

Error Summary
-------------

If I look at:

%> yum deplist perl-DBD-MySQL
...
dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit)
provider: mysql-libs.x86_64 5.1.61-4.el6
provider: Percona-Server-shared-51.x86_64 5.1.63-rel13.4.443.rhel6
provider: Percona-Server-shared-compat.x86_64 5.5.25a-rel27.1.277.rhel6
...

We see that perl-DBD-MySQL requires libmysqlclient.so.16, which is available via Percona-Server-shared-51 but NOT Percona-Server-shared-55.

I can get around this by installing packages in the following order:

%> rpm -qa |grep -i percona
percona-release-0.0-1.x86_64

%> yum install Percona-Server-shared-compat
...
%> yum install Percona-Server-client-55 Percona-Server-server-55 percona-toolkit
...

But it's a pain to have to do this every time, I'd rather have the dependencies just work