[rrd-developers] Re: Idea for RRDtool 1.1.x: Database connectivity to store RRD data.

[gbrandt at pcibuf.com]

I would like to add to this thought.  We are tracking many devices on our
network, and also want a way of looking at historical data.  We are currently
using a script to generate the html page, and images, and then copy the images
to an archive directory.  Kludgey, but it works.  The ability to tie in a back
end database, and then generate the graphs for current and some past time period
would be great!.  Especially when viewed on the same page.


Gordon





Jakob Ilves <jakob.ilves at oracle.com> on 03/06/2001 04:06:04 AM

To:   rrd-developers <rrd-developers at list.ee.ethz.ch>
cc:    (bcc: Gordon A Brandt/PCI_BUFFALO)
Subject:  [rrd-developers] Idea for RRDtool 1.1.x: Database connectivity to
      store RRD data.



Hello!

More fuel for the 1.1.x feature discussion...

Currently the RRDtool use flat files for storing the data.  There has
already been discussions on using a database to store the data (the
particular discussion was related to MySQL, but in my case just being
able to connect to an Oracle database would be enough... ;-).

Any ideas of strategies for implementing this?  I think the code for
storing and retrieving RRD data from the database definitively should be
part of the C code rrdtool is made up of, especially as the current
store/retrieve code for the flat files are written in C.  Supporting
relational databases which use SQL would be a good start.

As I see it, there are different options:

1.) ODBC might be used which at least in theory should make RRDtool able
to access any ODBC compliant database.  How well this works in practice
need some investigation.  (Commersial ODBC vs freeware ODBC, how well
different flavours of databases works).
2.) Go get the connectivity stuff specific for the particular database
and then have tell configure to use that when configuring rrdtool prior
to build.
3.) Anything else I've missed...

Why use a database for the RRD data?  Several reasons: RRDtool get's
higher performance when storing/retrieving the data and has better
options for doing analysis of the already stored data etc.  RRDtool
would still be necessary, as it implements the logic of "Round Robin",
heartbeats etc.

Keep the comments coming!

Best regards

/IlvJa


--
                (Jakob Ilves) <jakob.ilves at oracle.com>
             {Oracle Global IT, Network Management Group}
[Office as well as mobile phone: +46/8/477 3666 | Fax: +46/8/477 3572]
         - Intranet Home Page: http://jilves.se.oracle.com -



-- Attached file removed by Listar and put at URL below --
-- Type: text/x-vcard
-- Desc: Card for Jakob Ilves
-- Size: 444 bytes
-- URL : http://www.ee.ethz.ch/~slist/pantomime/30-jakob.ilves.vcf


--
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






--
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