nanog mailing list archives
RE: Polling Bandwidth as an Aggregate
From: Nathan Eisenberg <nathan () atlasnetworks us>
Date: Fri, 20 Jan 2012 17:48:44 +0000
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).
Another RTG user! I didn't know many of us existed! RTG is a great tool. It's design (perl and PHP and MySQL) lends itself to being modified at will; integration with tools like PHP NetworkWeathermap is very straightforward (http://pastebin.com/9RiZx4A8), and the MySQL backend makes it super flexible. There's no aggregation of data, unless you hack it in yourself with some fancy queries. RTG's data is ideal for doing MySQL partitioning, and there are some indexes that need to be added. But when you get those things in place, it becomes fast and powerful - and it's easy to drop out old data without a lengthy query (just drop the partition). The fact that each SNMP device gets its own table is also a big performance win over the more popular tools. The web interface allows for interface aggregation, and the code for doing that could probably be reverse engineered easily enough for other reporting mechanisms as well. Nathan Eisenberg
Current thread:
- Re: Polling Bandwidth as an Aggregate, (continued)
- Re: Polling Bandwidth as an Aggregate Keegan Holley (Jan 20)
- Re: Polling Bandwidth as an Aggregate Nick Hilliard (Jan 20)
- Re: Polling Bandwidth as an Aggregate Ian Goodall (Jan 20)
- Re: Polling Bandwidth as an Aggregate Leo Bicknell (Jan 20)
- Re: Polling Bandwidth as an Aggregate Keegan Holley (Jan 20)
- Re: Polling Bandwidth as an Aggregate Nick Hilliard (Jan 20)
- Re: Polling Bandwidth as an Aggregate Chris Adams (Jan 20)
- Re: Polling Bandwidth as an Aggregate Steve Clark (Jan 20)
- Re: Polling Bandwidth as an Aggregate Keegan Holley (Jan 20)
- RE: Polling Bandwidth as an Aggregate Nathan Eisenberg (Jan 20)
- Re: Polling Bandwidth as an Aggregate Matt Addison (Jan 20)
- Re: Polling Bandwidth as an Aggregate Jeff Gehlbach (Jan 20)