Since we want to install the Moodle 3.9, that the server provide MariaDB version isn't latest. The following error message appear .
version 10.2.29 is required and you are running 10.1.45
Then We contact web hosting company and they suggested Transfer our hosting to Mysql-5.7 server will be meet the requirements of Moodle. Is it work for us?
We want to seek advice for installation of Moodle. Do you have another suggestion for this case.
Technically, what provider is saying is true. Although a higher version of MariaDB is all that is needed for your current server. Shared hosting? If so, understandable ... can't upgrade shared DB server for one customer.
Am guessing this change they propose means you pay more?
Before you say 'yes', ask them if they will fix the 2 'full unicode support' checks as well. Refer them to Moodle docs if ya have to:
https://docs.moodle.org/39/en/MySQL_full_unicode_support
Site not running https is also something you need to address. No site of any kind should be running http IF users accounts are involved.
'SoS', Ken
Although Ken has replied, adding my two cents.
MySQL 5.7 will fulfill your REQUIREMENT to install Moodle 3.9, BUT, you'll be converting Database file format into Barracuda as MySQL supports both Antelope and Barracuda, and under no circumstances your shared host will convert table format to Barracuda on shared server.
MariaDB on the other hand, starting from 10.2.x have Barracuda Format as default, so no errors or recommendations from moodle's environment check.
It's not difficult, in PHPMyAdmin you'll see server variables and there you can change the table format from Antelope to Barracuda - while for command line method you can always ask Ken Task
BUT, as I mentioned, your host will never change it as it will effect all other accounts on the server, so they wont sacrifice hundreds of customers for one, unless you are on VPS or dedicated.
