User Tools

Site Tools


сервис_clickhouse

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

сервис_clickhouse [2023/12/09 16:21]
val created
сервис_clickhouse [2026/11/16 07:48] (current)
val
Line 1: Line 1:
 ====== Сервис ClickHouse ====== ====== Сервис ClickHouse ======
  
-  * [[https://​www.bytebase.com/​blog/​how-to-run-clickhouse-with-docker-and-connect-using-mysql-client/​|Run ClickHouse with Docker and Connect Using MySQL Client]]+  * [[https://​www.bytebase.com/​reference/​clickhouse/​how-to/​how-to-run-clickhouse-with-docker-and-connect-using-mysql-client/​|Run ClickHouse with Docker and Connect Using MySQL Client]] 
 + 
 +<​code>​ 
 +server# 
 +mkdir -p /​opt/​clickhouse/​{data,​logs} 
 +cd /​opt/​clickhouse 
 + 
 +server:/​opt/​clickhouse#​ cat docker-compose.yml 
 +services: 
 +  clickhouse:​ 
 +    image: clickhouse/​clickhouse-server:​26.10 
 +    container_name:​ clickhouse-otel 
 +    restart: unless-stopped 
 +    ports: 
 +      - "​127.0.0.1:​8123:​8123"​ 
 +      - "​127.0.0.1:​9000:​9000"​ 
 +    environment:​ 
 +      CLICKHOUSE_DB:​ otel 
 +      CLICKHOUSE_USER:​ zabbix 
 +      CLICKHOUSE_PASSWORD:​ "​zabbix"​ 
 +      CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT:​ 1 
 +    volumes: 
 +      - /​opt/​clickhouse/​data:/​var/​lib/​clickhouse 
 +      - /​opt/​clickhouse/​logs:/​var/​log/​clickhouse-server 
 +    ulimits: 
 +      nofile: 
 +        soft: 262144 
 +        hard: 262144 
 +         
 +# docker compose up -d 
 + 
 +# curl 127.0.0.1:​8123 
 +Ok. 
 + 
 +# /​usr/​share/​zabbix/​sql-scripts/​clickhouse/​otel_all.sh \ 
 +  -s http://​127.0.0.1:​8123 -d otel -u zabbix -p zabbix 
 + 
 +# docker exec -i clickhouse-otel clickhouse-client \ 
 +  --user zabbix --password "​zabbix"​ --database otel -q "SHOW TABLES"​ 
 + 
 +</​code>​
сервис_clickhouse.txt · Last modified: 2026/11/16 07:48 by val