[rrd-users] [Ganglia-general] Combining metrics from several RRD files

[Martin Knoblauch]

Hi Vladimir,

 thanks. That is also an option. What I came up with is the following RRD
magic. Combines 3 metrics metrics from 4 filesystems, removes the NaNs and
computes the percentage used accurately:

rrdtool xport --start now-366d --end now-1d \
 DEF:t000=vault_000_total.rrd:sum:AVERAGE \
 DEF:t001=vault_001_total.rrd:sum:AVERAGE \
 DEF:t002=vault_002_total.rrd:sum:AVERAGE \
 DEF:t003=vault_003_total.rrd:sum:AVERAGE \
 CDEF:total=t000,t001,ADDNAN,t002,ADDNAN,t003,ADDNAN,1.09951E+12,/ \
 DEF:u000=vault_000_used.rrd:sum:AVERAGE \
 DEF:u001=vault_001_used.rrd:sum:AVERAGE \
 DEF:u002=vault_002_used.rrd:sum:AVERAGE \
 DEF:u003=vault_003_used.rrd:sum:AVERAGE \
 CDEF:used=u000,u001,ADDNAN,u002,ADDNAN,u003,ADDNAN,1.09951E+12,/ \
 DEF:a000=vault_000_avail.rrd:sum:AVERAGE \
 DEF:a001=vault_001_avail.rrd:sum:AVERAGE \
 DEF:a002=vault_002_avail.rrd:sum:AVERAGE \
 DEF:a003=vault_003_avail.rrd:sum:AVERAGE \
 CDEF:avail=a000,a001,ADDNAN,a002,ADDNAN,a003,ADDNAN,1.09951E+12,/ \
 CDEF:pctc=total,avail,-,total,/ \
 XPORT:total:"Total (TB)" XPORT:used:"Used (TB)" XPORT:avail:"Avail (TB)"
XPORT:pctc:"PCT used (%)"

RRDTOOL is cool :-)

Cheers
Martin



On Fri, Jan 31, 2014 at 3:26 PM, Vladimir Vuksan <vlists at veus.hr> wrote:

> Another alternative is to use CSV or JSON export from the Web Ui eg
>
> http://blog.vuksan.com/2012/04/06/
>
> It will eg export all values from aggregate graphs as well so you can do
> the summing
>
>
> On 31. siječnja 2014. 09:19:30 EST, Martin Knoblauch <knobi at knobisoft.de>
> wrote:
>>
>> Hi Arnau,
>>
>>  not completely :-) I actually want to extract the data from the RRD
>> files and combine them into one, adding up the vaules. Good thing, I found
>> out about "rrdtool xport". I does what I want on the extracting. Now I just
>> need to do the summing up.
>>
>> Cheers
>> Martin
>>
>>
>> On Fri, Jan 31, 2014 at 11:21 AM, Arnau Bria <listsarnau at gmail.com>wrote:
>>
>>> On Fri, 31 Jan 2014 10:37:19 +0100
>>> Martin Knoblauch wrote:
>>>
>>> > Hi friends,
>>> Hi,
>>>
>>> >  hope somebody already had this problem and solved it. So I have a
>>> > cluster were we monitor the status (size, used, free) for several
>>> > filesystems using Ganglia. Looks all great in the browser, but now
>>> > the customer wants to have those data sets combined into one. In
>>> > order to not loose the data we have, I want to combine those into one
>>> > RRD. All the "source" RRDs have identical structure (RRAs) and
>>> > timestamps.
>>>
>>> > Any solution? Ideas?
>>>
>>> If I've understood you property:
>>>
>>> 1.-) use the "Aggregate Graphs" from ganglia's web.
>>> 2.-) create a custom grpah and add it to one host :
>>> quick google search:
>>>
>>> http://sourceforge.net/mailarchive/forum.php?thread_name=503E2A47.6020705%40gmail.com&forum_name=ganglia-general
>>>
>>> 3.-) as they are RRDs you can mix them using your own script (bash,
>>> perl, python....)
>>>
>>> HTH,
>>>
>>> > Cheers
>>> > Martin
>>> Arnau
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> WatchGuard Dimension instantly turns raw network data into actionable
>>> security intelligence. It gives you real-time visual feedback on key
>>> security issues and trends.  Skip the complicated setup - simply import
>>> a virtual appliance and go from zero to informed in seconds.
>>>
>>> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
>>> _______________________________________________
>>> Ganglia-general mailing list
>>> Ganglia-general at lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/ganglia-general
>>>
>>
>>
>>
> Vladimir
>



-- 
------------------------------------------------------
Martin Knoblauch
email: k n o b i AT knobisoft DOT de
www: http://www.knobisoft.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20140131/318a8607/attachment.htm