BuycPanel Blog

BuycPanel Blog

Latest news and updates

How to use the MySQL or MariaDB Upgrade Interface?

Posted by Allura on 10 12 2019.

Introduction
One will navigate to (WHM >> Home >> SQL Services >> MySQL/MariaDB Upgrade) for engaging on this feature. It helps in administering MySQL® or MariaDB® version upgrades (like, once one upgrades it 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 need to be considered are:Firstly, it is suggested to back up the information before upgrading.
Secondly, downgrades of database engine versions are not supported.
Thirdly, the PHP info file might show a version of MySQL totally contrary to the one you may choose.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…

Introduction

One will navigate to (WHM >> Home >> SQL Services >> MySQL/MariaDB Upgrade) for engaging on this feature. It helps in administering MySQL® or MariaDB® version upgrades (like, once one upgrades it 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 need to be considered are:

  • Firstly, it is suggested to back up the information before upgrading.
  • Secondly, downgrades of database engine versions are not supported.
  • Thirdly, the PHP info file might show a version of MySQL totally contrary to the one you may choose.

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 must choose the present version of MySQL or MariaDB so as to install the database or information once again.
  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 beside 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 category of upgrade you are comfortable 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, the interface will display this message: Upgrade finished successfully.
  7. Click on Continue thereafter.
  8. Next, the server can check the necessity of the 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 were used, the process running within MySQL/MariaDB Upgrade interface) and new settings (completing the rebuilding process by maneuvering to (WHM >> Home  >> Software >> EasyApache 4).

MySQL Upgrade Log

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

Conclusion

All relevant data regarding MySQL and MariaDB interface is reviewed in this article.