[collectd] remote collectd db query

[Spike Spiegel]

Hi,


On Tue, Sep 22, 2009 at 1:24 AM, Lorin Scraba <lorin at si-bemol.ro> wrote:
> Hi.
>
> I want to peek inside collectd database (aka rrd files) from a remote
> Nagios instance. The number of systems I manage is fairly large so I
> am running

I am in a very similar situation and one of the people that expressed
interest in the "netsock" solution, altho my interest was also of a
different nature , you can see my old post here for some details if
you care:

http://mailman.verplant.org/pipermail/collectd/2009-August/002973.html

> So my options so far are:
> 1 extend unixsock plugin so "netsock" . if there aren't any plans in
> this direction i volunteer :)
> 2 save the rrd files on some nfs mount point and query directly from nagios
> 3 stick with nrpe
> 4 use collectd based triggers to submit passive checks to nagios

I'd like to add another option to the list:

5. Create a RESTful webservice to expose stored data

This would allow to develop checks that could be more complicated than
just looking at the last value.

This also plugs into this thread:

"Shouldnt collectd also provide an interface to the data?"
http://mailman.verplant.org/pipermail/collectd/2009-September/003102.html

which was aiming at pretty much the same thing and got similar
pointers to netcmd.

In my mind we want both, but for different reasons, and as far as
nagios is concerned imho creating a RESTful webservice is the right
choice in the way that different kinds of consumers can be written
that could heavily benefit from having access to the entire dataset.
Not to mention that if you run a large infrastructure you got to
appreciate the benefits of flexibility and security (with ssl) of
http.

I'll be trying to find some time to look at netcmd for caching next
month so I renew Florian's invitation in keeping the dev cycle short
and post updates to the list.

thanks!

-- 
"Behind every great man there's a great backpack" - B.