Grafana install

[JeeLet]

MyController for the management of the MySensors galaxy and the most Aboutie, it's a bit normal you might say
I tested a good range of home automation programs, and I always come back to MyC. Why?

So I decided to make MyC the Core and add around what I found on the Other Controllers

the last one is Motion which work with a Usb Cam, but I have to do it again to switch to Motionplus (evolution)

Today I launch the idea married MyC and Grafana
(which version? that goes with the influxdb version of Mycontroller)
Grafana

So when you have a moment Jkandasa can you tell us how to start on the right foot, an idea on how to bring up the values in Grafana?

...looking forward to reading your answers

[jkandasa]

@JeeLet I have not tried with Grafana. I will give a try and update you

[JeeLet]

good evening @jkandasa

no I haven't done anything yet, I'm on electrical measurements and a library to review.
But yes, it's great that you're looking at it.

it will make MyC even more interesting

[JeeLet]

[jkandasa]

@JeeLet Happy New Year!!
Great! Finally you got it.

[JeeLet]

a good year 2023 for you @jkandasa and your family.

myController --> influxDB --> Grafana
yes functional, and it's quite simple (the principle)
the discovery of influxDB and Grafana is rich.

I will surely have questions about the marriage between myC and influxDB (v1.8) ..... how the databases are created and deleted in time.

an image of the configuration

[JeeLet]

a question:

Can MyC manage the database of influxDB ?

a bit like on HAss : https://forum.hacf.fr/t/installer-influxdb-dans-home-assistant-et-booster-votre-base-de-donnee/360

cella will allow me to make cleaning of the old Node that I removed.

[JeeLet]

I try to read the future, yes the future is tomorrow (yes I have a crystal ball)

the elements that come out : TIG
Telegraf + InfluxDB + Grafana

and telegraf is an obligatory passage, evolution of influxDB v2

the infos put aside
https://www.sqlpac.com/fr/documents/influxdb-migration-v1-v2-procedure.html

major changes in influxDB
The TSI index is the default storage engine, the In-Memory index is removed.
Chronograf (visualization tool) is integrated in InfluxDB.
Flux becomes the default language and InfluxQL is unfortunately removed.
Continuous queries are replaced by Tasks.
The native support of OpenTSDB, Graphite, CollectD... protocols is also unfortunately removed in InfluxDB v2, Telegraf agents must be implemented.

then the next step is : ??? apt install telegraf ???

[jkandasa]

@JeeLet for now MyC do not delete influx data, when you remove your sensors from MyC. But it is required. I will add this feature soon if possible.

[jkandasa]

@JeeLet You can go with influx 2.x as well. MyC supports for influx 2.x

[JeeLet]

https://songrgg.github.io/operation/influxdb-command-cheatsheet/
the management of metrics in terminal mode with CLI commands for ver1.8 is not simple
a good thing with a graphical interface.

version 2.0 already has an integrated tool https://docs.influxdata.com/influxdb/v2.6/visualize-data/visualization-types/table/

Let's talk about MyC again.

on image of the architecture https://v2.mycontroller.org/doc-images/architecture.png

how the dialogue between the mys gateway and influxDB works

I don't understand the difference between StorageDB and MetricDB

you say "You can also use influx 2.x. MyC supports influx 2.x"?

on a next new installation I switch to the influxDB-2 version I don't have anything to modify in mycontroller ?? .... I may try ??

For the last test with grafana, the "mc_gauge_float_data" values work but not the "mc_binary_data" numbers
(maybe I'm wrong in the config)

[jkandasa]

@JeeLet I missed this thread somehow

I don't understand the difference between StorageDB and MetricDB

https://v2.mycontroller.org/docs/overview/architecture/#storage-database

you say "You can also use influx 2.x. MyC supports influx 2.x"?

Yes, influx 2.x supported, more configuration details on https://v2.mycontroller.org/docs/installation/advanced-installation/backend-configuration/#influxdb

on a next new installation I switch to the influxDB-2 version I don't have anything to modify in mycontroller ?? .... I may try ??

You have to update the configuration file as mentioned on the above link

For the last test with grafana, the "mc_gauge_float_data" values work but not the "mc_binary_data" numbers
(maybe I'm wrong in the config)

binary data is in the form of true or false.

[JeeLet]

I realize that the questions I ask, many are explained in the Documentation

Hello jkandasa
yes influx 2.x soon on a new install.
a new hardware base, maybe an Odroid-N2 !?

[jkandasa]

@JeeLet said in Grafana install:

a new hardware base, maybe an Odroid-N2 !?

I have not owned Odroid-N2. But it should work

[JeeLet]

MyController can be installed anywhere, it is pure carbon, the hardest material