Questions on Upgrade to MariaDB

[Mise]

I have CENTOS 6.9 with Cpanel v78.0.24

I'm receiving system warning to upgrade my MySQL 5.6 to MariaDB 10.3

My doubt is about possible problems. I have quite sites running php old code and I'm not sure if these sites will experience problems after the upgrade.

Before upgrade I have made a global backup:

mysqldump --all-databases > all_databases.sql

Is this right in order to future restoration in case of problems?


Also, I have these 2 advices in the WHM databse upgrade option:

Critical

In MariaDB® 10.3, the mysqldump client includes logic for the mysql.transaction_registry table. You cannot use the mysqldump client from an earlier MariaDB release on MariaDB 10.3 and later. For more information about how to upgrade to MariaDB 10.3, read the documentation .

Critical

MariaDB enables "strict mode" by default as of version 10.2. Strict mode controls how MariaDB and MySQL handle invalid or missing values in data-change statements such as INSERT or UPDATE. Applications not built with strict mode enabled may cause undesired behavior; please verify applications using MariaDB are compatible before upgrading. More information about strict mode is available here .


Do you think I can upgrade without risks of no malfunctions in all the sites?.
What do you recommend ?


thanks for any advice,

 

[cPanelMichael]

Hello @Mise,

These questions are answered and discussed on the following threads:

MySQL 5.5 upgrade to 5.7 or MariaDB 10.3?
Backup all MySQL Databases?
Upgrade MariaDB to 10.3: backup without mysqldump?

Let me know if you have any additional questions or concerns.

Thanks!

 

[Mise]

thanks Michael for the useful info.

After reading that, finally I have updated to MySQL 5.7 without any issue.

This thread on disable strict_mode was also useful:
MySQL 5.5 to 5.7