[rrd-developers] Re: pulling data from MySQL and graphing using RRDTool

[Alex van den Bogaerdt]

"Sheahan, John (PCLN-NW)" wrote:

>  I already have a large db of stats in MySQL that I simply want to graph. I
> really like the graphs that RRDTOOL produces since I am already using the
> complete package for my routers. However, I can't really see a way to
> effectively grab stats from another DB for graphing purposes without having
> to reenter all the data again in a round robin database. Any thoughts?

Currently it is not possible to use any other data source than the
internal database.

No problem, you're on the developers list so you are going to add
mySQL support.  Have a look at the file rrd_fetch.c, function
rrd_fetch_fn.  This function analizes the available data, compares
it with the desired time range and returns the most apropriate set
of data.

Don't forget to turn on debugging and make sure the data from mySQL
is in the right format.  This can be found in rrd_format.h and of
course in the docs.  In short, you need a series of numbers that
represent the interval from {time-stepsize}to{time}.

When you successfully did the excercise of hacking rrdtool, we should
talk about integrating it into 1.1.x

cheers,
-- 
   __________________________________________________________________
 / alex at slot.hollandcasino.nl                  alex at ergens.op.het.net \
| work                                                         private |
| My employer is capable of speaking therefore I speak only for myself |
+----------------------------------------------------------------------+
| Technical questions sent directly to me will be nuked. Use the list. | 
+----------------------------------------------------------------------+
| http://faq.mrtg.org/                                                 |
| http://rrdtool.eu.org  --> tutorial                                  |
+----------------------------------------------------------------------+

--
Unsubscribe mailto:rrd-developers-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-developers-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-developers
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi