@mattab opened this Issue on October 27th 2015 Member

Would there be any advantage to increase the minimum required version to Mysql 5.1 in Piwik 3.0.0?

After reading https://github.com/piwik/piwik/issues/9088#issuecomment-151589488 we are wondering whether Piwik 3.0 should still support Mysql 4.x.

(in any case, Piwik LTS 2.x will support Mysql 4.1.)

@hpvd commented on October 28th 2015

beside less support effort,
1) one advantage of a newer minimum version should be a better guaranteed user experience because of speed improvements from version to version (even without any code changes)
[experience from magento usage]
2) better guaranteed security is also a great advantage, because if anything happens everyone talks about security of piwik but not of the old versions of related software...

Both would be also good reasons to constantly rise required versions relatively close to the latest available e.g. to only 0.2 steps behind the latest
(I would strongly vote for this!)

Of course this is all not only relevant for mysql, but also for php (maybe one should open a new ticket for this)

If some one has the skill and possibility to updated piwik he/she should be also be able to maintain the relating infrastructure
(otherwise newer piwik may be a good motivation to update all the other things too)

@ThaDafinser commented on October 28th 2015 Contributor

Supporting (really) old versions in a new major version is simple a waste of time.
Like @hpvd written i also like the approach to drop old versions in a defined way.
@hpvd PHP requiredment is here https://github.com/piwik/piwik/issues/8156

Each new PHPUnit major version only support the 2 latest versions of PHP when released

PHPUnit 5.0 is supported on PHP 5.6 and PHP 7.

I think this can also be applied to the database. Maybe not in such a strict way, but 5.1 is far away from being "fresh"

Version 4.1: beta from June 2004, production release October 2004
Version 5.1: production release 27 November 2008
Version 5.5 was generally available (as of December 2010).
MySQL 5.6 general availability was announced in February 2013
MySQL 5.7 Development Milestone 3 was released December 2013

If you avoid one single #9088 issue you already won. Nobody currently tests such old versions in development, so it's irresponsible to say it's supported.

@tsteur commented on October 28th 2015 Member

FYI: I added https://github.com/piwik/plugin-AnonymousPiwikUsageMeasurement/issues/20 but we won't get significant statistics for this I reckon since not many are using it.

Nobody currently tests such old versions in development, so it's irresponsible to say it's supported.

:+1: Good point. If we say it is supported, we need to actually test it

:+1: for @hpvd arguments as well.

I'd increase it to at least MySQL 5.1 . If someone still wants to use an older version of MySQL: That's why we now have a LTS version for Piwik 2.X . Even WordPress requires at least MySQL 5.0+ and they still support PHP 5.2 :)

@mattab commented on February 8th 2016 Member

First step before we can increase requirement: we need to measure actually how many users are using 4.1 - covered in #9734

@tsteur commented on February 15th 2016 Member

FYI: This decision here also affects plugin developers. If we decide to still support a 12 years old MySQL 4.1 in Piwik 3 I'm not sure if we can expect from plugin developers that they will support MySQL 4.1 and that their plugin will run on all MySQL versions. A plugin developer shouldn't have to write any SQL queries but there will be cases for certain features where they have to.

@ThaDafinser commented on February 15th 2016 Contributor

in Piwik 3 I'm not sure if we can expect from plugin developers that they will support MySQL 4.1 and that their plugin will run on all MySQL versions

This is also the case for piwik 2.x.

I still dont understand how someone still thinks about supporting mysql 4.x in a new major version.

@tsteur commented on March 8th 2016 Member

FYI: There are about 52 users sending their Piwik tracking data to our demo-anonymous instance. Out of these 52, 26 users have updated the plugin already and we are recording the MySQL version.

All of them are using MySQL 5.5 or newer see https://demo-anonymous.piwik.org/index.php?module=Widgetize&action=iframe&widget=1&moduleToWidgetize=CustomVariables&actionToWidgetize=getCustomVariables&idSite=1&period=day&date=2016-03-07&disableLink=1&widget=1


@mattab commented on March 13th 2016 Member

If we increase MySQL requirements to MySQL > 5.5.3 then it would be great to also Make Piwik database use utf8mb4 collation by default #9785 - it would improve overall security of Piwik.

@mattab commented on March 16th 2016 Member

Out of 400+ Piwik instances already sending the Mysql version number, less than 5% are not yet using MySQL 5.5+. It seems safe already that we can increase MySQL requirements to 5.5 in Piwik 3.0.0.

@sgiehl commented on May 30th 2017 Member

Piwik 3 now requires at least MySQL 5.5. I'm closing this issue. If anything left to discuss, please reopen.

This Issue was closed on May 30th 2017
Powered by GitHub Issue Mirror