Knowledgebase

Overview:

This interface allows you to manage MySQL® or MariaDB® version upgrades (for example, when you upgrade from MySQL 5.6 to 5.7). After you select your MySQL or MariaDB version, WHM automatically keeps your database engine up-to-date. This means, for example, that whenever the vendor releases a new patch for your version of MySQL or MariaDB, WHM automatically applies the patch to your installation.

Available versions

The following versions of MySQL are available:

• MySQL 5.6

• MySQL 5.7

• MySQL 8.0

The following versions of MariaDB are available:

• MariaDB 10.1

• MariaDB 10.2

• MariaDB 10.3

Upgrade MySQL or MariaDB

To upgrade your server’s version of MySQL or MariaDB, perform the following steps:

1. Select the version of MySQL or MariaDB that you wish to upgrade.

   Note:

   To reinstall your database, select your current version of MySQL or MariaDB.
   Warning:

   • You cannot upgrade MySQL 8 to MariaDB 10.x due to incompatibilities between these versions. For more information, read MariaDB’s documentation.

   However, system administrators can change databases from MySQL 8 to MariaDB 10.3 during the cPanel & WHM version 92 installation process. For more information, read our Installation Guide.

    

2. Click Next. A new interface will appear with warning messages about the upgrade process.

   Note:

   The system validates the /etc/my.cnf file during the upgrade.

    

3. Select the checkbox next to each warning to acknowledge that you are aware of the potential consequences of the upgrade.

4. If you are upgrading your database server from MySQL version 5.7 to 8, the Upgrade Checker via MySQLShell (optional) section will appear. This utility checks whether the upgrade will work on the MySQL configuration file and table engine. To run the MySQL Upgrade Checker utility, click Install and Run Checker. A progress window will appear, and it will display the results of the upgrade check.

   • You can resolve any issues that appear in the results and click Re-Run Checker to run the MySQL Upgrade Checker utility again.

5. Click Continue.

6. Select the type of upgrade that you wish to perform:

   • 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.

7. The upgrade process interface appears.

   • Select or deselect the Autoscroll output checkbox to change whether the output display scrolls as the upgrade runs.

   • When the upgrade finishes, the interface displays the following message:

     Upgrade finished successfully.

      

8. Click Continue.

9. Your server checks whether you must recompile any Ruby Gems. Follow the instructions and then click Continue.

MySQL upgrade log

The system stores the MySQL and MariaDB log files in the /var/cpanel/logs directory. The log files use the mysql_upgrade_log.YYYYMMDD-hhmmss naming convention with the following designators:

• YYYY — Four-digit year.

• MM — Two-digit month.

• DD — Two-digit day.

• hh — Two-digit hour.

• mm — Two-digit minute.

• ss — Two-digit second.