BuycPanel Blog

BuycPanel Blog

Latest news and updates

How to use the MySQL or MariaDB Upgrade Interface?

Posted by Allura on 18 02 2019.

Introduction
One can navigate to (WHM >> Home >> SQL Services >> MySQL/MariaDB Upgrade) for working on this feature. It helps in managing MySQL® or MariaDB® version upgrades (like, when one upgrades from MySQL 5.5 to 5.6). WHM automatically keeps the database engine up-to-date after selecting the MySQL or MariaDB version, which means whenever the vendor releases a new patch for this version, WHM automatically will apply it to the installation.Few warnings that needs to be considered are:Firstly, it is recommended to backup database before upgrading.
Secondly, downgrades of database engine versions are not supported.
Thirdly, the phpinfo file may show a version of MySQL different from the one you will select.Available Versions
Following are the available versions of MySQL and MariaDB respectively:MySQL:MySQL 5.5
MySQL 5.6
MySQL 5.7MariaDB:MariaDB 10.0
MariaDB 10.1
MariaDB 10.2Upgrade MySQL or MariaDB
Steps:To start with the procedure, the desired version of MySQL or MariaDB…

Introduction

One can navigate to (WHM >> Home >> SQL Services >> MySQL/MariaDB Upgrade) for working on this feature. It helps in managing MySQL® or MariaDB® version upgrades (like, when one upgrades from MySQL 5.5 to 5.6). WHM automatically keeps the database engine up-to-date after selecting the MySQL or MariaDB version, which means whenever the vendor releases a new patch for this version, WHM automatically will apply it to the installation.

Few warnings that needs to be considered are:

  • Firstly, it is recommended to backup database before upgrading.
  • Secondly, downgrades of database engine versions are not supported.
  • Thirdly, the phpinfo file may show a version of MySQL different from the one you will select.

Available Versions

Following are the available versions of MySQL and MariaDB respectively:

MySQL:

  • MySQL 5.5
  • MySQL 5.6
  • MySQL 5.7

MariaDB:

  • MariaDB 10.0
  • MariaDB 10.1
  • MariaDB 10.2

Upgrade MySQL or MariaDB

Steps:

  1. To start with the procedure, the desired version of MySQL or MariaDB needs to be selected. One has to select the current version of MySQL or MariaDB in order to reinstall the database.
  2. Click on Next and thereafter a new interface with warning messages about the upgrade process will appear. The /etc/my.cnf file is validated by the system during the upgrade.
  3. Thirdly, one has to select the checkbox besides each warning to recognize the awareness one has about the potential consequences of the upgrade.
  4. Next, one has to click on Continue.
  5. Select which type of upgrade you desire to perform, like unattended upgrade (rebuilding Apache and PHP with last saved defaults), partially-interactive upgrade (naturally updating Ruby Gems, but does not rebuild Apache and PHP until chosen for it), interactive upgrade (including Ruby Gems upgrade, MySQL and MariaDB and Apache and PHP rebuild).
  6. The upgrade process interface is displayed where one has to select or deselect Autoscroll output checkbox to change output display scrolls as and when upgrade runs. Also, when the upgrade finishes, interface will display this message: Upgrade finished successfully.
  7. Click on Continue thereafter.
  8. Next, the server will check the need of recompilation of any Ruby Gems. In that case, one has to follow the instructions and then click on Continue.
  9. Rebuild Apache and PHP using saved settings (rebuilding with last settings that was used, process running within MySQL/MariaDB Upgrade interface) and new settings (completing the rebuilding process by navigating to (WHM >> Home >> Software >> EasyApache 4).

MySQL Upgrade Log

These log file are stores in the /var/cpanel/logs directory and this uses mysql_upgrade_log.YYYYMMDD-hhmmss  where, YYYY describes four-digit year, MM        describes two-digit month, DD describes two-digit day, hh describes two-digit hour,  mm        describes two-digit minute and ss describes two-digit second.

Conclusion

All relevant information about MySQL and MariaDB interface is outlined in this article.