[mrtg] Re: mrtgsql - a MRTG to SQL logging and reporting tool

Marc Bilodeau marc at somix.com
Tue Feb 17 17:02:29 MET 2004


We have. RRDTool stores the data faster then MySQL, and RRDTool's footprint
is smaller by far. Some of our large WebNM installs have gigs of MySQL data
for every data point for several years. However, management wants the data
in a format that they can use multiple tools to manipulate the data. Some of
our customers use tools like crystal report with our product because crystal
is where their expertise is.

With the right settings to MySQL, it can keep up with 5,000 to 10,000
reports. Of course this depends on factors such as hard drives, and other
hardware. We prefer to let RRDTool calculate the data point, then we store
the data values to the MySQL database. Its been a couple of years and a few
versions until we've gotten it right.

Sincerely,
Marc
http://www.somix.com/support/mrtg_repository.php

-----Original Message-----
From: Tobias Oetiker [mailto:oetiker at ee.ethz.ch] 
Sent: Tuesday, February 17, 2004 10:29 AM
To: Marc Bilodeau
Cc: 'MRTG Mailinglist'
Subject: RE: [mrtg] Re: mrtgsql - a MRTG to SQL logging and reporting tool


Today Marc Bilodeau wrote:

> Good question tobi, at Somix our denika/webnm products write the 
> polled data to both the RRD files and the MySQL back-end. We believe 
> that users should have a quick reference for daily, weekly, monthly, 
> and yearly data. However, if the user needs to create a report based 
> on 5 minute samples between 8am and 5pm for Tuesday, Thursday, and 
> Friday on the week of October 23 they can with the stored data. Some 
> would argue by increasing the amount of data that can be stored in the 
> rrd file would do the trick. However, many other tools out there can 
> take advantage of the database via ODBC or a direct connection.

Hi Marc,

Yep, that seems like a sensible thing .... I would assume though that in a
setup with MANY datasources, that mysql may probably not be able to keep up
or fill up quickly if no data is deleted ...

have you done any tests in this direction ? mysql vs rrd performance?

cheers
tobi


-- 
 ______    __   _
/_  __/_  / /  (_) Oetiker @ ISG.EE, ETZ J97, ETH, CH-8092 Zurich  / // _ \/
_ \/ /  System Manager, Time Lord, Coder, Designer, Coach
/_/ \.__/_.__/_/   http://people.ee.ethz.ch/~oetiker   +41(0)1-632-5286

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi



More information about the mrtg mailing list