[rrd-users] RRD Database Combining

[Thomas Beecher]

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