On 6/9/06 11:52 AM, "Bernard Li" <[EMAIL PROTECTED]> wrote:
> Hi Eli:
>
>> As far as pulling data out of the RRD's for reporting, I've
>> had to whip up
>> some things in the past for dumping to CSV to be inclusive with other
>> reports... Doing this for Cacti and Ganglia was quite the learning
>> experience. What I mainly took out of it is a disdain for
>> the format and
>> tools, and new motivation to move to storing everything in a
>> RDBMS and away
>> from RRD entirely.
>
> There was talk about replacing RRD with MySQL by some users previously,
> I wonder how that went...
>
> Now that I think about it, it makes more sense to archive data in MySQL
> and if you want historical data/graphs, then you go to MySQL (as opposed
> to RRD for live feeds).
>
> I suppose that's what you're doing (sort of)?
>
> Cheers,
>
> Bernard
>
Yep, what with trying to integrate a bunch of open-source tools with
unfriendly (RRD) to evil (Nagios) data storage, I actually think that's
relatively hopeless. There are a couple of projects with the requisite
backend down pat (Zabbix, MOODSS). Unfortunately, due to their relatively
new nature, they're missing some of the more critical functionality that
Nagios has (uber-configurable backend, web (not binary) UI), as well as
there being nothing that can touch Ganglia wrt efficiency and simplicity of
monitoring an actual cluster of *nix hosts.
Anyhow, I'd love to see Ganglia (gmetad) with the option to pass commits to
an external program in addition to the RRD handling internally... That would
save the project (coders :) from having to develop an entire schema and
database handling tasklist. It would also be great for (at least me), where
I don't WANT a super-tool that does it all, but would rather keep using
individual tools for their great parts (Cacti, Ganglia) but want to divert
the data they collect into a single schema for aggregation of all output
into one database.
I've got a (now vapor) project on my plate to do this, currently Cacti is
the easiest to handle forking data to a database. Nagios data is actually
hell it looks like, and Ganglia non-possible (at the moment). There are
some patches to rrdtool that aren't mainlined, that support MySQL... But
it'd be far preferable to be DB-agnostic, and I don't think that it would be
possible to use that directly with Ganglia anyhow.
Any other thoughts or desire for others to have similar functionality?
/eli
