Moodle v3.7 and MySQL v8

Moodle v3.7 and MySQL v8

by Acqua Alta -
Number of replies: 4

Hi,

We want to set up a new server with Moodle v3.7.2 installed.
We have a dilemma - which version of MySQL should we install on this server - v5.7 or v8?

Did anyone of you already have experience with a Moodle v3.7 server that is using MySQLv8, and if so, could you share it with us? Is the environment stable enough? Did you encounter any problems?

Bonus question:
Which version of PHP or you using and what is your experience with it?

BTW, I found this issue in tracker:
https://tracker.moodle.org/browse/MDL-66110
The issue is already fixed, and it maybe even irrelevant anyway for our scenario because we'll install a new server, but it still make me a little bit worried about how "synced" are the newest versions of Moodle and MySQL.







Average of ratings: -
In reply to Acqua Alta

Re: Moodle v3.7 and MySQL v8

by Ken Task -
Picture of Particularly helpful Moodlers

MySQL lifetime support matrix

MySQL Database 5.7    Oct 2015    Oct 2020
MySQL Database 8.0    Apr 2018    Apr 2023
MySQL Database 9.0    expected 2019/20    unknown

https://www.mysql.com/support/eol-notice.html
https://www.mysql.com/support/supportedplatforms/database.html
https://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html
https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/

Using mysql repos one does have an 'easy' upgrade path via the repo.

However, conversion of 5.7 DB to 8 ..
https://dev.mysql.com/doc/refman/8.0/en/faqs-migration.html

Personally, have always found it 'safe' to be one version behind the latest/greatest with an upgrade path.  Care not to be an 'omicron tester'.

'SoS', Ken

Average of ratings: Useful (1)
In reply to Ken Task

Re: Moodle v3.7 and MySQL v8

by Acqua Alta -
Hi Ken,
Thanks for the quick and detailed answer. Regarding your last sentence in the comment - Right now the one version behind the latest (v8) is v5.7, so if I understand you correctly, you recommend us to stay with v5.7 for now. Am I right?
Average of ratings: -