Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Questions on Upgrade to MariaDB

Discussion in 'Database Discussion' started by Mise, Jun 3, 2019.

  1. Mise

    Mise Active Member

    Joined:
    May 15, 2011
    Messages:
    31
    Likes Received:
    2
    Trophy Points:
    58
    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:
    Code:
    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,
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,528
    Likes Received:
    2,180
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Mise

    Mise Active Member

    Joined:
    May 15, 2011
    Messages:
    31
    Likes Received:
    2
    Trophy Points:
    58
    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
     
    cPanelMichael likes this.
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice