Question
How do I upgrade MySQL with the CloudLinux MySQL Governor tool?
Answer
If you are using CloudLinux's MySQL Governor tool, you won't be able to use the normal WHM >> MySQL/MariaDB Upgrade page to perform this work.
To change the version of MySQL that you're running you just need to run the following two commands.
/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=MYSQL_VERSION
/usr/share/lve/dbgovernor/mysqlgovernor.py --install
The first command sets the MySQL version you want to use, with the "MYSQL_VERSION" variable being one of the following:
| 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+; database packages available in beta only, so use --install-beta flag instead of --install] |
| 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-36+; for cPanel - MySQL Governor 1.2-41+] |
| mariadb104 | MariaDB v 10.4 [requires MySQL Governor 1.2-53+] |
| percona56 | Percona Server v 5.6 |
The second command performs the change on the machine and sets up the new version. You can find more details about this process with the CloudLinux documentation here: