go directly to the => Online Monitor
We are creating a monitoring system which can integrate data from different solar system manufacturers (like Growatt and Sun/Deye) or battery vendors (like Victron/Pylontech).
Technically we will use a temporal database (InfluxDb) and a report generator (Grafana). The concept is as follows:
- The different solar system installations are called “clients”. They are mapped to individual buckets in Influx.
- normal Bucket names start with a country code, followed by a short identifier. We only use [a-zA-Z0-9_].
- Maybe in future we will have a metadata bucket named clients describing important properties of the clients.
- Measurements are domains of interest like epower , water , heating.
- Values are written in camelCase_UNIT syntax, e.g. “epower.fromGrid_W”.
- Tags describe the physical measurement units, no special chars allowed
(W, kWh, Percent, m3, d, ..) - The insert rate depends on the data sources, it should not be longer than 15 minutes. Precision of timestamps is seconds.
- We have a separate User (named as the bucket) for each bucket with R/W access. User and access token are generated in the ssh using the Influx CLI.
- Regular Grafana queries show the data of a single client installation: Therefore they use the specific Influx User for the bucket
- The admin user can access all buckets and he can define queries which cover more than one installation.
BUCKET clients
name
country
timezone
location
group
----------------------------------------------------
BUCKET de_abc_1
MEASUREMENT epower
VALUES fromGrid_W, toGrid_W,
fromBat_W, toBat_W
pvToGrid_W, pvToBat_W, pvToLoad_W
batSoc_Percent
MEASUREMENT water
VALUES use_m3, saltRange_d
MEASUREMENT heat
VALUES furnace_C,
radSet_C, radTo_C,
floorSet_C, floor_to_C
hotWater_C, hotWater_W
----------------------------------------------------
TAGS W, kWh, Percent, d, m3, ..EXAMPLE: de_bn_25 / water / m3 / use_m3 / 17.55 / timestamp
This would be the cold water total value im cubic meters for de_bn_25