[rtg] rtg graphing

[Brian T. O'Neill]

It all depends on your MySQL server. Faster your MySQL server the faster
you can draw the graphs. We have 1yr+ of data taking up about 1TB of
data on 45k+ oids. This is all done with the targetmaker package for
creating the target.cfg files and the php frontend for viewing the
collected results.

A standard 24 hour graph of all the graphs for an average host of ours
takes about 5 seconds to load. Thats with around 15 graphs being drawn.
When you click further to get the 8h/24h/7d/1m graphs it takes around 7
seconds for those 4 graphs to load. We turned off our 1yr graphs by
default as it would take too long to load and we rarely if ever used
them. We have it currently set as a configuration value in the gui to
set it (not in what has been released...)

Ofcourse, this also has alot to do with database tuning and disk speed.
Our current mysql server for RTG is a 2x1Ghz Sun V240 with 8G memory and
an Apple Xserve array with two raid 0+1 volumes striped using vertias
volume manager and vxfs filesystem. We're looking at replacing the
Xserve with something faster to increase polling intervals. We currently
poll every 60 seconds and it takes us around 33 seconds to poll 45k+
oids. On a number of our hosts we have a need to go down to possibly 10
second polling numbers... We also use a dedicated poller box and a
dedicated webserver.

So, yes, RTG has been implemented at that scale. We moved to RTG because
MRTG and RRD's couldn't keep up with our requirements, not even close.
We were having trouble doing 15k oid's in 5 minutes with RRD's and the
graph display times were too long unless you used some of the caching
interfaces for caching graphs...

Brian

Quoting eji (eji at yahoo-inc.com) from  :
> Hi guys,
> 
> I am looking for a good package for rtg graphing which
> is scalable with good performance for big rtg
> databases, say hundreds of devices and their interfaces
> with one year history data. 
> 
> Has someone deployed rtgplot with that scale? I am
> considering rtgplot or separate RRD graphing for now,
> but before I head into either one any suggestion is
> appreciated.
> 
> Thanks,
> Eric
> 
> 
> _______________________________________________
> RTG mailing list
> RTG at fireflynetworks.net
> http://fireflynetworks.net/mailman/listinfo/rtg

-- 
btoneill at misplaced.net

****************************************************************************
UNIX is simple and coherent, but it takes a genius (or at any rate a 
programmer) to understand and appreciate the simplicity."  - Dennis Ritchie
****************************************************************************