Skip to main content

How do I upgrade MySQL with the CloudLinux MySQL Governor tool?

cPRex
  • Updated

Introduction

If you are using CloudLinux's "MySQL Governor", you won't be able to use "MySQL/MariaDB Upgrade" in WHM to upgrade MySQL/MariaDB. MySQL/MariaDB must be upgraded with the mysqlgovernor.py script.

 

Procedure

  1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
  2. Run the following commands to set the MySQL/MariaDB version to upgrade to. 
    /usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=MYSQL_VERSION

    Please note that "MYSQL_VERSION" must be replaced with the MySQL/MariaDB version to install.

    MYSQL_VERSION MySQL/MariaDB version
    mysql51 MySQL v5.1
    mysql55 MySQL v5.5
    mysql56 MySQL v5.6
    mysql57 MySQL v5.7
    mysql80 MySQL v8.0 [requires MySQL Governor 1.2-37+]
    mariadb55 MariaDB v5.5
    mariadb100 MariaDB v10.0
    mariadb101 MariaDB v10.1
    mariadb102 MariaDB v 10.2
    mariadb103 MariaDB v 10.3 [requires MySQL Governor 1.2-41+]
    mariadb105 MariaDB v 10.5 [requires MySQL Governor 1.2-62+]
    mariadb106 MariaDB v 10.6 [requires MySQL Governor 1.2-72+]

  3. Run the following command to install the new MySQL/MariaDB version.

    /usr/share/lve/dbgovernor/mysqlgovernor.py --install

 

Additional resources

MySQL Governor: Upgrading Database Server

Related articles