Thursday, November 20, 2008

cmon 0.11 released

cmon 0.11 which you can get from www.severalnines.com/cmon corrects the following bugs:
  • Graphs wrap half ways - https://bugs.launchpad.net/cmon/+bug/300222
  • Memory leaks (missed a couple of mysql_free_resultset) https://bugs.launchpad.net/cmon/+bug/300225
There are also some code cleanups.
To upgrade from earlier version:
  • start a mysql client on the mysql server(s) having the cmon database
  • use cmon
  • drop mysql_statistics table
  • drop mysql_variables table
  • start cmon which will then recreate those tables
The above is particularly important if you move from MySQL Cluster 6.3.17 or earlier to 6.3.18 (or later) because the number of statistic counters and variables has increased between the versions. cmon will build up the mysql_statistics and mysql_variables tables dynamically instead (if you have dropped them earlier).

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..