MySql and PHP upgrade

audrey

• August 31, 2019 09:31

Hi I need to upgrade MySql and PHP on my servers. >>>>>>>>>>>>>>>>>>>>>>> Cpanel's documentation says 1) We strongly recommend that you back up your database before you upgrade your database or change to MariaDB. Is this backup a special backup or is this just the regular WHM backups including "Per Account and Entire MySQL Directory" 2) If the buildapache application uses the MySQL libraries and headers on the server itself, and you change the MySQL version, Apache cannot function correctly. Because cPanel & WHM updates MySQL RPMs whenever Red Hat releases updates, this could automatically break thousands of servers within a few hours. For this reason, cPanel, L.L.C. always builds Apache and PHP with the -builtin option. My servers all have standard intalls of Cpanel. No custom scripts. How can I tell if the above will be an issue for the mysql upgrade. >>>>>>>>>>>>>>>>>>> Is it better to upgrade MySQL in Cpanel version v80.0.24 or v82.0.11 >>>>>>>>>>>>>>>>>> I also need to add PHP 7.3 to the servers. Does upgrading MySql automatically upgrade PHP if not Is it better to upgrade MySql first and then PHP or vice versa? Thanks for your help Audrey

• 

  quietFinn

  • August 31, 2019 15:51

  I don't think it matters in what order you do those, but I'd suggest you do like this: 1st upgrade Cpanel/WHM to v82.x 2nd add PHP 7.3 in EasyApache 3rd Upgrade MySQL Only the MySQL upgrade can be a bit scary, but I don't remember ever having any problems with it. Anyway it's better to do when server is not busy because during the upgrade MySQL server will be down for a short while.

  0
• 

  audrey

  • August 31, 2019 16:37

  Thanks for your advice any idea on the following? Cpanel's documentation says 1) We strongly recommend that you back up your database before you upgrade your database or change to MariaDB. Is this backup a special backup or is this just the regular WHM backups including "Per Account and Entire MySQL Directory" 2) If the buildapache application uses the MySQL libraries and headers on the server itself, and you change the MySQL version, Apache cannot function correctly. Because cPanel & WHM updates MySQL RPMs whenever Red Hat releases updates, this could automatically break thousands of servers within a few hours. For this reason, cPanel, L.L.C. always builds Apache and PHP with the -builtin option. My servers all have standard intalls of Cpanel. No custom scripts. How can I tell if the above will be an issue for the mysql upgrade.

  0
• 

  quietFinn

  • August 31, 2019 16:54

  1) Not any special backup is needed, but you can of course make a copy of the /var/lib/mysql directory before you upgrade MySQL. 2) Must say it goes "over my head" what they say. But if you have standard cPanel server there should not be any issues like that.

  0
• 

  audrey

  • August 31, 2019 17:19

  thank you

  0
• 

  cPanelLauren

  • September 04, 2019 17:13

  Since you're only going from 80->82 it would probably make the most sense to update MySQL prior to updating cPanel/WHM.

  0
• 

  audrey

  • September 04, 2019 22:46

  Thanks for your help The WHM already updated itself to v82.0.11 What version of MySql do you think that I should upgrade this server to? My other conserns are Cpanel's documentation says 1) We strongly recommend that you back up your database before you upgrade your database or change to MariaDB. Is this backup a special backup or is this just the regular WHM backups including "Per Account and Entire MySQL Directory" 2) If the buildapache application uses the MySQL libraries and headers on the server itself, and you change the MySQL version, Apache cannot function correctly. Because cPanel & WHM updates MySQL RPMs whenever Red Hat releases updates, this could automatically break thousands of servers within a few hours. For this reason, cPanel, L.L.C. always builds Apache and PHP with the -builtin option. My servers all have standard intalls of Cpanel. No custom scripts. How can I tell if the above will be an issue for the mysql upgrade. Thank you

  0
• 

  cPanelLauren

  • September 05, 2019 14:16

  What version of MySql do you think that I should upgrade this server to?

  
  What version of MySQL are you running? If you're running a recent version of MySQL or Maria DB I would recommend MySQL 5.7 or MariaDB 10.3 but I would not move from MySQL 5.7 to MariaDB 10.2 or 10.3. Those versions of MariaDB do not contain
  This was answered earlier in the thread:

  1) Not any special backup is needed, but you can of course make a copy of the /var/lib/mysql directory before you upgrade MySQL.

  
  No special backup, the WHM Backups which are Per Account and Entire MySQL directory would be sufficient for this.

  2) If the buildapache application uses the MySQL libraries and headers on the server itself, and you change the MySQL version, Apache cannot function correctly. Because cPanel & WHM updates MySQL RPMs whenever Red Hat releases updates, this could automatically break thousands of servers within a few hours. For this reason, cPanel, L.L.C. always builds Apache and PHP with the -builtin option.

  
  The MySQL upgrade through cPanel will rebuild apache based on your choice of one of the following: [QUOTE]

  • Rebuild Apache and PHP using saved settings " Choose this option to rebuild Apache and PHP with the last settings that you used. If you choose this option, the Apache and PHP rebuild process runs within the MySQL/MariaDB Upgrade interface.
  • Rebuild Apache and PHP with new settings " Choose this option to rebuild Apache and PHP with new settings. If you choose this option, the MySQL or MariaDB Upgrade - Version 84 Documentation - cPanel Documentation

  0
• 

  audrey

  • September 05, 2019 16:54

  Thanks for your help! The upgrade to MySQL 5,7 went very smoothly:) Take Care Audrey

  0

Please sign in to leave a comment.