Use Grafana with InfluxDB OSS

Use Grafana or Grafana Cloud to visualize data from your InfluxDB instance.

The instructions in this guide require Grafana Cloud or Grafana v7.1+.

  1. Start InfluxDB OSS 2.1.
  2. Sign up for Grafana Cloud or download and install Grafana.
  3. Visit your Grafana Cloud user interface (UI) or, if running Grafana locally, start Grafana and visit http://localhost:3000 in your browser.
  4. In the left navigation of the Grafana UI, hover over the gear icon to expand the Configuration section. Click Data Sources.
  5. Click Add data source.
  6. Select InfluxDB from the list of available data sources.
  7. On the Data Source configuration page, enter a name for your InfluxDB data source.
  8. Under Query Language, select one of the following:

Flux
InfluxQL

Configure Grafana to use Flux

With Flux selected as the query language in your InfluxDB data source, configure your InfluxDB connection:

  1. Under Connection, enter the following:

  2. Click Save & Test. Grafana attempts to connect to the InfluxDB 2.1 datasource and returns the results of the test.

Use Grafana - 图1

Configure Grafana to use InfluxQL

To query InfluxDB OSS 2.1 with InfluxQL, find your use case below, and then complete the instructions to configure Grafana:

Installed a new InfluxDB instance

To configure Grafana to use InfluxQL with a new install of InfluxDB 2.1, do the following:

  1. Authenticate with InfluxDB 2.1 tokens.
  2. Manually create DBRP mappings.

Upgraded from InfluxDB 1.x to 2.x

To configure Grafana to use InfluxQL when you’ve upgraded from InfluxDB 1.x to InfluxDB 2.1 (following an official upgrade guide):

  1. Authenticate using the non-admin v1 compatible authentication credentials created during the upgrade process.
  2. Use the DBRP mappings InfluxDB automatically created in the upgrade process (no action necessary).

Manually migrated from InfluxDB 1.x to 2.x

To configure Grafana to use InfluxQL when you’ve manually migrated from InfluxDB 1.x to InfluxDB 2.1, do the following:

  1. If your InfluxDB 1.x instance required authentication, create v1 compatible authentication credentials to match your previous 1.x username and password. Otherwise, use InfluxDB v2 token authentication.
  2. Manually create DBRP mappings.

View and create InfluxDB v1 authorizations

InfluxDB OSS 2.1 provides a 1.x compatible authentication API that lets you authenticate with a username and password like InfluxDB 1.x (separate from the credentials used to log into the InfluxDB user interface).

View existing v1 authorizations

Use the influx v1 auth list to list existing InfluxDB v1 compatible authorizations.

  1. influx v1 auth list

Create a v1 authorization

Use the influx v1 auth create command to grant read/write permissions to specific buckets. Provide the following:

  • bucket IDs to grant read or write permissions to
  • new username
  • new password (when prompted)
  1. influx v1 auth create \
  2.   --read-bucket 00xX00o0X001 \
  3.   --write-bucket 00xX00o0X001 \
  4.   --username example-user

View and create InfluxDB DBRP mappings

When using InfluxQL to query InfluxDB, the query must specify a database and a retention policy. InfluxDB DBRP mappings associate database and retention policy combinations with InfluxDB 2.1 buckets.

DBRP mappings do not affect the retention period of the target bucket. These mappings allow queries following InfluxDB 1.x conventions to successfully query InfluxDB 2.1 buckets.

View existing DBRP mappings

Use the influx v1 dbrp list to list existing DBRP mappings.

  1. influx v1 dbrp list

Create a DBRP mapping

Use the influx v1 dbrp create command command to create a DBRP mapping. Provide the following:

  • database name
  • retention policy name (not retention period)
  • bucket ID
  • (optional) --default flag if you want the retention policy to be the default retention policy for the specified database

Examples

DB with one RP DB with multiple RPs

  1. influx v1 dbrp create \
  2.   --db example-db \
  3.   --rp example-rp \
  4.   --bucket-id 00xX00o0X001 \
  5.   --default
  1. # Create telegraf/autogen DBRP mapping with autogen
  2. # as the default RP for the telegraf DB
  4. influx v1 dbrp create \
  5.   --db telegraf \
  6.   --rp autogen \
  7.   --bucket-id 00xX00o0X001 \
  8.   --default
  10. # Create telegraf/downsampled-daily DBRP mapping that
  11. # writes to a different bucket
  13. influx v1 dbrp create \
  14.   --db telegraf \
  15.   --rp downsampled-daily \
  16.   --bucket-id 00xX00o0X002

For more information about DBRP mapping, see Database and retention policy mapping.

Configure your InfluxDB connection

With InfluxQL selected as the query language in your InfluxDB data source settings:

  1. Under HTTP, enter the following:

    • URL: Your InfluxDB URL.

      1. http://localhost:8086/

    • Access: Server (default)

  2. Configure InfluxDB authentication:

  3. Click Save & Test. Grafana attempts to connect to the InfluxDB 2.1 data source and returns the results of the test.

Use Grafana - 图2

Query and visualize data

With your InfluxDB connection configured, use Grafana and Flux to query and visualize time series data stored in your InfluxDB instance.

For more information about using Grafana, see the Grafana documentation. If you’re just learning Flux, see Get started with Flux.

grafana