MySQL 5.5 upgrade to 5.7 or MariaDB 10.3?

sozotech

• May 29, 2019 06:53

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

  • May 29, 2019 12:23

  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.

  0
• 

  cPanelMichael

  • May 31, 2019 19:00

  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: you may find helpful: [QUOTE]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.

  0

Please sign in to leave a comment.