[rrd-users] Re: Migrating RRD data to RDBMS

[Ruttenberg, Tanya]

Actually there is a group here that would like to store (and crunch
presumably) 
the 15 minute samples for a 5-year period.

Tanya  

-----Original Message-----
From: rrd-users-bounce at list.ee.ethz.ch
[mailto:rrd-users-bounce at list.ee.ethz.ch] On Behalf Of Ralf Kruedewagen
Sent: Thursday, January 26, 2006 2:11 AM
To: rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Re: Migrating RRD data to RDBMS

Hi,

one good reason for storing RRD data to RDBMS would be, that you can
calculate daily/weekly/monthly/yearly averages only for a certain time of
day (maybe workhours 8am-6pm). This is a requirement that I am actually
facing...
Better would be, of cource, if RRDTool could do that.

Ralf

On Wednesday 25 January 2006 20:28, PAUL WILLIAMSON wrote:
> I should ask why, because what does does have to do with anything 
> relational at all?  Then again, it's the government and I had my stint 
> with the Social Security Administration in DC on 14th street a while 
> ago, so to question why is pointless.
>
> What are you trying to gain?  5 minute samples?  30 minute averages?  
> Are you doing this so that some dba (maybe even you) can do some data 
> trending with a language a little more familiar (unlike the RRD.pm 
> maybe)?  Do you have to do this for long term data storage?  Do you 
> need to do this for a government requirement or something else?
> Does it need to be within x number of minutes of the data being 
> collected (like within a day)?
>
> Paul
>
> >>> "Ruttenberg, Tanya" <Tanya.Ruttenberg at ssa.gov> 01/25/06 12:20 PM
>
> We have a requirement to migrate data from RRD files to an RDBMS.
>
> My current idea is to do a daily export from the rrdfiles, parse the 
> export file, and update the RDBMS with the resulting numbers.
>
> Is anyone out there doing this already?  Suggestions?

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

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