This shows you the differences between two versions of the page.
|
сервис_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> | ||