grafana to MySQL or other database not on pi ?

Feeding since a few days now and love the grafana stats for the feeding part as you can 'easily' see how it goes, especially for gain etc

The latest image reboots every morning at 3am (I'm ok with that) but hence no long term data in grafana (avoid killing the card prematurely is a point I get)
Can grafana be tweaked to write for ex to another device (nas?) in a local network that for ex has MySQL and use that to write and read data instead ram (guess it is now ram driven)

If so, possible to have some kinda tuto ?

I could ask on Discord but this might interest others over time so I ask here

thanks for considering and maybe if there is enough demand it could become part of install .. local or remote etc with a few essential steps to config it.

 

I would like to hear the answer too... ;-)

 

In /etc/grafana/grafana.ini there's a section [database] that specifies this. It looks like grafana defaults to sqlite3 which is a file-based database. Try entering the IP address, username, password, etc for the mysql server.

 

no need to go in terminal really as grafana can talk to a MySQL database. Make one, link but ... you need a database structure I think
Will fiddle some tomorrow but not sure I can rebuild the database structure.

 

Grafana is the viewer.

Prometheus is the time series storage.

If you want to pull it off and save it forever then you can use that big tub of lube when you look at all the lines of data.

You need to run a Prometheus instance on your LAN and have it store it.

Prometheus:

<ipoffeeder>:9090/config

Metrics data that Prometheus ingests for exporters:

<ipoffeeder>:9100/metrics
<ipoffeeder>:9105/metrics

Or write something that reads the exporter data and saves it in whatever database you want to stoke to.

 

No .. sqlite just stores Grafana user login and config info. Grafana is a viewer.