MySQL 5.5 upgrade to 5.7 or MariaDB 10.3?

sozotech

Well-Known Member
Jul 26, 2013
91
2
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
 

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,542
207
343
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.
 
  • Like
Reactions: cPanelMichael

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,911
2,233
363
cPanel Access Level
DataCenter Provider
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:

One approach you can take is to temporary setup a secondary server for testing purposes. Once the secondary server is setup and cPanel & WHM is installed (a free trial license is utilized by default), you can then migrate your accounts to that test server (without changing the DNS) via WHM >> Transfer Tool. At that point, you'd upgrade MySQL or MariaDB to the new version, update the hosts file on your local workstation to point the domains to the test server, and then verify the scripts function as expected on the new MySQL/MariaDB version.
Thank you.