CiviCRM Community Forums (archive)

Our installation instructions (see http://wiki.civicrm.org/confluence/display/CRMDOC/Installation+and+Upgrades) indicate that CiviCRM requires PHP 5.3+ which is no longer a supported version (see http://php.net/supported-versions.php) and MySQL 5.1+ which is no longer under active development (see http://en.wikipedia.org/wiki/MySQL#Versions, and http://dev.mysql.com/doc/relnotes/mysql/5.1/en/ which suggests no security releases have come out in 2014).

I think at a minimum we should change the documentation to indicate that we support stable releases of PHP and MySQL. But I'm not familiar with whether there has been systematic testing of CiviCRM with newer versions of PHP or MySQL.

I don't think the breakages seen with PHP 5.3 are as common with PHP 5.4 (though dropping calltime pass by ref was a big one), 5.5 and 5.6, but I'm not sure (see http://php.net/manual/en/migration54.incompatible.php, http://php.net/manual/en/migration55.incompatible.php, and http://php.net/manual/en/migration56.incompatible.php).

MySQL incompatible changes introduced in 5.5 are documented at http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html, and those for 5.6 are available at http://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html.

Perhaps we could run the CI tests on various combinations of PHP and MySQL.

I understand pingback data shows there is significant use of MariaDB and Percona for CiviCRM these days; certainly we have some sites that are using them. Because of the advantages of using these higher performance engines, I think it would be worth listing them as well as MySQL. Though again, we should likely do a CI run on them before listing them, despite their claims to drop-in replacement functionality for MySQL/InnoDB. Or we could indicate that they are commonly used if we don't want to invest in the testing.

FWIW, I'm less concerned with the php.net/mysql.com policies and more concerned with the distro policies. A quick summary of some major distros:

 * Debian 6 LTS, PHP 5.3, MySQL 5.1
 * Debian 7, PHP 5.4, MySQL 5.5
 * Ubuntu 12.04 LTS, PHP 5.3, MySQL 5.5
 * Ubuntu 14.04 LTS, PHP 5.5, MySQL 5.5/5.6
 * RHEL 6, PHP 5.3, MySQL 5.1
 * RHEL 7, PHP 5.4, MariaDB 5.5 ??

Source:
 * http://distrowatch.com/table.php?distribution=debian
 * http://distrowatch.com/table.php?distribution=redhat
 * http://distrowatch.com/table.php?distribution=ubuntu

It seems like we're now at a stage where every major distro has PHP 5.4+ and MySQL 5.5+ in their current LTS, so it might be OK to bump versions soon. I'd personally lean toward a version bump in 5.0 rather than 4.6 (but wouldn't object if out-voted).

FWIW, the civicrm.org infrastructure (testing, demos, etc) is running on Debian 6 and Ubuntu 12.04 (both PHP 5.3). A version bump will require updates to several c.o services. Based on past experience, I also expect some of the test-results to change when going to PHP 5.4.

Aside: There was a Q over email about testing and multiple versions. Jenkins does allow us to orchestrate+compare the tests across different VMs / different versions of PHP/MySQL. The main trade-offs are among performance (how long for tests to return) / resource-usage (how many VMs/how much RAM) / visibility (do we include in the PR-testing or in daily-testing).

FWIW: I can't confirm this is true, but this issue suggests a 5.6 incompatibility: https://issues.civicrm.org/jira/browse/CRM-15431