Polling Bandwidth as an Aggregate

Brandon Ewing nicotine at warningg.com
Wed Jan 25 23:11:37 UTC 2012

On Fri, Jan 20, 2012 at 08:15:45AM -0500, Drew Weaver wrote:
> RTG uses MySQL for it's backend, so you can basically setup queries however you like and you can use RTGPOLL to graph multiple interfaces as well.
> It's a super good tool and I think there is a group working on RTG2 at googlecode (I think).
> -Drew

I agree with Drew -- I have several functions that do their best to
correlate readings amount multiple interfaces, combine them with other
readings near the same time intervals, and output a single set of aggregate
bandwidth data.

One of RTG's big problems is scalability -- as you monitor more and more
devices, going further and further back in time, you're ending up with a
gigantic MySQL dataset that can be difficult to manage.  Fortunately, there
are open-source tools to help manage this.  There's a Ruby program that
automates consolidation of multiple rows into single rows based on
configuration data -- allowing you to keep 5-minute readings of interface
data for 2 months, then condensing it to 1 hour readings after that, with
the flexibility to identify specific tables and specific timeframes to give
you maximum control.

Brandon Ewing                                        (nicotine at warningg.com)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://mailman.nanog.org/pipermail/nanog/attachments/20120125/f71908e9/attachment.sig>

More information about the NANOG mailing list