How to update Mysql to MariaDb

thenocgroup

Registered
Jun 25, 2018
4
0
1
argentina
cPanel Access Level
Root Administrator
Hi guys how are you?

I have a Centos v76.0.20 with Mysql 5.6.41, PHP 7.1 running with all my databases.

1- I wanted to migrate to MariaDB, but I dont know what is the best practice for this.
2 - I'm afraid that after migrating some Database stop working. How can I verify if these databases will work with MariaDb before migrating?

Thank you so much for the help
best
Fernando
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
Hello Fernando,

It's difficult to know if your scripts will continue to work because it depends on how each individual script is coded. The only way to perform a live test is to setup MariaDB on a test server and migrate your accounts to that test server (without changing the DNS) so that you can verify the scripts function as expected. There are also some threads linked below where this is discussed (along with discussion of MySQL 5.7)

MySQL 5.7 or MariaDB 10.2
Upgrade MySQL 5.7 to MariaDB Recommended?

Thank you.