Your MariaDB version (10.3) has reached End of Life status. Upgrade now to prevent security and compatibility problems.

Answered

CHU TRONG

• July 27, 2024 02:18

Hi all,

Currently my WHM server is showing a notification that the MariaDB 10.3 version has gone EOL and needs to be upgraded.

I want to ask what problems will happen if I upgrade MariaDB to the new Version. Currently my Hosting has more than 500 accounts. This is really difficult to upgrade. I'm worried that if I upgrade, it will affect a number of customers.

Please provide me with information.
Thank you.

• 

  mtindor

  • July 27, 2024 13:16

  Assuming you can upgrade (meaning assuming you aren't running an EOL operating system and EOL WHM and are trying to upgrade, then you shouldn't have any problem upgrading.

  However, make a copy (and I can't stress this enough) of your /etc/my.cnf mysql configuration file.   After the upgrade, there is a good chance that some things will change in /etc/my.cnf and something could cause problems.

  For instance, just about any time that you upgrade a major version, it seems like the sql_mod= ends up changing.   Usually it'll end up enabling things like strict_trans_tables and such.   And that could cause some of your sites to not function properly.

  So make a copy of /etc/my.cnf.   Note the sql_mode currently set.   And after migration, if /etc/my.cnf doesn't have the same sql_mode set, change the sql_mode= line in /etc/my.cnf to reflect what it was pre-upgrade and restart MySQL.

  0

Please sign in to leave a comment.