mysql data storage

Templates, scripts for templates, scripts and requests for templates.

Moderators: Moderators, Developers

Post Reply
Author
Message
mini4mw2
Posts: 18
Joined: Fri Sep 02, 2016 8:44 am

mysql data storage

#1 Post by mini4mw2 » Tue Feb 12, 2019 5:48 pm

I've searched a bunch and I haven't found anything and just wanted to double check on the forum...

I need to copy data into DB/data warehouse to keep poller exact data for 3+ years. Are there any existing methods for pushing data into RRD and into a (mySQL) DB? I've seen some references to modifying the poller to do both (RRD/MySQL), but no actual solutions. I've seen some comments on scripting the extraction from rrd files and piping into a DB. Just looking for something existing before going down any development paths.

Thanks-

netniV
Cacti Guru User
Posts: 2670
Joined: Sun Aug 27, 2017 12:05 am

Re: mysql data storage

#2 Post by netniV » Wed Feb 13, 2019 9:01 am

You would need to write something currently or use splunk with the plugin that exports cacti data to it. But whatever you chose, it will add an overhead onto your cacti instance so you should try and keep this historic data on a separate server.

Post Reply