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

Vishwajit Kale

Vishwajit Kale blazed onto the digital marketing scene back in 2015 and is the digital marketing strategist of Hostripples, a company that aims to provide affordable web hosting solutions. Vishwajit is experienced in digital and content marketing along with SEO. He's fond of writing technology blogs, traveling and reading.

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…

How to replace MySQL with Percona Server on RHEL or CentOS in Vesta Control Panel

Replace MySQL with Percona Server on RHEL or CentOS in Vesta Control Panel You can safely replace MySQL with Percona Server without lossing any data. In order to do it, please follow the instructions bellow 1. Install Percona repository yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm 2. Remove MySQL packages yum remove mysql mysql-server…