[rrd-developers] Re: MySQL Integration

[Don Kukral]

Well, this is what I've got so far.  I've added a new option to rrdtool
called fetch_mysql.  It's called as follows:

rrdtool fetch_mysql \
  --datasource
"host=h;user=u;password=p;database=d;table=t;t_col=tc;v_col=vc;" \
  --start start \
  --end end

Here's a breakdown of the nv pairs in the datasource parameter.

  host: hostname of db
  user: db username
  password: db password
  database: db name
  table: table name
  t_col: column with time values
  v_col: column with values

Tomorrow I'll probably start on a graph_mysql option.  Then the plan is
to go back and add functionality for multiple datasources.

Don

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