Hello Dominic, Out of the various tools I've tried, netacct-mysql is currently my favorite. It collects bandwidth data through libpcap and stores in a MySQL DB. It comes with a PHP front end, but to me the real power is that it stores the stats in MySQL. Through SQL SELECT statements, I'm able to get all the stats I need. For instance:
mysql> SELECT SUM((input+output)/1073741824) FROM traffic WHERE IP='10.10.2.122' AND time LIKE '2007-09%'; gives me total (in+out) GBs of bandwith used by 10.10.2.122 during Sept 07. I run it on the Xen host to keep track of the guest domain bandwidth usage, but it should run on the Vyatta box just as well (haven't tried yet, sorry). The other thing I started playing with today is grabbing the data from the DB using PHP and feeding it to the chart PHP script from www.maani.us to get pretty graphs. I would love to know what you end up using! Cheers, -Alain. http://sourceforge.net/projects/netacct-mysql/ Dominic Williams wrote: > Many thanks for your response. > > What we need to generate is a traffic graph for each IP that we serve i.e. At > 4.20.00pm some IP was using 7Mbps, at 4.20.15pm it was using 5.2Mbps, at > 4.20.30 it was using 6.3Mbps and so on. > > We need this data is used to understand how sites (which run on IPs) behave > and also to provision overall bandwidth and pass bandwidth costs to clients. > > Is this possible and for example, is anyone doing 95th percentile billing > using a Vyatta router? > > Best, Dominic > > -----Original Message----- > From: "Holtz,Robert" <[EMAIL PROTECTED]> > To: "Dominic Williams" <[EMAIL PROTECTED]>; "[EMAIL PROTECTED]" <[EMAIL > PROTECTED]> > Sent: 07/11/07 16:27 > Subject: RE: [Vyatta-users] Want to use Vyatta for our main BGP router - > butwhat about traffic tracking? > > You can collect SNMP interface performance data anywhere along the path to > the outside world, not just the router. There's quite a bit of flexibility. > > Examples: > The Web Server itself > Load Balancer, if you have a bunch of web servers > Ethernet Switch(s) > Router > Etc. > > > > > > > If you are not the intended recipient of this message (including > attachments), or if you have received this message in error, immediately > notify us and delete it and any attachments. If you no longer wish to > receive e-mail from Edward Jones, please send this request to [EMAIL > PROTECTED] You must include the e-mail address that you wish not to receive > e-mail communications. For important additional information related to this > e-mail, visit www.edwardjones.com/US_email_disclosure > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dominic > Williams > Sent: Wednesday, November 07, 2007 10:07 AM > To: [EMAIL PROTECTED] > Subject: [Vyatta-users] Want to use Vyatta for our main BGP router - butwhat > about traffic tracking? > > Hello all, > > My company is very keen to try a Vyatta solution, as we are about to move our > hosting rack to a BGP solution and a 7204VXR with 1GB seems inordinately > expensive!! > > But... we need to be able to monitor and track bandwidth to each individual > IP address that we serve. > > This is a crucial requirement, as it is for many people involved in Web > hosting. > > At the moment we just use Netflow exports from our Cisco router in > conjunction with some tracking software... I know that Vyatta doesn't support > Neflow, but somebody indicated on this list that you can get at these stats > using SNMP. > > Is this really the case? Can you get at traffic flows for individual IPs that > are being served through the router? > > -- I was under the impression SNMP was just of use for monitoring the status > of a particular device / interface etc?? > > Many thanks for any advice you can give. > > Best, Dominic > > Dominic Williams > www.System7.com > www.Wyki.com > > Better Digital Publishing > Email > > [EMAIL PROTECTED] > Direct > > +44 (0) 203 0519110 ext. 8010 > Mobile > > +44 (0) 7710 469456 > Fax > > +44 (0) 8700 607555 > > Terms: This e-mail contains proprietary information some or all of which may > be legally privileged. It is intended for the recipient only. If an > addressing error or transmission error has misdirected this e-mail, please > notify the sender immediately or contact [EMAIL PROTECTED] If you are not the > intended recipient you must not use, disclose, distribute, copy, print or > rely on this e-mail. > > _______________________________________________ > Vyatta-users mailing list > Vyatta-users@mailman.vyatta.com > http://mailman.vyatta.com/mailman/listinfo/vyatta-users > > _______________________________________________ Vyatta-users mailing list Vyatta-users@mailman.vyatta.com http://mailman.vyatta.com/mailman/listinfo/vyatta-users
