[rrd-users] Re: adding holt-winters forecasting to existing databases

[Darryl Lewis]

I think I followed it all, except for step 3. How do I feed the data into the new database?
Would you be able to expand that a little?

thank you 
Darryl

-----Original Message-----
From: rrd-users-bounce at list.ee.ethz.ch
[mailto:rrd-users-bounce at list.ee.ethz.ch]On Behalf Of Alex van den
Bogaerdt
Sent: Sunday, 10 September 2006 12:46 AM
To: rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Re: adding holt-winters forecasting to existing
databases


On Sun, Sep 10, 2006 at 12:27:41AM +1000, Darryl Lewis wrote:

> I have about 100 rrd's that I'd like to modify and add Holt-Winters forecasting to.
> Being that I have a 12 months worth of data in each of them, I'm reluctant to blow them away and start again.
> I'd like to modify the existing databases to include 
> 
> RRA:HWPREDICT:rows:alpha:beta:seasonal period[:rra-num] 
> RRA:SEASONAL:seasonal period:gamma:rra-num 
> RRA:DEVSEASONAL:seasonal period:gamma:rra-num 
> RRA:DEVPREDICT:rows:rra-num 
> RRA:FAILURES:rows:threshold:window length:rra-num 
> 
> Does anyone have a script or procedure / set of instructions to add these to existing rrd's?

No experience with HW, but transfering available data to a new database
should be standard.

1:
Create the new database, make sure to set "--start" slightly earlier than
the oldest data you're going to insert.

2:
Tune the new RRD so that it accepts gauge data (no matter the real DS types).
Also set the heartbeat to a high number, at least as high as the largest
step*steps in your RRAs.

3:
Use rrdtool fetch to get data out of the original RRD. Feed this data into
the new RRD

4:
Tune the RRD back to its original settings.


Step 3 may involve a couple of substeps, depending on the resolution of
your RRAs.  Make sure you understand data consolidation and you'll know
what to do.

HTH
-- 
Alex van den Bogaerdt
http://www.vandenbogaerdt.nl/rrdtool/

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://lists.ee.ethz.ch/rrd-users
WebAdmin    http://lists.ee.ethz.ch/lsg2.cgi


==============================================================================
The information contained in this email and any attachment is confidential and
may contain legally privileged or copyright material.   It is intended only for
the use of the addressee(s).  If you are not the intended recipient of this
email, you are not permitted to disseminate, distribute or copy this email or
any attachments.  If you have received this message in error, please notify the
sender immediately and delete this email from your system.  The ABC does not
represent or warrant that this transmission is secure or virus free.   Before
opening any attachment you should check for viruses.  The ABC's liability is
limited to resupplying any email and attachments
==============================================================================

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://lists.ee.ethz.ch/rrd-users
WebAdmin    http://lists.ee.ethz.ch/lsg2.cgi