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 没有密码

使用客户端连接测试:

0%