IMPORTANT: Please make full database backup (including system tables) before you will do upgrade of MySQL or switch to MariaDB. This action will prevent data losing in case if something goes wrong.
MySQL Governor is compatible only with MySQL 5.x, 8.0; MariaDB & Percona Server 5.6.
To install MySQL Governor on your server install governor-mysql package at first:
# yum remove db-governor db-governor-mysql # you can ignore errors if you don’t have those packages installed
# yum install governor-mysql
Then configure MySQL Governor properly.
The installation is currently supported only on cPanel, Plesk, DirectAdmin, ISPmanager, InterWorx, as well as on servers without control panel.
If you are installing CloudLinux on a server running MySQL already, set your current MySQL version before calling installation script:
# /usr/share/lve/dbgovernor/mysqlgovernor.py –mysql-version=mysqlXX
# /usr/share/lve/dbgovernor/mysqlgovernor.py –install
Please make sure to specify your current MySQL version instead of XX as follows:
•55 — MySQL v5.5
•56 — MySQL v5.6
•57 — MySQL v5.7
•80 — MySQL v8.0 [requires MySQL Governor 1.2-37+;
database packages are available in Beta only, so, please use –install-beta flag instead of –install]
If you are installing CloudLinux on a server running MariaDB already, do instead:
# /usr/share/lve/dbgovernor/mysqlgovernor.py –mysql-version=mariadbXX
# /usr/share/lve/dbgovernor/mysqlgovernor.py –install
Please make sure to specify your current MariaDB version instead of XX as follows:
•55 — MariaDB v5.5
•100 — MariaDB v10.0
•101 — MariaDB v10.1
•102 — MariaDB v10.2
•103 — MariaDB v10.3 [requires MySQL Governor 1.2-36+; for cPanel – MySQL Governor 1.2-41+]
Installation for Percona Server 5.6 [requires MySQL Governor 1.1-22+ or 1.2-21+]:
# /usr/share/lve/dbgovernor/mysqlgovernor.py –mysql-version=percona56
# /usr/share/lve/dbgovernor/mysqlgovernor.py –install
Please note that MySQL/MariaDB/Percona will be updated from CloudLinux repositories.
If you are installing MySQL Governor on a server without MySQL at all, you have an opportunity to choose desired MySQL version to be installed with MySQL Governor installation script. Use –mysql-version flag before calling the installation script:
# /usr/share/lve/dbgovernor/mysqlgovernor.py –mysql-version=MYSQL_VERSION
# /usr/share/lve/dbgovernor/mysqlgovernor.py –install
MYSQL_VERSION could be chosen from the list of versions currently supported by MySQL Governor:
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 are 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+]
percona56 Percona Server v 5.6
Generally, stable and beta channels contain different version of MySQL packages – beta contains newer version than stable or the same one. If you would like to install beta packages, use –install-beta flag instead of –install when calling installation script:
# /usr/share/lve/dbgovernor/mysqlgovernor.py –install-beta
Starting with MySQL Governor version 1.2 when installing MySQL/MariaDB MySQL Governor asks for a confirmation of a database version to be installed. To avoid such behavior for the automatic installations, please use –yes flag.
For example:
# /usr/share/lve/dbgovernor/mysqlgovernor.py –install –yes
Please note that restore of previous packages in case of failed installation would also be confirmed with –yes flag.
WARNING! Use –yes flag on your own risk, because it confirms installation in any case – even in case if there are troubles during installation (for example, network problems causing incomplete download of packages), everything would be confirmed.
Removing MySQL Governor
To remove MySQL Governor:
# /usr/share/lve/dbgovernor/mysqlgovernor.py –delete
The script will install original MySQL server, and remove MySQL Governor.