Clickhouse Monitoring

This article introduces how Clickhouse monitoring works, and how to apply this monitoring on the resource

Introduction

ClickHouse is an open-source column-oriented DBMS (columnar database management system) for online analytical processing (OLAP) that allows users to generate analytical reports using SQL queries in real-time.

Pre-requisites

To configure the changes for ClickHouse monitoring you should:

• Create User
  • CREATE USER ‘< Username >’ IDENTIFIED WITH sha256_password BY ‘< Password >';
• Create Role
  • CREATE ROLE ‘< role >’
• Grant minimum privileges for monitoring needs to Role and grant it to the User
  
  1. GRANT SELECT ON system.* TO < role >
  2. GRANT < role > to ‘< Username >’
• Use this USERNAME and PASSWORD, and Role for Clickhouse monitoring.

Apply Clickhouse Monitoring

To apply a Clickhouse Monitoring:

1. From All Clients, select a client.
2. Go to Infrastructure > Resources.
3. From the available resources, select the required resource.
4. Select the monitor and from the Templates screen, click +Assign Templates, which displays the Apply Templates screen:

5. From Select Templates > Available templates, select clickhouse (v1) template. Selected templates display the chosen templates.
   Note: Select the Collector Type as Agent.

6. Click Assign, which displays the Enter Configurations section.

7. Enter Value for the Assigned Templates and Configuration Parameters and click Assign.
   Note: In the case of docker, input the ip address with the container ip address.

The templates screen displays the selected templates.

Supported Metrics