I created instruction how to export Openwrt statistics (collected by Collectd) to Influxdb and then display them in Grafana. The graphs are almost realtime - the level of detail is 1 minute for last 24 hours. The statistics are downsampled what allows you to view information what was the system performance in the past (several month or years ago) while still keeping database size small. Of course level of details for statistics from one year ago is much lower (6 hours) that for the statistics for last 24 hours (1 minute).
Data is aggeregated and downsampled over time. Following aggregations are set:
Daily - data resolution is 1 minute
Weekly - data resolution is 5 minutes
Monthly - data resolution is 30 minutes
Yearly - data resolution is 6 hours
10 Year - data resolution is 1 day
100 Year - data resolution is 1 week
Original data send from collectd is store in Collect/autogen bucket
I do not have any image to share. However you can try to use any system and try to configure Docker. For the InfluxDB and Telegraf I used following commands:
Hi, @mstojek , I've try to install a system on Raspberry Pi3. I got all software running, but cannot receive the data from openwrt.
It seems no data into the influxdb, could you help?
For sure lack of udp in telegraf container is an issue.
Unfortunatelly I never fully set up this with Docker so I can not help you to solve docker issues here. On regular linux machine I would use tcpdump to check if collect is sending anything to UDP telegraf port, but with docker it might more tricky to debug this.
I noticed that collectd has some additional plugins on openwrt and some others are missing.
Why did you use telegraf before influxdb? Can't collectd write directly into influxdb?
I'm currently working on something similar, because influxdb made some weird changes to their open-source policies with version 3. Instead, I tried victoriametrics. And then I found there is collectd6 that uses standardized metrics naming based on the open telemetry standard.
While I used prometheus instead, during my research influxdb came up, and I remember reading that as of 2.x there is no native collectd support in influxdb, thus the need for telegraf or another "collector" in front of the database.