01-grafana.mdx 5.6 KB
Newer Older
1 2 3 4 5
---
sidebar_label: Grafana
title: Grafana
---

6
TDengine can be quickly integrated with the open-source data visualization system [Grafana](https://www.grafana.com/) to build a data monitoring and alerting system. The whole process does not require any code development. And you can visualize the contents of the data tables in TDengine on a dashboard.
7 8 9 10 11

You can learn more about using the TDengine plugin on [GitHub](https://github.com/taosdata/grafanaplugin/blob/master/README.md).

## Prerequisites

12
In order for Grafana to add the TDengine data source successfully, the following preparation is required:
13 14 15 16 17 18 19 20 21 22 23 24 25
1. The TDengine cluster is deployed and functioning properly
2. taosAdapter is installed and running properly. Please refer to the taosAdapter manual for details.

## Installing Grafana

TDengine currently supports Grafana versions 7.0 and above. Users can go to the Grafana official website to download the installation package and execute the installation according to the current operating system. The download address is as follows: <https://grafana.com/grafana/download>.

## Configuring Grafana

You can download The Grafana plugin for TDengine from <https://github.com/taosdata/grafanaplugin/releases/latest>. The current latest version is 3.1.4.

Recommend using the [``grafana-cli`` command-line tool](https://grafana.com/docs/grafana/latest/administration/cli/) for plugin installation.

S
Sean Ely 已提交
26
```bash
27 28 29 30 31 32 33 34 35 36 37 38
sudo -u grafana grafana-cli \
  --pluginUrl https://github.com/taosdata/grafanaplugin/releases/download/v3.1.4/tdengine-datasource-3.1.4.zip \
  plugins install tdengine-datasource
```

Or download it locally and extract it to the Grafana plugin directory.

```bash
GF_VERSION=3.1.4
wget https://github.com/taosdata/grafanaplugin/releases/download/v$GF_VERSION/tdengine-datasource-$GF_VERSION.zip
```

39
In CentOS 7.2 for example, extract the plugin package to /var/lib/grafana/plugins directory, and restart grafana.
40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64

```bash
sudo unzip tdengine-datasource-$GF_VERSION.zip -d /var/lib/grafana/plugins/
```

Grafana versions 7.3+ / 8.x do signature checks on plugins, so you also need to add the following line to the grafana.ini file to use the plugin correctly.

```ini
[plugins]
allow_loading_unsigned_plugins = tdengine-datasource
```

The TDengine plugin can be automatically installed and set up using the following environment variable settings in a Docker environment.

```bash
GF_INSTALL_PLUGINS=https://github.com/taosdata/grafanaplugin/releases/download/v3.1.4/tdengine-datasource-3.1.4.zip;tdengine- datasource
GF_PLUGINS_ALLOW_LOADING_UNSIGNED_PLUGINS=tdengine-datasource
```

## Using Grafana

### Configuring Data Sources

Users can log in to the Grafana server (username/password: admin/admin) directly through the URL `http://localhost:3000` and add a datasource through `Configuration -> Data Sources` on the left side, as shown in the following figure.

D
dingbo 已提交
65
![TDengine Database TDinsight plugin add datasource 1](./grafana/add_datasource1.webp)
66 67 68

Click `Add data source` to enter the Add data source page, and enter TDengine in the query box to add it, as shown in the following figure.

D
dingbo 已提交
69
![TDengine Database TDinsight plugin add datasource 2](./grafana/add_datasource2.webp)
70 71 72

Enter the datasource configuration page, and follow the default prompts to modify the corresponding configuration.

D
dingbo 已提交
73
![TDengine Database TDinsight plugin add database 3](./grafana/add_datasource3.webp)
74 75 76 77 78

- Host: IP address of the server where the components of the TDengine cluster provide REST service (offered by taosd before 2.4 and by taosAdapter since 2.4) and the port number of the TDengine REST service (6041), by default use `http://localhost:6041`.
- User: TDengine user name.
- Password: TDengine user password.

79
Click `Save & Test` to test. You should see a success message if the test worked.
80

D
dingbo 已提交
81
![TDengine Database TDinsight plugin add database 4](./grafana/add_datasource4.webp)
82 83 84

### Create Dashboard

85
Go back to the main interface to create a dashboard and click Add Query to enter the panel query page:
86

D
dingbo 已提交
87
![TDengine Database TDinsight plugin create dashboard 1](./grafana/create_dashboard1.webp)
88 89 90

As shown above, select the `TDengine` data source in the `Query` and enter the corresponding SQL in the query box below for query.

S
Sean Ely 已提交
91
- INPUT SQL: enter the statement to be queried (the result set of the SQL statement should be two columns and multiple rows), for example: `select avg(mem_system) from log.dn where ts >= $from and ts < $to interval($interval)`, where, from, to and interval are built-in variables of the TDengine plugin, indicating the range and time interval of queries fetched from the Grafana plugin panel. In addition to the built-in variables, custom template variables are also supported.
92 93 94 95 96
- ALIAS BY: This allows you to set the current query alias.
- GENERATE SQL: Clicking this button will automatically replace the corresponding variables and generate the final executed statement.

Follow the default prompt to query the average system memory usage for the specified interval on the server where the current TDengine deployment is located as follows.

D
dingbo 已提交
97
![TDengine Database TDinsight plugin create dashboard 2](./grafana/create_dashboard2.webp)
98 99 100 101 102 103

> For more information on how to use Grafana to create the appropriate monitoring interface and for more details on using Grafana, refer to the official Grafana [documentation](https://grafana.com/docs/).

### Importing the Dashboard

In version 2.3.3.0 and above, you can import the TDinsight Dashboard (Grafana Dashboard ID: [15168](https://grafana.com/grafana/dashboards/15167)) as a monitoring visualization tool for TDengine clusters. You can find installation and usage instructions in the TDinsight User Manual (/reference/tdinsight/).