DB Governor and mysql advice
Forum
  1. Forums
  2. CloudLinux and Control Panels
  3. CloudLinux and cPanel
  1. Hostking
  2. Wednesday, 04 November 2015
  3.  Subscribe via email
Hi

We use Mariadb and dbgovernor with cloudlinux.

Now we want to limit each db to 30 connections but also ensure their select queries etc do not overload shared servers.
What is the best way or advice anyone can give us.

Should one enter the username and password of root mysql user into:


Also does this control IO?
 
 


Here is one of our configurations:











 
 
 



















Any advice for shared hosting server config would be appreciated.
Rate this post:
  1. 04.11.2015 14:11:16
  2. # 1
Bogdan Accepted Answer
Posts: 709
Joined: 26.06.2013
0
Votes
Undo
Hi,

Limiting number of connection by each user is set to 30 in your configuration, this is done with user_max_connections:
<restrict level1=\"60s\" level2=\"15m\" level3=\"1h\" level4=\"1d\" timeout=\"1h\" log=\"/var/log/dbgovernor-restrict.log\" user_max_connections=\"30\"/> 

Yes, you should enter root password for proper governor functionality.

And, yes, limit read/write is what helps controlling IO. Overall default settings are best to start using on shared hosting server. However it could be different as depends from every single moment, server power etc.etc. It is always a balance game, how to provide enough resources for your customer and keep server stable.
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,zip,rar,pdf
• Insert • Remove Upload Files (Maximum File Size: 2 MB)
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.