This guide provides step-by-step instructions to install DB Governor using the command-line interface on CloudLinux OS versions 6, 7, and 8. DB Governor is a vital component that helps monitor and limit MySQL resource usage per user, ensuring better server performance and stability, especially in shared hosting environments.
Prerequisite:
Before proceeding with the installation, ensure that a MySQL or MariaDB server is already installed on your system. If not, you can install MariaDB using the following command:
yum install MariaDB-server MariaDB-client
This will install the necessary server and client packages required for DB Governor to function properly.
Installation Steps:
Assuming your server is running MariaDB version 10.3.32, you will need to convert the system to use the mariadb103 DB Governor profile. Follow the steps below:
- Install the DB Governor package:
yum install governor-mysql
- Specify the MySQL/MariaDB version:
/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mariadb103
- Install DB Governor:
/usr/share/lve/dbgovernor/mysqlgovernor.py --install
These commands will properly configure and install DB Governor for the specified MariaDB version.
Important:
Ensure you specify the correct MySQL/MariaDB version. Installing an incorrect version can lead to database corruption.
This way, you can install DB Governor using the command-line interface on CloudLinux OS versions 6, 7, and 8.
Ready to install other tools via CLI? Learn How to install cURL on MacOSX