[rrd-users] Re: RRD Database Combining

[Thomas Beecher]

That would work for generating the graph using RRD, but I'm trying to 
create a 3rd RRD database that only holds a single DS.

Ex:
device1.rrd
  	DS0	DS1	DS2
Val at T1	0	10	0
Val at T2	0	10	0	
Val at T3	0	10	0

device2.rrd
	DS0
Val at T1	5
Val at T2	10
Val at T3	15

total.rrd
	DS0
Val at T1	15
Val at T2	20
Val at T3	25

I would then be able to run total.rrd through my existing Cricket CGIs 
to do the actual graph creation in the formats that I need.

The problem isn't creation of the graphs, it's getting values from 2 
different rrd files combined into one.


Thomas Beecher II
Network Administrator
LocalNet, Inc


MrPaulAR wrote:
> Something like this?
> 
> "DEF:device1=device1.rrd:ds0:AVERAGE",
> "DEF:devicd2=device2.rrd:ds1:AVERAGE",
> "CDEF:total=device1,device2,+",
> 
> Paul
> 
> On Wed, 23 Mar 2005 11:12:01 -0500, Thomas Beecher
> <tbeecher at localnet.com> wrote:
> 
>>Our organization currently uses the Cricket package to graph modem usage
>>across all of out dial in POPs. Cricket is storing the polled data in
>>standard RRD databases, and uses it's own CGIs to generate the graphs.
>>
>>Most POPs have multiple pieces of dial-in equipment, so we need to have
>>totals on one graph. For most areas this is not a problem, as Cricket
>>has a function to sum data from all defined targets and display that graph.
>>
>>We run into an issue when we have two different pieces of equipment in
>>the same POP. One type creates 3 data sources and 3 entries per polling
>>interval in the RRD database. The other creates one one DS, 1 entry. We
>>cannot use the Cricket sum function, as we need it to combine DS0 on oen
>>device with DS 1 on the other for an accurate graph.
>>
>>We are able to use the rrdtool command line to create combined graphs
>>like we want. However, we would like to be able to create a 3rd rrd
>>database to hold the totals, and have Cricket engine run the graphs with
>>the rest of our devices.
>>
>>The question then:
>>
>>Is it possible to combine two data sources from different RRD databases
>>into one? Ie. Combine device1.rrd:DS0 with device2.rrd:DS1 to create
>>total.rrd:DS0.
>>
>>If we can get at least that done, everything else we want to do would
>>fall into place. I have considered dumping each DB to XML, parsing for
>>the data I want, summing that up, generating new XML, and creating a new
>>DB from that, but it almost seems like that is more work than it needs
>>to be.
>>
>>Thanks in advance!!!
>>--
>>--
>>Thomas Beecher II
>>Network Administrator
>>LocalNet, Inc
>>325 Hampton Hill Drive
>>Williamsville, NY 14221
>>(716) 632-1133 x226
>>tbeecher at localnet.com
>>
>>--
>>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://www.ee.ethz.ch/~slist/rrd-users
>>WebAdmin    http://www.ee.ethz.ch/~slist/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://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi