How I setup my InfluxDB
Setting up InfluxDB for home automation. Utilizing Buckets, Measurements, Fields, and Tags with MQTT, Zigbee2MQTT, OpenMQTTGateway, and Node-Red for data collection and processing.
Setting up InfluxDB for home automation. Utilizing Buckets, Measurements, Fields, and Tags with MQTT, Zigbee2MQTT, OpenMQTTGateway, and Node-Red for data collection and processing.
The solution described allows for enriching metadata in Grafana by combining data from InfluxDB with data from a MySQL database. This is achieved using Flux, the query language for InfluxDB, and the join function to merge the data based on a common attribute (topic in this case).
This is an instruction how to backup data in fluxdb in a configuration of a influxdb docker container managed with portainer.