[rrd-users] Re: RRD Database Combining

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@T1 0 10 0
Val@T2 0 10 0
Val@T3 0 10 0

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

total.rrd
DS0
Val@T1 15
Val@T2 20
Val@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@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@localnet.com
>>
>>--
>>Unsubscribe mailto:rrd-users-request@list.ee.ethz.ch?subject=unsubscribe
>>Help mailto:rrd-users-request@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@list.ee.ethz.ch?subject=unsubscribe
Help mailto:rrd-users-request@list.ee.ethz.ch?subject=help
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi