[rrd-users] Re: Using Multiple RRDs for graphing

[Tobias Oetiker]

Today you sent me mail regarding [rrd-users] Using Multiple RRDs for graphing:

*> As the subject says,
*> 
*> I have 3 machine from which I am graphing mail and data throughput
*> for capacity management purposes.
*> 
*> The network looks like this
*> 
*>                          /---- Mail Srv 1 ----\
*>                         /                      \
*> Company Side mail------<------ Mail Srv 2 ------>------ 'Wild' Internet
*>                         \                      /
*>                          \---- Mail Srv 3 ----/
*> 
*> On the company side, there are an additional 12 + mail relays from all 
*> over the UK feeding up to this mail server farm.
*> 
*> At an individual machine level, I am graphing what I need, however, I
*> would like to graph the sum total of the stats collected from all three
*> They all share the same common format for the rrd database and what I 
*> want to do is to use 'rrdtool graph' to read all three databases and 
*> allow me to aggregate the results as one graph.
*> 
*> 
*> Assuming that the datafiles are mail1.rrd, mail2.rrd and mail3.rrd
*> is it permissable to graph data from different RRD sources? It's not
*> implied that you can, so Im guessing. ie
*> 
*> /usr/local/bin/rrdtool  graph   $DIR/messages-day.gif           \
*>         -v "No. of Messages"                                    \
*>         -i                                                      \
*>         -w 800                                                  \
*>         -h 300                                                  \
*>         -t "Rolling 24hr graph of Aggregate Mail totals Date: `date \"+%a %D [ %T ]\"`"       \
*>         --start -86400                                          \
*>         DEF:msgs_from_1=$DIR/mail1.rrd:msgs_from:AVERAGE        \
*>         DEF:msgs_to_1=$DIR/mail1.rrd:msgs_to:AVERAGE            \
*>         DEF:msgs_from_2=$DIR/mail2.rrd:msgs_from:AVERAGE        \
*>         DEF:msgs_to_2=$DIR/mail2.rrd:msgs_to:AVERAGE        	\
*>         COMMENT:"Colour Key:"                                   \
*>         AREA:msgs_total#00ff00:msgs_total                       \
*> 	CDEF:Total_out=msgs_from_1+msgs_from_2			\
*> 	CDEF:Total_in=msgs_to_1+msgs_to_2			\
*>         LINE1:msgs_from#ff0000:Total_out                        \
*>         LINE1:msgs_to#ff00ff:Total_in                           

well the correct syntax is:

CDEF:Total_out=msgs_from_1,msgs_from_2,+
LINE1:Total_out at ff0000:"Total out"


*> Incidentally, is there a way of getting two or three lines depth in the
*> legend rather than one? I couldn't make out how that could be done
*> 
*> ie vertical alignment
*> 
*> total	Machine1	Machine2
*> X	A		B
*> Y	C		D

rrdgraph uses a monospaced font so you can use spaces for alignment ... 

check the tutorial to get started with rrdtool ... 
*> 
*> Phil
*> =--=
*> 
*> --
*> * To unsubscribe from the rrd-users mailing list, send a message with the
*>   subject: unsubscribe to rrd-users-request at list.ee.ethz.ch
*> 
*> 

-- 
 ______    __   _
/_  __/_  / /  (_) Oetiker, Timelord & SysMgr @ EE-Dept ETH-Zurich
 / // _ \/ _ \/ / TEL: +41(0)1-6325286  FAX:...1517  ICQ: 10419518 
/_/ \.__/_.__/_/ oetiker at ee.ethz.ch http://ee-staff.ethz.ch/~oetiker

--
* To unsubscribe from the rrd-users mailing list, send a message with the
  subject: unsubscribe to rrd-users-request at list.ee.ethz.ch