just a few days ago we updated from mysql 5.5 to 5.6 on Debian Jessie with I-MSCP 1.5.3, thanks to Nuxwin . Today I have a few questions regarding the options to update to MariaDB, since with Debian Stretch, MySQL will be replaced with MariaDB.
We alread have plans for the full distribution update to Debian Stretch, but until this can work, we have to check some of our software. I searched for a I-MSCP Autoinstaller Update to MariaDB and found the following: Von MySQL 5.5 zu 5.6 oder MariaDB 10
Switch between SQL vendors is not allowed through installer because generally, this require manual intervention from the administrator.
You can always force the installer to show you all available SQL vendors by resetting value of both SQL_SERVER and SQL_PACKAGE parameters to an empty value in the /etc/imscp/imscp.conf configuration file but if you do, nothing garantie that the upgrade will work as expected.
In all cases, do a backup first.
So the question now is: Would it be better to update using that option from MySQL 5.6 to MariaDB 10.0, MariaDB 10.1 or should we just wait for the distribution update, where MySQL will be replaced with MariaDB from stretch? I checked some systems and used Google for more information and it seems like atleast an update to MariaDB 10.0 should be possible without any problems, but I think I-MSCP wouldn't disabled the easy vendor switch then, right?
Thanks for your time.