[TYPO3-core] Raise MySQL requirements?

[Jigal van Hemert]

Hi Michael,

On 8-1-2014 14:54, Michael Stucki wrote:
>> According to Oracle Lifetime Support Policy [1] the Premier Support has
>> ended for MySQL 5.1. It's also mentioned on the Reference Manual page
>> [2] as "End of Product Lifecycle" that "Active development for MySQL
>> Database Server version 5.1 has ended".
>>
>> On the Ubuntu 13.10 distribution I installed last weekend MySQL 5.6 was
>> installed by default through the package manager.
>
> Are you sure? I have 13.10 too but MySQL is 5.5.34 (see also [1]).

Double checked and you are (of course) right. 5.5.34

> Besides that, I'm wondering why you want to raise the requirement? Is
> there any feature of MySQL 5.5 that you like to use in TYPO3 CMS? Right
> now we're using a very basic feature set, so why change it?

The main reason is to prevent problems. By keeping in sync with the 
versions that are shipped with currently supported OS's we have the 
freedom to use features that are not supported by older versions. In 
general, we have to consider less versions during tests, we do not need 
to fix bugs that occur only with older versions, etcetera.

> One more thing: We should think about MariaDB support too. Has anyone
> ever tried that yet? It is almost completely compatible with MySQL,
> however their version number was raised to 10.x which is no longer in
> sync with MySQL. See [4] for more info.

MariaDB 5.5 is still a drop-in replacement for MySQL 5.5.
For MySQL 5.6 it wasn't possible to backport the changes in MariaDB 
directly. MariaDB 10.x is still beta and will for some time not be a 
drop-in replacement for MySQL 5.6
Since we don't use the features that are different (as in not yet 
implemented in MariaDB 10.x) it would even be possible to use that version.

There are no checks in our code for DBMS versions (I couldn't find 
them), so the requirements are mainly to reflect what we tested and for 
which versions we like to fix bugs.

-- 
Jigal van Hemert
TYPO3 CMS Active Contributor

TYPO3 .... inspiring people to share!
Get involved: typo3.org