From owner-freebsd-isp@FreeBSD.ORG Fri Jun 11 16:01:52 2004 Return-Path: Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5E7B316A4CE for ; Fri, 11 Jun 2004 16:01:52 +0000 (GMT) Received: from beast.clarksys.com (sm02.cthought.com [64.81.233.33]) by mx1.FreeBSD.org (Postfix) with SMTP id 1C9DB43D48 for ; Fri, 11 Jun 2004 16:01:52 +0000 (GMT) (envelope-from maxc@beast.clarksys.com) Received: (qmail 51525 invoked from network); 11 Jun 2004 15:59:11 -0000 Received: from unknown (HELO ?127.0.0.1?) (192.168.69.133) by sm02.cthought.com with SMTP; 11 Jun 2004 15:59:11 -0000 Message-ID: <40C9D761.6010601@beast.clarksys.com> Date: Fri, 11 Jun 2004 09:01:37 -0700 From: Max Clark User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-isp@freebsd.org References: <40C9CAD0.6060701@beast.clarksys.com> <200406110821.47866.jbarrett@amduat.net> In-Reply-To: <200406110821.47866.jbarrett@amduat.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: Bandwidth Usage Billing X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 Jun 2004 16:01:52 -0000 Jacob, Have you had any problems using mrtg+rrd to track this data? I guess the better question would be, what would advantages of using cricket over mrtg (or vice versa) be? Thanks, Max Jacob S. Barrett wrote: > On Friday 11 June 2004 08:08 am, Max Clark wrote: > >>MRTG is the defacto snmp bandwidth monitoring tool, however it does not >>track total GB transfered and the 95th percentile without external >>hacks, and even with this, your data will be truncated rather quickly. > > > You can configure MRTG or any other RRD based system to keep higher resolution > data longer. We keep the 5 second data for 3 months. After that I think it > goes into 20 minute averages that are kept for a year, then daily averages > for 5 years. The RRD files will be a lot larger, but a lot more accurate for > billing purposes. > > >>How does one set up a bandwidth billing system (are there systems >>already out there for this) to track their customer's usage? > > > We just us a simple perl script to sum up the RRD data at the end of the > billing cycle. We also have some PHP pages for customers to monitor their > usage over the month. > > Another company I know uses cricket to dump the data into a SQL database as > well as RRD. They use the RRD for graphing and the SQL for billing. >