Percona Server 5.5 incompatible with php-mysql package v5.4.* from Remi repo

[Alex]

OS: CentOS 6.3 with latest updates (2.6.32-279.19.1.el6.x86_64)

Description: when installing Percona-Server-server-55 package from Percona repo after installing php-mysql 5.4.11 package from Remi's repo yum said that has a package conflict here in libmysqlclient.so.

Steps to reproduce:

Install CentOS, delete all php and mysql packages:

yum remove php*
yum remove mysql*

Check if any php packages installed:

yum list installed | grep -i 'php'
// empty

yum list installed | grep -i 'mysql'
// empty

Enable Remi's repos:

rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

Clear and update packages list:

yum clean all
yum update

Install php packages:

yum --enablerepo=remi,remi-test install php-mysql

php-mysql dependencies list:

Installing:
 php x86_64 5.4.11-1.el6.remi
 php-mysql x86_64 5.4.11-1.el6.remi
Installing for dependencies:
 mysql-libs x86_64 5.5.29-1.el6.remi
 php-cli x86_64 5.4.11-1.el6.remi
 php-common x86_64 5.4.11-1.el6.remi
 php-pdo x86_64 5.4.11-1.el6.remi

Add Percona repo:

rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm

Install Percona Server 5.5:

yum install Percona-Server-server-55.x86_64

Error: Package: php-mysql-5.4.11-1.el6.remi.x86_64 (@remi)
           Requires: libmysqlclient.so.18(libmysqlclient_16)(64bit)
           Removing: mysql-libs-5.5.29-1.el6.remi.x86_64 (@remi)
               libmysqlclient.so.18(libmysqlclient_16)(64bit)
           Obsoleted By: Percona-Server-shared-55-5.5.29-rel29.4.401.rhel6.x86_64 (percona)
               Not found
Error: Package: php-mysql-5.4.11-1.el6.remi.x86_64 (@remi)
           Requires: libmysqlclient.so.18(libmysqlclient_18)(64bit)
           Removing: mysql-libs-5.5.29-1.el6.remi.x86_64 (@remi)
               libmysqlclient.so.18(libmysqlclient_18)(64bit)
           Obsoleted By: Percona-Server-shared-55-5.5.29-rel29.4.401.rhel6.x86_64 (percona)
               Not found

Ok, lets try to install Percona-Server-shared-compat:

yum install Percona-Server-shared-compat

Error: Package: php-mysql-5.4.11-1.el6.remi.x86_64 (@remi)
           Requires: libmysqlclient.so.18(libmysqlclient_16)(64bit)
           Removing: mysql-libs-5.5.29-1.el6.remi.x86_64 (@remi)
               libmysqlclient.so.18(libmysqlclient_16)(64bit)
           Obsoleted By: Percona-Server-shared-compat-5.5.29-rel29.4.401.rhel6.x86_64 (percona)
               Not found
Error: Package: php-mysql-5.4.11-1.el6.remi.x86_64 (@remi)
           Requires: libmysqlclient.so.18(libmysqlclient_18)(64bit)
           Removing: mysql-libs-5.5.29-1.el6.remi.x86_64 (@remi)
               libmysqlclient.so.18(libmysqlclient_18)(64bit)
           Obsoleted By: Percona-Server-shared-compat-5.5.29-rel29.4.401.rhel6.x86_64 (percona)
               Not found

But, all works, if disable Percona repo and install Percona Server 5.5 first:

yum remove php-common php* mysql-* Percona* Percona-*
yum install Percona-Server-server-55
yum --disablerepo=percona --enablerepo=remi,remi-test install php-mysql

Also, i find this link: https://groups.google.com/forum/#!msg/percona-discussion/N5ZGHB6rXyg/PxNOeBOrUowJ where Ignacio Nin from Percona comment the same "bug".

So, it is not as critical, but not obvious at first sight, moreover, have to remove already installed php packages for install Percona Server.
Yes, you can do it without removing the packages with manual build php-mysql package, but in this case, the package manager yum can`t handle this packages correctly.

[Valerii Kravchuk (valerii-kravchuk)]

See https://bugs.launchpad.net/percona-server/+bug/1050654 also (probably similar provides issue in shared-compat).

[Alex (ax1)]

Yep, i am seen this bug while installing Percona Server. But, i find the solution to install percona-toolkit:

1. Install Percona-Server-server-55
2. Install Percona Server-shared-compat
3. Install percona-toolkit

Yes, this solution as of three steps, three "yum install %package%" and its working. If you try install all packages in one yum transaction - its failed with error in libmysqlclient.so