Nagios, MySQL and trending

[Carroll, Jim P [Contractor]]

After a few bumps and bruises, I succeeded in converting my existing Nagios
installation to include MySQL support (except for the host/service extended
info, which I deliberately avoided).

Now that it's merrily collecting the data in the serviceretention table, I'm
a bit disappointed that my key reason for doing the conversion (trending
data) isn't quite supported as I'd hoped.  I was hoping it would keep an
archive of the ongoing service (and host) performance data.  I know there's
a compile-time option to do something similar using a file
(xpdfile_service_perfdata_file), but if this data were in MySQL, I'd never
have to fiddle with stop/rename/start on a periodic basis (eg, once every 24
hours).

I'd rather not create a cronjob to read the service retention table just to
populate another table every minute, if possible.

Am I overlooking something simple, or is the capability just not there
today?  If the latter, are there any plans to provide this in the
foreseeable future?  (Ethan?)

If I can nail this down, I'll have a more serious go of using PHP/JpGraph to
do some ad-hoc trend graphing.

jc


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf