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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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
