CloudLinux - CloudLinux Blog - Beta: MySQL Governor - Reloaded. New concept, new features, less frustration
RSS

Beta: MySQL Governor - Reloaded. New concept, new features, less frustration

Beta: MySQL Governor - Reloaded. New concept, new features, less frustration

MySQL Governor 0.8-9 is available for beta testing. This new version features completely new concept behind limiting MySQL usage.
  1. We no longer use USERSTATS. Instead we monitor usage real time. We are no longer constrained by queries being finished before we can get usage data
  2. There is just 3 limits: CPU, IO READ, IO WRITE. Nothing else. Easy to define, easy to monitor, easy to judge.
  3. CPU Limits are set in % relative to a single core. IO limits are in bytes per second
  4. When customer abuses any limit, you don't have to suspend customer's access to MySQL. Instead, you can put them into an LVE, slowing down hist MySQL queries, and preventing abuse
  5. All abusers will be placed & will share same LVE (with ID 3), you can adjust settings for that LVE to define how much resources are allowed for abusers
  6. Abusers will be restricted to 30 concurrent connections (can be changed), so that they would not exhaust all database connections.
In the end you should see new MySQL governor being much quicker to react, and it should no longer create as much disturbance when customer is restricted

You can find more info about new MySQL governor here:
http://docs.cloudlinux.com/index.html?mysql_governor.htm

Installation instructions:
http://docs.cloudlinux.com/index.html?installation3.html* Due to completely new concept behind MySQL Governor, we renamed the RPM. The installation instructions include instructions for removing old version of MySQL Governor
Beta: CloudLinux 5.x kernel 2.6.18-408.8.2.el5.lve...
Beta: Improved lveps and lvetop with better sortin...
 

By accepting you will be accessing a service provided by a third-party external to https://www.cloudlinux.com/