MySQL and rrd files

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Moderators, Developers

Post Reply
Author
Message
ashvillerob
Posts: 7
Joined: Fri Feb 18, 2005 12:01 pm

MySQL and rrd files

#1 Post by ashvillerob » Fri Feb 18, 2005 12:03 pm

Is it possible to import rrd files into some ofhter database such as MySQL, Access etc.

Or is there any other program that can read rrd files?

User avatar
rony
Developer/Forum Admin
Posts: 6016
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

#2 Post by rony » Fri Feb 18, 2005 12:20 pm

Yes and no...... Cacti is built to use rrd's. Can the data be extracted and saved to a database, file, email, etc., yes. But cacti only uses the rrd.

There are perl libraries and others for working with rrd's, rrdtool it's self is a good interface to the files.

So, what are you trying to acomplish?
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]

ashvillerob
Posts: 7
Joined: Fri Feb 18, 2005 12:01 pm

#3 Post by ashvillerob » Fri Feb 18, 2005 12:27 pm

I want to import the raw data that Cacti gathered into some other DB such as MySQL or Access so that I could run some custom reports against the data.

User avatar
rony
Developer/Forum Admin
Posts: 6016
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

#4 Post by rony » Fri Feb 18, 2005 12:36 pm

Look into rrdtool, it has a function to export the rrd into an XML file, then you can use that to import into whatever you like.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]

Post Reply