MySQL 5.5® Automatic Update

Updates begin February 2020

Automatic updates from MySQL 5.5 to MySQL 5.7

Any server with a local installation of MySQL 5.5 and no databases will automatically update to MySQL 5.7 or newer.

Some customers using Version 78 of cPanel & WHM are blocked from upgrading to newer versions because MySQL 5.5 is installed. To solve this problem, we are automatically upgrading these servers.

We strongly recommend you do not wait for the automatic update and perform the upgrade to the server before February 2020. This automatic update will be triggered when the server tries to update to Version 86 during its maintenance period.

Future automatic updates from MySQL 5.5 to MySQL 5.6

Any server meeting the following requirements may receive a separate update:

  • The local MySQL server runs version 5.5.
  • There are few databases on the server.
  • The databases that exist on the server have a small size.
  • There are a small number of users on the server.
  • The my.cnf file is a standard configuration and does not contain any customization.
  • No database corruption is detected.

This process is currently under consideration, and would upgrade from MySQL 5.5 to MySQL 5.6 for qualifying servers. Get emails and stay-up-to date on product changes like these by subscribing here.


Why

The automatic update will result in healthy, updated servers. MySQL 5.5 reached end of life (EOL) in December, 2018 and no longer receives security updates or patches.

Impact

Some issues that might arise during an upgrade to MySQL 5.6 that you should be aware of:

  • The automatic update to the servers could cause lengthy downtime if they have a large number of databases or large database size.
  • If database corruption exists and is not detected, websites will likely break.
  • Third-party software and plugins that rely on database services and are not compatible with MySQL 5.6 or newer will break.
  • Servers configured to use old passwords from MySQL 4.1 will need database users to update their passwords after the MySQL version upgrade completes.

Benefits

Updated servers have lower security risks. An exposed flaw or vulnerability can cause a security crisis that needs to be addressed urgently without adequate time to deploy resources, resulting in long waits for technical support while servers are vulnerable to being exploited. Keeping servers up-to-date reduces last-minute panic.

What you can do

You can upgrade your managed servers to MySQL 5.6 or newer before the automatic update. MySQL upgrades can be performed in WHM or via API calls.

Hosting providers with unmanaged servers need to communicate with customers to make them aware of this update and encourage them to upgrade their version of MySQL to 5.6 or newer before 2020.

Anything else I should know?

If you do not manually update MySQL 5.5 before the automatic update and an issue arises, we will not be notified or be able to help until you open a ticket. This could cause a longer than needed disruption to websites hosted on the affected servers.

The best course of action is to upgrade or have your managed hosting provider upgrade MySQL as soon as possible to perform any maintenance necessary due to unexpected incompatibility or corruption.

Having your systems administrator upgrade instead of waiting for the automatic update allows you to control the process. If you would like to hire someone to manage your server or to help with this upgrade, here’s a list of SafeAdmin Certified system administrators.

More Information

To upgrade MySQL via WHM: WHM » SQL Services » MySQL/MariaDB Upgrade

MySQL 5.5 Update Resources