[mrtg] Re: mrtg data into database

[fluhmann at vvm.com]

What data are you wanting to dump into a database?  I've dumped my *.cfg
data into a mySQL database.  If you're wanting to dump the data, look at
using RRDTool.  It stores the data in a Round Robin Database for each
interface.  You can set how long you wish to keep the 5min, 30min, 2hr,
1day, or whatever your interval is.  We have ours set for:
5 minute    3 months
30 minute   3 months
2 hour      3 months
1 day       2 years
Each of our database files ended up being approx. 1MB each.  We have about
150 interfaces (150 MB total storage).

I don't know if my reply was the direction that you were looking for, but
good luck.

Jeremy Fluhmann
McLane Information Systems Division
fluhmann at vvm.com

> Hi all,
>
> I was wondering if it is possible to dump mrtg data into a database for
> warehousing, etc...
>
> Is there someone out there doing this?
>
> Thanks in advance,
> Max


--
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