In a web server very old applications must coexist with new ones. Usually old applications are no more mantained and still require old versions of
mysql, while recent apps claim to use the latest features of your
php and database servers. In addition you may want to switch from
mariaDB, which is going to quickly supersede its progenitor program.
That said, how to build a web server which mounts on the same apache a variety of
php/mysql/mariadb configurations? Let's consider a simple case and suppose to have an
apache 2.4.x already installed and two database server, let's say
mariadb-5.5, listening on two different IPs. We would like to have two separate
php versions available, let's say 5.3.x and 5.4.x, living together and connecting to
mariadb respectively. Of course this procedure can be modified as you like for any number of configurations you like.
I will show how to achieve this configuring
php in the usual
mod_php manner and and by means of
apache module which starts
php requests as a CGI program, delivering very similar performance as
mod_php. I will show how to select the proper
php.ini file as well.