el5olfaa.com
New member
Hello,
Today i will teach you how to prevent any mysql usage abuse from your hosting users on cloudlinux .
Let's do it :
1) Assume you already had cloudlinux installed on your server now we need to tell the installation script which we have mysql or mariadb or percona on our server with the following command :
Replace "mysql55" with your running database server and its version
2) Now let's start mysql governor :
From now all abusers will be throttled to keep your server performance stable .
That's all
Good luck
Today i will teach you how to prevent any mysql usage abuse from your hosting users on cloudlinux .
Let's do it :
1) Assume you already had cloudlinux installed on your server now we need to tell the installation script which we have mysql or mariadb or percona on our server with the following command :
Replace "mysql55" with your running database server and its version
Code:
/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mysql55
/usr/share/lve/dbgovernor/mysqlgovernor.py --install2) Now let's start mysql governor :
Code:
service db_governor startFrom now all abusers will be throttled to keep your server performance stable .
That's all
Good luck
