- Platform information:
- Hardware: Raspberry PI4
- OS: OpenHabian, newest version
- Java Runtime Environment: OpenJDK8
- openHAB version: 2.5
- Issue of the topic: InfluxDB performs to slow
I was struggling with my OpenHab2 setup in regard to SD card performance. I had to deactivate my OpenHab logging in order to run my system in production. I have connected our solar inverter and our heating via network / modbus and both produce a lot of value changes which I would like to keep track within my influxdb.
Since every change was recorded as an event and basically got logged into openhab event log, plus triggered a persistence action into influxdb, plus was stored and processed within influxdb, the sd card was on its limits. As I said, I could solve the issue by turning off the logging, but this isnt the ideal solution.
Now, running this setup for quite a while (5 month now), the days get shorter, the nights get longer and I start to think about an alternative. Now I do have made up a list of requirements and I would like to get some feedbacks from you guys:
- I would like to have all my values from the solar inverter, the sensors for temperature, humidity and sunlight stored within a cloud based influxdb on AWS. This also serves as my “backup” for the values.
- I would like to have the values visibile from within the openhab sitemap (ideally) or at least a grafana dashboard. E.g. this could also mean, that I use the kostal binding for displaying values within openhab sitemap, but not storing them elsewhere.
- I wish to have a local “buffer” for values, that will store the values if the internet connection is unavailable.
- I am not interested in using the influxdb persistence for restoring data after restart, for this I simply use a mapdb with the latest values
Currently, I set up a prototype and use telegraf for reading the values from the kostal solar inverter into the influxdb cloud. This seems to work ok. I could do the same thing for my heating. Still wonder, if I can read other items from openhab using telegraf or if I would have to use mqtt to send the values from my thermostats and others sensors into the influxdb cloud. This would also give me a local “buffer”, wouldnt it?
Has anyone made up some experiences with such a setup or would you guys direct my into a different direction, e.g. setup everything locally with a attached SSD on my Raspberry PI4 and syncing / backing up data with a nightly cronjob, etc.?
Happy to hear from you.