I've been playing with Zenoss (2.4) for the first time. Here are my thoughts:
I also tried the mysqlmonitor zenpack, which is quite nice. You can find out what it can do at various places (extended monitoring guide, mysql monitoring shootout etc), but here is what it does not monitor/graph:
I don't see why you can't track such things, as afaik you can easily/cheaply get them all with a 'show global status'. (though storing them all in rrd files will take quite some space). Imho it would be very usefull it you had more control over what (not) to monitor, maybe through zPropperties or whatever.
Though it doesn't look too hard to adapt the Zenpack, so it can be done.
I used to use Zenoss on my Zenoss box for fun, but it no longer works. Zenoss expects old versions of various build tools and can no longer be built against most updated distributions. The option of using .deb or .rpm packages are still there, but it's still disappointing.
Posted by Will B. on Sun Jun 7 13:34:37 2009
As a commercial alternative, LogicMonitor does do what Zenoss lacks - automatically detects storage engines (Innodb, MyISAM, etc); whether a DB is a slave; monitors query cache (and due to complex alerting rules, can recommend to increase, decrease or disable query cache, based on hit rate, memory purges, and misses).
Also much easier to extend - although the design goal is that out of the box (or 'off the web', as its a hybrid SaaS model) it has comprehensive monitoring automatically - very in depth, with sensible alerts (for threads created; temp tables on disk, CPU load, swap space, swap rate, interface errors, etc, etc.) Also provides a unified system for network and storage gear.
Posted by Steve on Sat Jun 20 02:25:11 2009
Sorry, I should have posted the relevant URL:
Posted by Steve on Sat Jun 20 02:26:33 2009
I've customized the egg to do a lot of this. There were a few annoying things like it emailing db passwords when things failed, so i had to code them into the script for now (i don't remember the issue with having this as a zProperty, it seems like i ran into one). I can possibly post the ZenPack, hit me up on my site if you're interested.
Posted by Justin Hiza on Wed Jul 29 18:46:31 2009
Definitely interested. Could you perhaps clean it up and post it as a community zenpack?
Posted by Martijn Heemels on Mon Dec 28 04:28:41 2009