Required MySQL / MariaDB versions

[sgrossberndt]

TYPO3 v9 on https://get.typo3.org/version/9#system-requirements has MariaDB 10.2 as minimal compatible version while allowing MySQL to be 5.0 to 5.7
https://github.com/TYPO3-infrastructure/get.typo3.org/blob/master/Build/Data/9.json#L18

TYPO3 v8 LTS on https://get.typo3.org/version/8#system-requirements has no specific MariaDB requirement and allows MySQL to be 5.0 to 5.7
https://github.com/TYPO3-infrastructure/get.typo3.org/blob/master/Build/Data/8.json#L19

TYPO3 v7 LTS on https://get.typo3.org/version/7#system-requirements has no specific MariaDB requirement and allows MySQL to be 5.5 to 5.7
https://github.com/TYPO3-infrastructure/get.typo3.org/blob/master/Build/Data/7.json#L19

In INSTALL.md in all of those versions * MySQL 5.5 up to 5.7 or compatible is stated.

In doctrine/dbal 2.7 there is a specific handling for MariaDB >= 10.2.7 and for MySQL >= 5.7 but nothing disallowing older versions.

1. Why is the required version on get.typo3.org for v8 and v9 lower than in INSTALL.md? Definitions in https://github.com/TYPO3-infrastructure/get.typo3.org/tree/master/Build/Data
2. Why is there a specific requirement for MariaDB 10.2 as minimal compatible version for v9?

https://forge.typo3.org/issues/85428

[bmack]

First of all -- INSTALL.md is outdated. That is the first mistake.

For TYPO3 v8+v9, we can actually mention that we support "MySQL 5.0 - 5.7". IF we migrate to doctrine/dbal 2.8, we can also add "MySQL 8".

MariaDB: doctrine 2.7 explicitly supports MariaDB 10.2 for the first time, not having this previously (just using the MySQL platform, as it was a drop-in replacement). Because we did not want to alter the min requirements for MariaDB in an existing LTS version.

So: Let's sort out INSTALL.md at the very first place to start off. We need to add Postgres, MSSQL, SQLite as well. And then we'll continue with get.typo3.org IMHO.

TYPO3 v7

• MySQL 5.5-5.7

TYPO3 v8

• MySQL 5.0-5.7
• Postgres
• MSSQL
• SQlite3

TYPO3 v9

• MySQL 5.0-5.7
• MariaDB 10.2+
• Postgres
• MSSQL
• SQlite3

[sgrossberndt]

For people not knowing the Doctrine internals

- MySQL 5.0-5.7
- MariaDB 10.2+

looks like MariaDB is only supported if you use a version >= 10.2

If MySQL is supported down to 5.0, MariaDB is as binary compatible version supported down to 5.1.

If version constraints are given (what about version constraints for Postgres / MSSQL by the way?) I would propose:

- MySQL 5.0-5.7
- MariaDB 5.1-10.3

(MySQL has 8.0 in the meantime which is not set as supported yet, so if we set a upper version constraint here for MySQL lets do that for MariaDB too.

[sgrossberndt]

At least for v8 we should add - MariaDB 5.1-10.3 then too

[sgrossberndt]

https://typo3.org/cms/requirements/ is another source with different versions listed.

People who don't know MariaDB is a binary compatible drop in replacement the current list of versions makes it look like MariaDB is only supported with 10.2+ while it is since 5.1

[sgrossberndt]

So INSTALL.md no longer contains requirements itself but redirects to https://get.typo3.org/version/9#system-requirements - now the difference between there and https://typo3.org/cms/requirements/ needs to be resolved.

[bmack]

Hey, I think we should get rid of the typo3.org/cms/requirements page. There is NO distinction between versions. I think this is not cool. what do you think?

[sgrossberndt]

Full ACK. Redirecting to https://get.typo3.org is fine IMO.

[bmack]

Done.

[sgrossberndt]

This does not solve the mentioned issue with MariaDB yet. I'll prepare a pull request.