Everything
php
Learn Community Releases The PHP Project
Home » Project » Newsgroups » php.internals » Minimum MySQL version »

Minimum MySQL version

php.internals

Nikita Popov

9 years ago
Hi, I just found out that some of the PDO code contains MySQL version checks going all the way back to MySQL 3.22.30, which has been released in 2000. What is the minimum MySQL version we support? can I drop checks for MySQL 3.x and 4.x? Nikita

lists@rhsoft.net

9 years ago
Am 18.07.2017 um 21:37 schrieb Nikita Popov:
> I just found out that some of the PDO code contains MySQL version checks > going all the way back to MySQL 3.22.30, which has been released in 2000. > > What is the minimum MySQL version we support? can I drop checks for MySQL > 3.x and 4.x?
wouldn't it be time to remove all the artefacts before "mysqlnd" and so drop any dependency of "libmysql" and/or "libmariadb" these days?

Johannes Schlüter

9 years ago
On Di, 2017-07-18 at 21:42 +0200, lists@rhsoft.net wrote:
> > Am 18.07.2017 um 21:37 schrieb Nikita Popov: > > > > I just found out that some of the PDO code contains MySQL version > > checks > > going all the way back to MySQL 3.22.30, which has been released in > > 2000. > > > > What is the minimum MySQL version we support? can I drop checks for > > MySQL > > 3.x and 4.x? > wouldn't it be time to remove all the artefacts before "mysqlnd" and > so drop any dependency of "libmysql" and/or "libmariadb" these days?
Usage of libmysql can be beneficial in case there is a bug, also 3rd party plugins for non-standard authentication mechanisms might only exist for libmysql. From a maintainers perspective keeping compatibility is only limited work, we (Oracle) can keep doing. johannes

Andreas Treichel

9 years ago
On 18.7.2017 21:37, Nikita Popov wrote:
> What is the minimum MySQL version we support? can I drop checks for MySQL > 3.x and 4.x?
The "oldoldstable" Debian Wheezy from 2013 supports MySQL 5.5. The unsupported Debian Lenny has MySQL 5.0 since 2009. In my opinion the next release of PHP no longer needs to support MySQL older than version 5.0.

Jan Ehrhardt

9 years ago
Nikita Popov in php.internals (Tue, 18 Jul 2017 21:37:07 +0200):
>I just found out that some of the PDO code contains MySQL version checks >going all the way back to MySQL 3.22.30, which has been released in 2000. > >What is the minimum MySQL version we support? can I drop checks for MySQL >3.x and 4.x?
The Windows builds come bundled with MySQLND 5.0.8-dev (PHP 5.3) up until MySQLND 5.0.12-dev (PHP 7.2). Even PHP 5.1 was distributed with a MySQL 5.0.x version, so dropping MySQL 3.x and 4.x seems perfectly valid.
-- Jan

Johannes Schlüter

9 years ago
Hi, On Di, 2017-07-18 at 21:37 +0200, Nikita Popov wrote:
> I just found out that some of the PDO code contains MySQL version > checks going all the way back to MySQL 3.22.30, which has been > released in 2000. > > What is the minimum MySQL version we support? can I drop checks for > MySQL 3.x and 4.x?
It's not actively tested, but my assumption is that every version since 4.1 would work with mysqlnd. When using libmysql connecting to 3.x should work eventually.  From an Oracle perspective 5.5, 5.6 and 5.7 are in active (premier/Extended) support. Older versions (5.0, 5.1) are only in Sustaining Support.  See https://www.mysql.com/support/  https://www.mysql.com/support/supported platforms/database.html and https://www.mysql.com/support/eol-notice.ht ml I would suggest to keep 5.5 and newer active. (I haven't checked, but think there is little to gain from dropping 5.5 on PHP's side) If the community decides to drop support for older versions I'm happy to clean up the code a bit. johannes