We have a new documentation site for cPanel & WHM! You can find our new documentation site at docs.cpanel.net.
We will continue to maintain our API documentation on this server.
Due to various support and security reasons, cPanel, L.L.C. will automatically upgrade MySQL® 5.5 to MySQL 5.7 on customer servers that run cPanel & WHM version 78. We plan to perform this upgrade in the first quarter of 2020.
We strongly encourage you to upgrade MySQL to a supported version of MySQL or MariaDB® before the automatic upgrade.
This document contains information to explain why cPanel, L.L.C. is doing this, how it can impact you, and what you need to do to ensure success or minimize downtime.
cPanel, L.L.C. blocked upgrades to cPanel & WHM version 80 for any server still running MySQL 5.5.
It is our policy to block upgrades for various reasons, such as new memory requirements or new code that does not support deprecated software. You can read more about our deprecation plan and policy in our cPanel Deprecation Plan documentation.
Because of this particular block on MySQL 5.5, many customers are still running MySQL 5.5 on cPanel & WHM version 78.
However, if a customer continues to use an older version of cPanel & WHM, they will encounter issues such as (but not limited to) the following:
For example, in early 2019, many customers servers contained a dangerous vulnerability in outdated and unsupported versions of EXIM. This urgent problem caused a lot of issues for customers.
By proactively upgrading MySQL to supported versions, we can ensure that customers run supported software to avoid a similar scenario.
We are notifying you of this automatic upgrade through the following methods:
The Contact Manager notifications will include a 30-day countdown to the day of automatic upgrades.
We strongly recommend that you or your managed hosting provider upgrade MySQL as soon as possible. This can help you to avoid unexpected database incompatibility or corruption.
To upgrade your server, perform the following steps:
If you require assistance with any issues as a result of this upgrade, you can either hire an experienced system administrator or submit a ticket through our Customer Support Portal.
We provide a listing of experienced system administrators in our forums. https://go.cpanel.net/hireasysadmin
All servers that run cPanel & WHM version 78 will receive an update that includes the MySQL upgrade patch.
In the first phase up upgrades, servers that meet the following attributes will schedule the upgrade from MySQL 5.5 to MySQL 5.7:
For 30 days, these servers will notify the administrator through WHM's Contact Manager that MySQL 5.5 will automatically upgrade.
After the 30 day notification window ends, these servers will automatically perform the upgrade from MySQL 5.5 to MySQL 5.7. Then, the server will send the administrator a success or failure message.
We are still researching the possibility of a second phase of automatic upgrades.
In the second phase of upgrades, servers that meet the following attributes will schedule the upgrade from MySQL 5.5 to MySQL 5.7:
my.cnffile is a standard configuration and does not contain any customization.
The automatic upgrade can potentially impact customers in the following ways:
cPanel, L.L.C. will not be monitoring individual MySQL upgrade failures, so we will not know if you need assistance until you submit a technical support ticket. This may result in extended downtime for your server.
cPanel, L.L.C. will be hosting a webinar on Monday December 30, 2019 at 1:00PM CST (7:00PM GMT) that demonstrates the upgrade process.
You can register for the webinar at zoom.us.
We will post a recording of that webinar afterwards.
To back up databases for each account, use WHM's Backup Configuration interface (WHM >> Home >> Backup >> Backup Configuration).
The backup will exist in the location that you set under the Configure Backup Directory section.
For more information about backup and recovery, read MySQL's Backup and Recovery article or the How do I back up MySQL databases prior to upgrading to a new version? tutorial in our forums.
You can use WHM's Backup Restoration feature (WHM >> Home >> Backup >> Backup Restoration) to restore an individual account and its database contents.
For more information about backup and recovery, read MySQL's Backup and Recovery article.
Read our MySQL or MariaDB Upgrade documentation.
We recommend that you hire an experienced system administrator to perform the upgrade for you. We provide a listing of experienced system administrators in our forums. https://go.cpanel.net/hireasysadmin
You can also watch our webinar to familiarize yourself with the process.
If the remote server runs cPanel & WHM, you can use WHM's MySQL or MariaDB Upgrade interface (WHM >> Home >> SQL Services >> MySQL/MariaDB Upgrade) or use the WHM API 1
start_background_mysql_upgrade function on the remote server.
If the remote server uses another platform, read and follow the upgrade instructions for that platform.
If a server continues to run an older version of our software, it will encounter issues such as (but not limited to) the following:
In extreme cases, you can disable all updates and keep your existing software. However, you will no longer receive support from cPanel, L.L.C. and will expose your server to potential security issues and vulnerabilities.
We strongly discourage you from doing this.
MariaDB 10.3 contains several significant differences from MySQL 5.7. For a list of differences, read MariaDB's Incompatibilities and Feature Differences Between MariaDB 10.3 and MySQL 5.7 knowledge base article.
If you do not require any of the affected features, then you should be able to upgrade to MariaDB 10.3. However, cPanel & WHM does not support migrations from MariaDB back to MySQL.
Yes, you can. However, MySQL 5.6 reaches end-of-life in October 2021.
MySQL 5.7 offers significant performance enhancements and active support. For a list of differences between MySQL 5.5 and 5.7, read MySQL's What Is New in MySQL 5.7 document.
No, because the system actually performs stepped upgrades as part of the upgrade process. So, all you need to do is start the upgrade from MySQL 5.5 to MySQL 5.7
We have simplified the upgrade process as much as possible, but you may encounter an unexpected issue. If you have an experienced system administrator or database administrator available during the conversion, they can resolve problems for you quickly and mitigate service interruptions for your customers. This is preferable to searching for a system administrator or database administrator while your customers are calling and emailing you about the server.
Both cPanel, L.L.C. and MySQL recommend against downgrading or rolling back MySQL, and we do not support downgrades.
If your website uses software that is compatible with the new database version, no.
Standard email services through Exim and Dovecot do not depend on MySQL services. However, if you have an email application that uses MySQL, such as a database-driven mail service, then it will not be available during the upgrade window.
No, the upgrade process will not alter any files on your server's accounts.
No, the upgrade process will not lose any data from the databases. However, if your application software uses deprecated or removed commands, you may not be able to access that data.
We recommend that you upgrade any software that depends on these databases to use the latest command sets.
No, the upgrade process will not break cPanel accounts on your server.
Check the MySQL upgrade log on your server to determine if there were any issues during the upgrade.
The log files exist in the
mysql_upgrade_log.YYYYMMDD-hhmmss directory, which uses the following format:
The upgrade will cause downtime. We strongly recommend that you schedule a maintenance window and inform your customers when the upgrade is being performed.
The server will stop the MYSQL service before performing the upgrade. If your site depends on MySQL data, then your site will be unavailable during this time.
Only during the upgrade or if it encounters a problem during the upgrade.
If you migrate from MySQL to MariaDB, your cPanel & WHM server will automatically migrate the database contents and users to the new platform.
You will need to read the documentation for your applications to confirm compatibility with the new version of MySQL.
As for precautions, we strongly recommend that you back up your server data in case of corruption or incompatibility.
A MySQL server in Strict Mode will reject data change statements that contain invalid or missing values. If Strict Mode is off, MySQL will insert adjusted values for these invalid or missing values and then return a warning.
For more information about Strict Mode, read MySQL's Strict SQL Mode article.
Check your software's documentation and system requirements to confirm that they are compatible with Strict Mode.
For example, the current version of WordPress is compatible with both MySQL 5.6 or greater as well as MariaDB version 10.1 or greater. This includes Strict Mode.
You must check all of the boxes on Step 2 of the interface to proceed with the upgrade.
If you are or have access to an experienced database administrator, then you should chose interactive. Otherwise, you should choose unattended.
For information on how to repair a database, read A2hosting's Repairing MySQL Databases and tables article.
There is no content with the specified labels
There is no content with the specified labels
There is no content with the specified labels