[148883] in North American Network Operators' Group
Re: Polling Bandwidth as an Aggregate
daemon@ATHENA.MIT.EDU (Brandon Ewing)
Wed Jan 25 18:12:30 2012
Date: Wed, 25 Jan 2012 17:11:37 -0600
From: Brandon Ewing <nicotine@warningg.com>
To: nanog@nanog.org
Mail-Followup-To: nanog@nanog.org
In-Reply-To: <F3318834F1F89D46857972DD4B411D70052ADD7C6F@exchange>
Errors-To: nanog-bounces+nanog.discuss=bloom-picayune.mit.edu@nanog.org
--KN5l+BnMqAQyZLvT
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
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 howev=
er you like and you can use RTGPOLL to graph multiple interfaces as well.
>=20
> It's a super good tool and I think there is a group working on RTG2 at go=
oglecode (I think).
>=20
> -Drew
>=20
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.
--=20
Brandon Ewing (nicotine@warningg.com)
--KN5l+BnMqAQyZLvT
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
iD8DBQFPIIwp7UrjtO3ToYoRAkxyAJ9jwTSyKUmJf7oqS0JY10kuLh6VQQCaAqd8
O9NDUBpx+4NBqIKHnFHBhus=
=8FBu
-----END PGP SIGNATURE-----
--KN5l+BnMqAQyZLvT--
