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

Question

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

Note: 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.

Answer

1. Access the server's command line as the root user via SSH or Terminal in WHM.

2. Run the following command to set the MySQL/MariaDB version to upgrade to:

   # /usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=MYSQL_VERSION

   Note: "MYSQL_VERSION" must be replaced with the MySQL/MariaDB version to install.

   CPANEL_WARN: The following versions have been deprecated and are no longer supported: MySQL 5.1, MySQL 5.5, MariaDB 5.5, MariaDB 10.0, and MariaDB 10.1.

3. mysql51	MySQL v5.1
   mysql55	MySQL v5.5
   mysql56	MySQL v5.6
   mysql84	MySQL v8.4 (requires MySQL Governor 1.2-129+)
   mariadb100	MariaDB v10.0
   mariadb101	MariaDB v10.1
   mariadb102	MariaDB v 10.2
   mariadb103	MariaDB v 10.3 [requires MySQL Governor 1.2-36+; for cPanel - MySQL Governor 1.2-41+]
   mariadb104	MariaDB v 10.4 [requires MySQL Governor 1.2-53+]
   mariadb105	MariaDB v 10.5 [requires MySQL Governor 1.2-62+]
   mariadb106	MariaDB v 10.6 [requires MySQL Governor 1.2-76+]
   mariadb1011	MariaDB v 10.11 [requires MySQL Governor 1.2-103+]
   mariadb1104	MariaDB v 11.4 [requires MySQL Governor 1.2-122+] (not supported on CloudLinux OS 7)
   percona56	Percona Server v 5.6

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