Questions on Upgrade to MariaDB

Mise

• June 03, 2019 17:16

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

  • June 04, 2019 18:23

  Hello @Mise, These questions are answered and discussed on the following threads: Let me know if you have any additional questions or concerns. Thanks!

  0
• 

  Mise

  • June 08, 2019 04:05

  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:

  0

Please sign in to leave a comment.