Storing Time series in a DB instead RRD

[oliveratom]

Hello everyone,
I´m new at the forum and an old and rusty user of cacti, its been a while since I don't use it.
I'm now trying to implement it for monitoring infrastructure, and I would like to know if there is a way to store all the Time series values, collected from the network devices into a DB could be general purpose like MySQL or noSQL like MongoDB, then I will use a JS library to query the values and represent them graphically. In summary I will be using collectors and the framework of cacti but not using the data persistence with RRD. Do you think it is possible? If there is any article or topic in this forum I will be very glad if anyone can post it in the answers
Thanks in advance for your help

[phalek]

Hi

Yes, you actually can do this with the CereusTransporter plugin I wrote.

It currently doesn't support MongoDB, but it does support Boson, InfluxDB1, InfluxDB2 and OpenTSB,

I am testing it against InfluxDB so I know it works (See screenshots attached)

The version supporting InfluxDB2 is about to be released within the next days.

You can actually disable the rrd updates on Cacti, so it only feeds the noSQL databases ....

Checkout this post here: https://www.urban-software.com/2023/01/ ... influxdb2/

Or follow me on LinkedIn for some news: https://www.linkedin.com/in/thomasurban/

[TheWitness]

Believe it or not, I still prefer Cacti's UI, but love Grafana's dash-boarding and graphs creation interface. As one of the primary authors of Cacti, I'm glad to see such a nice dash-boarding interface such as Grafana's.

[oliveratom]

Thank you Phalek,
I will certainly take a look into it. It looks promising.


Best Regards.