Requirement for: https://github.com/piwik/piwik/issues/9107
We shall collect & measure which Mysql version are currently being used by the Piwik users community. Once we have the metric /data we can more easily take a decision regarding #9107
Doing this, one maybe not only should look solely on the share of people using old mysql version but also who uses it. Don't know yet how to do it best, but one should be careful giving the power of influencing decisions to the right ones. (imho there is absolutely no reason for responsible people to use mysql before 5.x)
MySQL 4.1 was released in 2003, I bet there are no distros having it in the last 5 years or so.
Even SLES 11 (released in 2009) has MySQL 5.5 (but sadly PHP 5.3...)
@mattab I issued PR in https://github.com/piwik/piwik/pull/9742
Need to update api.piwik.org to measure it.
I will also update Anonymous tracking plugin
Issues also PR in https://github.com/piwik/plugin-AnonymousPiwikUsageMeasurement/pull/30 for Anonymous tracking plugin
@mattab I pushed an update to piwik-api (accidentally to master). We need to deploy it to the server and update the DB schema. Not sure if I was supposed to provide a DB update statement
@tsteur sounds good - main schema updated and another one is in progress
| 569 | copy to tmp table | ALTER TABLE api_update_check_consolidated ADD mysql_version VARCHAR(250) NOT NULL AFTER php_version |
Schema update is completed and Mysql version is now tracked :+1: