[rrd-users] Re: RRD Database Combining

Thomas Beecher tbeecher at localnet.com
Wed Mar 23 18:51:13 MET 2005

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.

  	DS0	DS1	DS2
Val at T1	0	10	0
Val at T2	0	10	0	
Val at T3	0	10	0

Val at T1	5
Val at T2	10
Val at T3	15

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

More information about the rrd-users mailing list