MySQL governor is a sofware to monitor and restrict MySQL resource usage in a CloudLinux based server. MySQL is an open source RDBMS (Relational Database Management System) and its using the SQL Language(Structured Query Language). A database is a structured collection of data. SQL is the most commonly using language for database operations. By using SQL the database operations like adding, accessing and managing the database is very simple. To upgrade MySQL in a cPanel server please read this, How to upgrade MySQL cPanel. Here I’m explaining the steps to upgrade MySQL and MySQL governor in cPanel CloudLinux server. First of all, we have to take the backup of all the databases in the server and then only we should proceed with the upgrade.
1. Take the backup of all the databases on the server. Please refer to the section How to create MySQL dump/backup of all the databases
Now all our databases are safe. Then, we can proceed with the MySQL and MySQL governor upgrade. This can be done in very few steps.
2. Update MySQL governor in the server using CloudLinux repo.
# yum update governor-mysql --enablerepo=cloudlinux-updates-testing
3. The following command will select the MySQL version as MySQL5.5
# /usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mysql55
4. To install the new MySQL version
# /usr/share/lve/dbgovernor/db-select-mysql --install-now
Once this is completed, we need to recompile Apache and PHP in the server. For that, execute the following command from your server:
That’s it 🙂