[Xymon] Alternative DB to RRD

[Henrik Størner]

Den 09-03-2011 18:16, Gautier Begin skrev:
> I have heard that we could store measurements not only in RRD files but
> also in standard DataBase (mySQL for expl) using a task through xymon
> channel.
>
> Where can I find such dev ?

Depends on what you want to accomplish.

If you just want to store the "raw" status messages in an SQL database, 
then Japheth Cleaver wrote a very simple perl script for doing that.
See http://lists.xymon.com/archive/2009-March/023782.html

If you want to pick up the individual data values that Xymon passes into 
the RRD files, then it gets more complicated. There is a "hook"
into the xymond_rrd module that feeds all of the RRD data into another 
program; you launch this by running xymond_rrd with the 
"--processor=/path/to/script" option. The script must then be able to 
handle data in the form of one line per update, each line contains the 
RRD template (names of the datasets), the data values (colon-separated),
the hostname, and the elements of the RRD filename. This isn't something 
that has been used much, so I really don't know what the impact would be 
of running this to store all data in an SQL database. Depends on the 
amount of data you are going to handle, obviously.

But I'm not aware of any such script being available, so you would have 
to code it yourself.


Regards,
Henrik