question

solarlion avatar image
solarlion asked

Using Influx & Grafana: Someone already created a downsampling and data retention script?

Hello,

I use the victron docker Images to push all Data from MQTT to a local Influx DB.
This is a very nice solution, having detailed 6 samples per Second for all measurements.
The Data consume about 300 MB per Day what is fine for a few month.

But I want to use this also for long term storage of the Data (>10 Years) as well.
So I want to use the influx data aggregation and retention methods to down sample old data.

Data older as 1 Month should get aggregated to 10 minutes slots, reducing the data consumption from 9 GB / Month to about 15 MB/Month.

Anyone already done this and can provide his downsampling task script? Would be great to share this, that not everyone needs to write it again and again.

Thank you

MQTTgrafanadocker
2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

0 Answers