Tuesday, November 04, 2008

CMON - News Flash! Monitor your mysql servers!

Here is a short summary of CMON news:
Feature update of cmon 0.1 (the same as cmon 1.2.2 plus):
  • monitor your mysql servers (add/remove mysql servers that should be monitored)
  • view status and variables of your mysql servers
  • view graphs of status variables for individual mysql servers as well as a grand total.
  • get recommendations on parameter tuning of my.cnf
  • updated web interface (small fixes made)
  • and some bug fixes..
To do
  • add AJAX support to web interface so that graphs are reloaded in a better way
  • finish plugin interface - so that it will be possible to write SNMP, SMTP, etc plugins
  • improve rules for spotting configuration problems in the monitored mysql servers.
  • improved overview of mysql variables.
  • replication channels
Screen shots

Display graphs (both for individual as well as aggregated over all mysql servers):


View the status of your mysql servers that CMON is monitoring (status, variables, graphs). Sub-optimal config values are highlighted in read!:



Add a mysql server that should be monitored by CMON...



Remove a MySQL Server from CMON..


6 comments:

Phil Bayfield said...

Hi Johan,

If upgrading from an older version (I have 1.2.2) is there a recomended process?

Will cmon correct any changes to the database schema for exmaple?

Johan Andersson said...

Hi Phil,
There are a couple of more tables but those will be recreated.
I haven't figured out the best way yet what to do if i change (add/remove) a column from an existing table.

Perhaps, just add a switch like --upgrade , which will drop and recreate the tables..
Or provide a SQL script with ALTER TABLE commands that must be run before starting the new version of CMON. What do you think would work best for you?

BR
johan

Phil Bayfield said...

Hi Johan,

Personally I would prefer to either run ALTER TABLE statements manually or have them automatically added to the program.

I've changed the original MyISAM tables to NDB so it would obviously be easier this way rather than having to change the storage engine again on every new table.

Phil Bayfield said...

Hi Johan,

I've just downloaded cmon 0.1, I've updated this particular server from Ubuntu 8.04 to Ubuntu 8.10 since I compilied 1.2.2 and I'm getting the following error (all pre-requisites are installed):

sh autogen.sh
Can't exec "libtoolize": No such file or directory at /usr/local/mysql/bin//autoreconf line 186.
Use of uninitialized value $libtoolize in pattern match (m//) at /usr/local/mysql/bin//autoreconf line 186.

I believe that this is something to do with libtool version packaged with Intrepid, I'll post this as a bug on launchpad also.

Technam said...

Are there any log option to activate in the configuration of MySQL servers in order to monitor them in cmon? All my nodes status are ok in the overview but monitoring MySQL nodes (Sweatchart) does not work, graphs are empty, server ids are wrong and it does not seem to know if the servers are connected in the cluster.

Johan Andersson said...

Hi,

I am currently rewriting cmon and it will soon be released, and will incorporate better/working graphs.

BR
johan