Switch to MariaDB

Without further details, we cannot help...

Currrent SQL server vendor/version?

Well first, MariaDB is not recommended for Debian Stretch. The thing is that MariaDB is provided by Debian Stretch in place of MySQL... Now about upgrading from MySQL 5.7 to MariaDB, you should be able to upgrade to MariaDB 10.2 (not 10.1 as provided by Debian repository) wihtout too much difficulties. See https://mariadb.com/kb/en/libr…b-vs-mysql-compatibility/

First, you should backup all your SQL data, that is: the /var/lib/mysql and /etc/mysql directories. Once done, you must edit the /etc/imscp/imscp.conf file and change

by

Once done, run the imscp-autoinstaller script from the i-MSCP 1.5.3 distribution directory as follows:

If you want, I can test the migrration on my test server first. Then, I'll be able to give you the full instructions. Is that ok?

Quote from batZen

I think i'm not the only user who want to switch to maria db in the future cause it's provided by Debian Stretch.

Of course but ... remember that MariaDB 10.2 is provided by i-MSCP through official MariaDB team repository, not through Debian repository as the version provided by this last (10.1) isn't a drop-in replacement for MySQL 5.7. I'll do the test, either this evening or tomorrow morning and will post my feedback.

batZen

It is an order? Sorry, I cannot be on every front at the same time I'll do that on my free time.