Docker-Compose部署clickhouse
目录
docker-compose部署clickhouse
先下载镜像
docker pull clickhouse/clickhouse-server:23.8.14.6-alpine
官网配置:
You may also want to mount:
/etc/clickhouse-server/config.d/*.xml - files with server configuration adjustmenets
/etc/clickhouse-server/users.d/*.xml - files with user settings adjustmenets
/docker-entrypoint-initdb.d/ - folder with database initialization scripts (see below).
启动容器 :
docker run -d -p 18123:8123 -p19000:9000 --name clickhouse --ulimit nofile=262144:262144 clickhouse/clickhouse-server:23.8.14.6-alpine
复制容器配置文件到宿主机
docker cp clickhouse:/etc/clickhouse-server/config.xml ./config
docker cp clickhouse:/etc/clickhouse-server/users.xml ./config
docker cp clickhouse:/etc/clickhouse-server/config.d/docker_related_config.xml ./config
停止并删除容器:
docker stop clickhouse && docker rm clickhouse
编写docker-compose.yaml
文件
version: '3'
services:
clickhouse:
image: clickhouse/clickhouse-server:23.8.14.6-alpine
container_name: clickhouse
restart: always
ports:
- "18123:8123"
- "19000:9000"
volumes:
# 默认配置
- /etc/localtime:/etc/localtime:ro
# 运行日志
- ./data/clickhouse/log:/var/log/clickhouse-server
# 数据持久
- ./data/clickhouse:/var/lib/clickhouse:rw
# 挂载配置
- ./config/docker_related_config.xml:/etc/clickhouse-server/config.d/docker_related_config.xml:rw
- ./config/config.xml:/etc/clickhouse-server/config.xml:rw
- ./config/users.xml:/etc/clickhouse-server/users.xml:rw
clickhouse默认用户名是default 没有密码
使用客户端连接测试: