---
title: Monitoring Deployment
slug: telemetry-pipeline/monitoring-deployment
docTags: 
createdAt: 2026-01-06T07:54:18.424Z
---

### 1. ClickHouse Installation

**1.1 ClickHouse Setup**

:::BlockQuote
sudo dnf install -y curl ca-certificates
sudo curl https\://builds.altinity.cloud/yum-repo/altinity.repo \\
-o /etc/yum.repos.d/altinity.repo
sudo dnf install -y clickhouse-server clickhouse-client
sudo systemctl enable clickhouse-server
sudo systemctl start clickhouse-server
sudo systemctl status clickhouse-server
:::

**1.2 Installation Verification and Table Creation**

Connect to ClickHouse:

:::BlockQuote
clickhouse-client
:::

Check version:

:::BlockQuote
SELECT version();
:::

Create tables:

:::BlockQuote
USE monitoring;

DROP TABLE IF EXISTS event\_sampling;

CREATE TABLE event\_sampling (
  event\_id UUID,
  insert\_time DateTime,
  component\_id String,
  component\_type String,
  component\_kind String,
  string String,
  timestamp String,
  message String,
  name String,
  namespace String,
  kind String,
  value\_type String,
  value String
)
ENGINE = MergeTree
ORDER BY insert\_time
TTL insert\_time + INTERVAL 1 DAY;
:::

:::BlockQuote
CREATE TABLE monitoring\_metric (
  name String,
  timestamp DateTime64(3),
  tags Tuple(
    component\_id LowCardinality(String),
    component\_kind LowCardinality(String),
    host LowCardinality(String)
  ),
  value Float64
)
ENGINE = MergeTree
ORDER BY (timestamp, name)
SETTINGS index\_granularity = 8192;
:::

Verify tables:

:::BlockQuote
SHOW TABLES;
DESCRIBE TABLE event\_sampling;
DESCRIBE TABLE monitoring\_metric;
:::

**1.3 CMS – ClickHouse Integration**

**Same server setup:**

:::BlockQuote
MONITOR\_CH\_HOST: http\://127.0.0.1:8123
MONITOR\_CH\_PORT: 8123
MONITOR\_CH\_DB: vectorlogs
MONITOR\_CH\_USER: default
MONITOR\_CH\_PASS: kron
MONITOR\_CH\_TABLE: monitoring\_metric
:::

**Different server setup:**
 Edit ClickHouse config:

:::BlockQuote
sudo nano /etc/clickhouse-server/config.xml
:::

:::BlockQuote
\<listen\_host>0.0.0.0\</listen\_host>
:::

Restart ClickHouse:

:::BlockQuote
sudo systemctl restart clickhouse-server
:::

:::BlockQuote
Ensure port **8123** is accessible (firewall / cloud security rules).
:::

**Port Conflict Note:**
&#x20;If CMS and ClickHouse run on the same server, change ClickHouse ports 9004–9006 to 9104–9106.