Distributed SNMP monitoring.

[Carroll, Jim P [Contractor]]

Like yourself, I'm wishful of basically what you're asking for.

But (I might be mistaken) I think the design of RRDtool is to leverage a
round-robin database.  MySQL (or any relational database) is anything but.

If programming were my forté, I'd be looking at ways of extracting data from
a MySQL database and leveraging the GD graphics library for creating images
similar to RRDtool.  Who knows, maybe someone's already done this.

jc

> -----Original Message-----
> From: Frater, Greg J [mailto:gjfrater at bechtel.com]
> Sent: Monday, December 09, 2002 9:19 AM
> To: 'Stanley Hopcroft'; nagios-users at lists.sourceforge.net
> Subject: RE: [Nagios-users] Distributed SNMP monitoring.
> 
> 
> Just a thought...Can rrd write to a database like mysql, I 
> thought it could.
> If so what would it take to code Nagios or a wrapper of some 
> sort like the
> urlize check to write the check performance data to a 
> database backend then
> use apan and or rrd to create the graphs for viewing the 
> data.  This may be
> a off the wall idea, it sounded good this morning.
> 
> -----Original Message-----
> From: Stanley Hopcroft [mailto:Stanley.Hopcroft at IPAustralia.Gov.AU]
> Sent: Sunday, December 08, 2002 5:09 PM
> To: nagios-users at lists.sourceforge.net
> Subject: Re: [Nagios-users] Distributed SNMP monitoring.
> 
> 
> Dear Sir,
> 
> FWIW, there seems to be no serious competitor to RRD for saving time 
> series data.
> 
> 
> On Sun, Dec 08, 2002 at 04:46:06AM -0500, Furnish, Trever G wrote:
> > Well, actually, if by "fully integrated" you mean "as 
> integrated as anyone
> > could ever want", then no, it's not fully integrated. :-)  
> No offense - it
> > looks like a very nice contribution - but I for one would 
> greatly prefer
> not
> > to have to spawn off rrdtool to open and close its files 
> again every time
> > nagios wants to save data.  It'd be nice if whatever 
> performance archiving
> > mechanism gets focused on is one where the long-running 
> nagios process
> > communicates directly with a long-running, all files held 
> open rrdtool
> > process or a database.
> > 
> > It looks like (ok, have I given away the fact yet that I 
> haven't actually
> > set up apan yet? ;-) ) APAN works by getting called every 
> time you call a
> > command you want to record performance info for, then 
> returning the result
> > to Nagios and kicking off an rrdtool process to archive it. 
>  Although the
> > apan and rrdtool executables will probably be in OS read 
> cache, that's
> still
> > a lot of additional overhead.
> > 
> > Comments intended constructively, corrections appreciated...
> >
> 
> I am not sure if I follow you, but it is not necessary to 'spawn off 
> rrdtool' since rrdtool has a public API and shared libraries (in at 
> least C and Perl) that implement the API.
> 
> The RRD fetch, update, create functions can be called directly from
> Nagios in the same way that it can call any other function that is
> properly linked (such as the Perl functions if Nagios is built with
> embedded Perl support) with it.
> 
> I don't see this as 'a lot of additional overhead', especially with 
> Dynamic loading.
> 
> Projects that use this approach include the new RRD plugin for Ntop 
> (Again FWIW, Ntop has replaced DB interfaces to mySQL and friends by 
> RRD).
> 
> RRD tool buys an extraordinary amount of power in
> 
> . its data manipulation functions
> 
> . it offers (development at this stage) Holt-Winters time series
> prediction (from Jake Brutlag of Microsoft). This is an RRA that
> predicts the next values of data like interface octets that vary
> periodically, based on historical values of data and variance.
> 
> It is good way to automatically detect if traffic levels have altered
> significantly, far more sophisticated than simply setting thresholds.
> 
> > -t.
> >
> 
> Yours sincerely. 
> 
> -- 
> --------------------------------------------------------------
> ----------
> Stanley Hopcroft
> --------------------------------------------------------------
> ----------
> 
> '...No man is an island, entire of itself; every man is a piece of the
> continent, a part of the main. If a clod be washed away by the sea,
> Europe is the less, as well as if a promontory were, as well as if a
> manor of thy friend's or of thine own were. Any man's death diminishes
> me, because I am involved in mankind; and therefore never send to know
> for whom the bell tolls; it tolls for thee...'
> 
> from Meditation 17, J Donne.
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> 


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