CentOS 6.4

Client libraries version 12 and 14 are very old. MariaDB 5.1 (the earliest existing version) builds libmysqlclient.so.16.

Do you really need libmysqlclient.so.12 or libmysqlclient.so.14? What version of MySQL do they come from?

Yes, replacing MariaDB rpm with the Percona one solves the PHP Headers problem. As our KB page suggests "Ways to fix this issue: ... Use your original MySQL client library with the MariaDB". That's what you do when you use Percona rpm, it includes the client library that is very close (if not identical) to MySQL's one.

Well apparently I do need those very old ones to make PHP happy. It would be nice if it just worked out of the box and I didn't have to manually replace a package with another one. Makes for some interesting Chef recipes ...

Looking at http://mirror.rackspace.com/centos/6/os/x86_64/Packages/mysql-libs-5.1.66-2.el6_3.x86_64.rpm which I think is the package php-mysql is built against, I see it has only v16.

If I remove the file /usr/lib64/libmysqlclient.so.16 then php won't run mysql at all.

So I guess the problem is that the libmysqlclient.so.16 provided by MariaDB is different than the one from mysql-libs or Percona-Server-shared-compat

With libmysqlclient.so.16.0.0 from mysql-libs

1. php -i | grep API | grep version
   Client API version => 5.1.66
   Client API library version => 5.1.66
   Client API header version => 5.1.67
   Client API version => 5.1.66
   Phar API version => 1.1.1

With libmysqlclient.so.16.0.0 from Percona-Server-shared-compat

1. php -i | grep API | grep version
   Client API version => 5.1.66
   Client API library version => 5.1.66
   Client API header version => 5.1.67
   Client API version => 5.1.66
   Phar API version => 1.1.1

With libmysqlclient.so.16.0.0 from MariaDB-compat

1. php -i | grep API | grep version
   Client API version => 5.3.12-MariaDB
   Client API library version => 5.3.12-MariaDB
   Client API header version => 5.1.67
   Client API version => 5.3.12-MariaDB
   Phar API version => 1.1.1

So it seems the problem is actually that your version of that library is 5.3 while everyone else is 5.1. Why call the package "compat" if its not compatible?

Hmm. You said above that "MariaDB 5.1 (the earliest existing version) builds libmysqlclient.so.16" but it appears its coming from 5.3. Would it be possible to use the 5.1 version of the file instead in the RPM to make it more "compatible" with things like PHP?

Or do I just need to find my own workaround to replacing that file with one from some other source.

It's called "compat" because it's fully compatible with 5.1 libraries. But PHP apparently insists not only on the library being compatible, but also coming from the same minor release version.

If you'd like, you can install our 5.1 shared rpm, for example, this one:
http://ftp.osuosl.org/pub/mariadb/mariadb-5.1.67/centos5-x86/rpms/MariaDB-shared-5.1.67-122.el5.i386.rpm

Thanks @serg

That works. Also of note for anyone else, you can install a CentOS 5 RPM on CentOS 6.

It needs to be forced in, since it conflicts with MariaDB-compat, which you can't remove without everything freaking out.

I've since opted to just manually install the one library file. Since I'm using chef I can just use the cookbook_file resource to install a working version.

Looks like I can't close this myself ... so feel free to close.

This is PHP/mysqli (when built without mysqlnd) issue — it ignores .so versioning and insists that the libmysqlclient.so should have the same minor version as what mysqli was built with.
Otherwise it issues a warning. One can ignore the warning, use a different libmysqlclient.so or a different mysqli.