mysql upgrade from 5.6 to 5.7 issue

[shrief mohsen]

Dear @cPanelLauren

I would like to ask two questions the first one is what is the least version of php needed for mysql 5.7 so any site of any account on cpanel could work the second question since that there is no downgrade to older version of mysql so if i upgraded the mysql version to 5.7 and some of the sites are not working with the new version even if i took backup of all the sites on the cpanel and restore them and after restore some sites couldn't work so how i maintain these sites make them work after the upgrade

Thanks & best regards

 

[ffeingol]

@shrief mohsen I'm pretty sure that any version of PHP can connect/use MySQL V5.7. Your second question is too generic. If you can post some specific errors / issues you are having, we can more than likely provide options.

 

[shrief mohsen]

dear @ffeingol and @cPanelLauren

i want to make sure that all sites will be working after the upgrade especially when upgrading is successfully finished there is no downgrade if i face any issue with any site and i want to return back to old mysql version i just want to know what is the best backup plan that i should take after the upgrade if one of the sites is down and can't work

Thanks & best regards

 

[ffeingol]

The problem is, there is no back out. If you really had to back out, you'd need another server (with 5.6) or reinstall on your current server and then recover the sites.

Most open source software (Joomla, WordPress, Drupal etc.) have no issues with 5.7 as long as they are up to date. Where we have run into issues is people that have not updated their sites for a long time (read years and years).

Not sure that answers your question, but it's the best I can offer.

 

[shrief mohsen]

Dear @ffeingol

thanks for your effors

Dear @cPanelLauren

do u have any comments regarding the issue

 

[cPanelLauren]

Dear @cPanelLauren

I would like to ask two questions the first one is what is the least version of php needed for mysql 5.7 so any site of any account on cpanel could work the second question since that there is no downgrade to older version of mysql so if i upgraded the mysql version to 5.7 and some of the sites are not working with the new version even if i took backup of all the sites on the cpanel and restore them and after restore some sites couldn't work so how i maintain these sites make them work after the upgrade

Thanks & best regards

I'd agree there's no issue with PHP versions and the MySQL version you're using as far as using supported versions of PHP and MySQL. I would suggest that the version of PHP you use is at the very least PHP 7.2 as anything below that is EoL at this time.

i want to make sure that all sites will be working after the upgrade especially when upgrading is successfully finished there is no downgrade if i face any issue with any site and i want to return back to old mysql version i just want to know what is the best backup plan that i should take after the upgrade if one of the sites is down and can't work

Well first you'd want to ensure that your sites are compatible with both MySQL 5.7 and PHP 7.1 or higher as noted by @ffeingol most common CMS systems are compatible with the newest versions of PHP and MySQL but in the event you have custom scripts you'll need to evaluate this first.

Secondly you can always change your PHP version and change it back to ensure you won't face any issues

Third, if you experience issues with your site once you update the MySQL version as there is no downgrade path you'd want to find the exact issue, in most cases this is an item that can be resolved. If you need help identifying this you can let us know here, open a support ticket or enlist the services of a qualified system administrator - in the event you don't have one you might find one here: System Administration Services

As always this implies that you make backups prior to making any changes.

 

[shrief mohsen]

Dear @cPanelLauren

before i make the upgrade do i need to suspend all the accounts using databases?

Thanks & best regards

 

[ffeingol]

We have never done that. It's just a yum update. It will un-install the old version, which will shut down MySQL and then install the new version. Worst case, you're going to get some web site errors (500 type errors) during the process. If you are concerned about that, you could just block web access with firewall rules (close port 80/443).

 

[shrief mohsen]

@ffeingol close port 80 and 443 or also 2083,2087,2082,2086 as well

 

[cPanelLauren]

Either way they're going to get errors on the sites whether you block access or not, personally I wouldn't do either there is less of a chance they'll get an error on the site from the upgrade than closing the ports and you'd definitely *not* want to close the cPanel/WHM ports

 

[shrief mohsen]

@cPanelLauren

one last thing in the documentation of the upgrade i want to know what is the difference between Unattended Upgrade and interactive and which one to use

• Unattended Upgrade — This option automatically rebuilds Apache and PHP with the last saved defaults. It also automatically updates Ruby Gems and rebuilds Apache and PHP.
• Interactive Upgrade — This option steps you through the upgrade process. This process includes the Ruby Gems update, the MySQL or MariaDB upgrade, and the Apache and PHP rebuild.

Thanks & best regards

 

[cPanelLauren]

This is just what it says, unattended means it automatically does these things, interactive means it gives you choices on whether or not you'd like to proceed.