Upgrade MySQL and MySQL Governor in cPanel

Upgrade MySQL and MySQL Governor in cPanel CloudLinux based server First make full mysql backup(including system tables)  to safe location. 1) Take the backup of all the databases on the server. $ mkdir -p ~/mysqlbkp $ service mysql restart –skip-networking –skip-grant-tables $ mysql_upgrade $ mysqldump –all-databases –routines –triggers > ~/mysqlbkp/dbcopy.sql $ service mysql stop $ cp -r /var/lib/mysql/mysql ~/mysqlbkp/ $ service mysql start 2)  update mysql/governor in the following way: # yum update governor-mysql –enablerepo=cloudlinux-updates-testing # /usr/share/lve/dbgovernor/db-select-mysql –mysql-version=mysql55 # /usr/share/lve/dbgovernor/db-select-mysql –install-now installation […]

How to install MySQL Governor in plain server or without cPanel server.

Run the below command to install MySQL Governor in plain server or without control panel server. yum install db-governor –enablerepo=cloudlinux-updates-testing yum update mysql-server mysql-devel mysql –enablerepo=cloudlinux-updates-testing Add the below line in my.cnf with root password  [dbgovernor]   Run the below command to start. service db_governor restart