
I have long wanted historical data on temperatures. Not sure why, but it might be interesting. Enter the influxdb persistence plugin and grafana (now I need to work out how to back them up too I guess).
Backing up influxdb turns out to be easy and I will add this to the backup script:
influxd backup -portable -database openhabian /mnt/nas/backup/openhabian/influxdb
rpi can just about run inlfuxdb 1.6 and can be installed by apt, and was enough. I just followed the instructions below then set it up in OpenHAB. I then had to work out how to actually store information in teh database. grafana was much easier.
Influxdb notes
- https://docs.influxdata.com/influxdb/v1.6/introduction/installation/ but I used apt then followed the configuration instructions
- You need to go in to the CLI and create a database, user and password which are then configured in openhab.
- Then edit /etc/openhab/persistence/influxdb.persist – not sure about the line “Temperature* : strategy = everyHalfHour, everyChange”
sudo vi /etc/openhab/persistence/influxdb.persist
influxdb.persist
Strategies {
everyMinute : "0 * * * * ?"
everyHour : "0 0 * * * ?"
everyHalfHour : "0 0,30 * * * ?"
everyDay : "0 0 0 * * ?"
default = everyChange
}
Items {
Tasmota4Fridge_Tas04PowerNow : strategy = everyMinute
Tasmota2_Watts : strategy = everyMinute
EMONPIMQTTThing_HousePowerwatts : strategy = everyMinute
KitchenEvohome_Temperature : strategy = everyHalfHour, everyChange
MasterBedEvohome_Temperature : strategy = everyHalfHour, everyChange
Tasmota01PowerNowW : strategy = everyMinute, everyChange
Tasmota3TVStack_Tasmota03PowerNow : strategy = everyMinute
WeatherandForecast_OutdoorTemperature : strategy = everyHalfHour, everyChange
emonpiMQTTThing_EmonPiExternelTemp : strategy = everyHalfHour, everyChange
SnugThermostat_Temperature : strategy = everyHalfHour, everyChange
Temperature* : strategy = everyHalfHour, everyChange
}
grafana notes
I just did all this then set up influxdb and created some graphs:
https://grafana.com/tutorials/install-grafana-on-raspberry-pi/
There is no obvious backup solution yet, but I will explore this: https://github.com/ysde/grafana-backup-tool