cancel
Showing results for 
Search instead for 
Did you mean: 

Is CE 1.9.3.7 or 1.9.3.8 compatible with MySQL 5.7?

Highlighted

Is CE 1.9.3.7 or 1.9.3.8 compatible with MySQL 5.7?

I want to move our system to a new server which would run on MySQL 5.7 (but has HTTP/2). I have checked several threads and posts and I am not quite sure what to make of a final result.

 

Some claim it worked, others say it's strictly 5.6 (as stated in the official system requirements). I am always running on the latest 1.9.X.X versions and my webhost says risks are minimal.

 

Does anybody have some valid proof that this works? Is there an official statement from Magento which is newer than regarding CE 1.9.0?

4 REPLIES 4
Highlighted

Re: Is CE 1.9.3.7 or 1.9.3.8 compatible with MySQL 5.7?

Hi @TheFrakes,

 

Which documentation or references about issues did you found?

 

Highlighted

Re: Is CE 1.9.3.7 or 1.9.3.8 compatible with MySQL 5.7?

Hi Damian,

 

I have found the following discussions with no clear answers but with concerns and possible errors or warnings:

- https://community.magento.com/t5/Version-Upgrades/Is-CE1-9-0-1-compatible-with-MySQL-5-7/td-p/43681

- https://magento.stackexchange.com/questions/130828/is-ce-1-9-0-1-compatible-with-mysql-5-7

 

A problem with url_rewirtes that can be fixed after upgrading to 5.7:

- https://github.com/hvanmegen/magento-mysql-5.7-join-fix

- https://github.com/OpenMage/magento-lts/issues/295

 

The official Magento 1 system requirements say only 5.6 is fully supported:

- http://devdocs.magento.com/guides/m1x/system-requirements.html

 

These are the sources I have found so far...

Highlighted

Re: Is CE 1.9.3.7 or 1.9.3.8 compatible with MySQL 5.7?

Not to toot my own horn (and thanks for mentioning me and my fix Smiley Happy), but you'll need that fix that adds a check for the empty category when you're running on MySQL 5.7.x ... I'm not entirely sure if MySQL, MariaDB and Percona all fixed their 5.7's, but having all these extra conditionals in the join causes MySQL to freak out (tested on MySQL 5.7 and the Percona equivalent).

 

It just breaks the entire query caching, causing queries to run for over 20-50 seconds instead of <1 on huge category requests (like, ALL of the catagories for queries that, for example, a Mega-Menu system would need).

 

While I'm here, can I recommend the community driven version of Magento 1.x ? You can find it at https://github.com/openmage/magento-lts

Highlighted

Re: Is CE 1.9.3.7 or 1.9.3.8 compatible with MySQL 5.7?

Hello Henry,

 

Does this mean that the  ITS version has no problem with MySQL 5.7?