09.12.2017

Grafana and ClickHouse manual integration

Deprecation notice

After 25th of November 2018 this guide isn’t required anymore. We automated all configuration steps and migrated all logic to Visual Traffic, please use this link instead.

If you installed Visual Traffic before, please reinstall it to enable all fresh features.

Requirements

Please finish this guide before starting current

Grafana and ClickHouse

As first step we need to add a user in ClickHouse with the same password as you use for HTTP authentication for Grafana admin panel. That’s quite misleading but that’s how Clickhouse integration plugin works.

Please open configuration file:

sudo vim /etc/clickhouse-server/users.xml

And then add following into block “users” (replace new_password by your password):

<admin>
 <password>new_password</password>
 <networks incl="networks" replace="replace"><ip>::/0</ip></networks>
 <profile>default</profile>
 <quota>default</quota>
</admin>

Apply changes:

sudo service clickhouse-server restart

Add data source in Grafana

Name: Clickhouse
Type: ClickHouse
URL settings: http://localhost:8123
Access: Server

Example configuration: