WatchMySQL plugin for cPanel/WHM

Overview

This plugin gives administrators the ability to monitor concurrent user connections to MySQL. The WatchMySQL daemon can be configured so that when a user exceeds theire connection limit a notification is sent to the administrator and/or user. The daemon can also be configured so that it will kill off those connections. Limits can be set per user, per package, or globally.

Screen Shots

Here are a few screen shots of the WatchMySQL plugin!

WatchMySQL screen shot running from the WHM WatchMySQL screen shot running from the WHM

WatchMySQL screen shot running from the WHM WatchMySQL screen shot running from the WHM

Instructions

  • Installation Instructions

    The installation proceedure for this plugins requires that you have root access to the server via the console or SSH. Below are step by step instructions you should use to install this plugin.

    # cd /home
    # rm -f latest-watchmysql
    # wget http://www.ndchost.com/cpanel-whm/plugins/watchmysql/download.php
    # sh latest-watchmysql
  • Using the plugin from the WebHostManager

    Log into the WHM, click on plugins, then WatchMySQL.

  • Using the plugin from the Command Line

    /etc/init.d/watchmysql -- this is the init.d script used for starting and stoping the watchmysql daemon

    /etc/watchmysql.config -- this is the global config file that watchmysql uses.

    /etc/watchmysql.userlimits -- this is the user limits config file, syntax is user=limit, one user per line.

    /etc/watchmysql.packagelimits -- this is the package limits config file, syntax is package=limit, one package per line. This only works on cPanel/WHM servers

    /usr/sbin/watchmysql -- this is the watchmysql daemon