Installing InfluxDB 2.0 and Grafana 8

Configuration
1

I installed HA on Oracle Virtualbox/Ubuntu and running fine. I’m planning to install InfluxDB 2.0 and Grafana 8 on another container to keep the HA container light and easy to troubleshoot.

  • From your experience, what is the best way to install InfluxDB and Grafana? To use the HA plugin or on another host/container?
  • I also noticed when using Grafana 8 with InfluxDB 2.0 (easier to use), it doesn’t have the query builder InfluxQL, it uses Flux query language. Unless I’m missing something.
    Appreciate your help.
2
  1. Really depends on your Linux knowledge. If you are comfortable with Linux and docker, you will always have more flexibility when managing those yourselves.
  2. InfluxQL is deprecated in InfluxDB 2.X. Only Flex remains (to my great sadness). If you want it, use InfluxDB < 2.0
3

So this means in Grafana we will have to write the From …. syntax for every field?

4

Yes.
With Grafana and InfluxDB | Grafana Labs tells the influxdb UI has a graphical Flex query builder, though.

Never tried myself. I created a couple of Flex query manually and it was a PITA.

5

This whole concept of downgrading features in Influx 2.x is really beyond my thoughts. Even I’m stuck with not able to connect to Influx DB 2.x from Grafana using InfluxQL. Read many articles and none seem to be friendly/easy enough for someone to install it in peace. I been struggling from 2 days now…
I could connect via flux, but no luck with influxQL. People says I have to give a HTTP Header - Authenticator and Token - No clue which token is this… as influx DB 2.x gives various tokens and super confusing…

6

There is no influxql in influxdb 2.x at all

7

Influxdb2 support both api v1 (InfluxQL) and v2 (Flux). For access with InfluxQL need create mapping bucket to database. I’m added mapping by manual Query data with InfluxQL | InfluxDB Cloud Documentation and can access from Grafana to Home Assistant Influx data.