Page 1 of 1

HowTo Migrate rrdtool to Mysql

Posted: Thu Aug 06, 2020 4:22 pm
by kuazoto
Dear Nagios Support,

We are trying to migrate from Nagios Core to Nagios XI, actually in Core we using PNP4Nagios addon, we know that PNP uses rrdtools as storage; then we are looking for a procedure to migrate from rrdtool storage to mysql storage (or MariaDB) and no longer use the rrdtools.


Is there a procedure to do this?
or what do you recommend?

Thanks

P.S. It is not migrating rrdtools from one system to another, really is migrating information from one type of database to another.

Re: HowTo Migrate rrdtool to Mysql

Posted: Fri Aug 07, 2020 8:31 am
by scottwilkerson
Nagios XI actually still uses a custom version of PNP4nagios and rrdtool for performance data.

If you want to migrade the data the RRD's would need to be places in /usr/local/nagios/share/perfdata/HOSTNAME/SERVICENAME.rrd (and .xml)

When you place these in XI, the new check much match the old exactly (same amount of datasources in the rrd) and the file you use will overwrite any new data if the .rrd already exists on the XI server.

Re: HowTo Migrate rrdtool to Mysql

Posted: Fri Aug 07, 2020 1:01 pm
by kuazoto
But, is possible to read rrdtool data and insert in another database as Mysql or DBMaria?

Re: HowTo Migrate rrdtool to Mysql

Posted: Fri Aug 07, 2020 1:15 pm
by scottwilkerson
kuazoto wrote:But, is possible to read rrdtool data and insert in another database as Mysql or DBMaria?
I'm sure it is possible but we don't have any experience with this as we do not have anything in any of our software that does this.

We are not the creators of RRDTool either, but the documentation is available here
https://oss.oetiker.ch/rrdtool/doc/index.en.html