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!

MySQL 5.5 upgrade to 5.7 or MariaDB 10.3?

Discussion in 'General Discussion' started by sozotech, May 29, 2019.

  1. sozotech

    sozotech Well-Known Member

    Joined:
    Jul 26, 2013
    Messages:
    91
    Likes Received:
    2
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    In general what is going to be less problematic for breaking users sites, upgrading from MySQL 5.5 to 5.7 or 5.5 to MariaDB 10.3?

    Best regards,
    Eric
     
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,484
    Likes Received:
    187
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    Shouldn't be much of a difference really. Both are going to turn on strict mode by default (which you can and probably should disable right after the upgrade.

    If you are worried about it you can go to MySQL 5.7 first and once done and validated with your users you can go from 5.7 to MDB 10.3. You cannot go from MDB 10.3 down to MySQL 5.7.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    cPanelMichael likes this.
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,529
    Likes Received:
    2,181
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello Eric,

    Most of the MariaDB 10.3 and MySQL 5.7 upgrade reports I've seen suggest a fairly smooth upgrade process (the strict mode change referenced in the post above is the one issue that seems to generate the most feedback). You can read more about this particular issue on the following post:

    MySQL 5.5 to 5.7

    Choosing MySQL 5.7 over MariaDB 10.3 can make post-upgrade database troubleshooting easier because you'll know that any potential issues you encounter are a direct result of the differences between MySQL 5.5 and MySQL 5.7. Additionally, one caveat to the MariaDB 10.3 upgrade is that MariaDB upgrades are currently one-way only. You can't upgrade to MariaDB 10.3 and then switch back to MySQL 5.7.

    It's generally a good idea to test the upgrade on a non-production machine if you can. Here's one of my responses on another thread you may find helpful:

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
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