Docker部署ClickHouse

拉取 镜像

docker pull yandex/clickhouse-server
docker pull yandex/clickhouse-client

创建配置文件目录

mkdir -p /opt/module/clickhouse/config
mkdir -p /opt/module/clickhouse/data
mkdir -p /opt/module/clickhouse/log

启动容器

docker run -d --name ch-server --ulimit  nofile=262144:262144 -p 8123:8123 -p 9000:9000 yandex/clickhouse-server

拷贝配置文件

docker cp clickhouse-server:/etc/clickhouse-server/config.xml /opt/module/clickhouse/config

docker cp clickhouse-server:/etc/clickhouse-server/users.xml /opt/module/clickhouse/config

docker cp clickhouse-server:/etc/clickhouse-server/config.d/docker_related_config.xml /opt/module/clickhouse/config

修改配置文件

<!-- 关闭监听地址 ./config/docker_related_config.xml 修改如下：-->

<!-- <listen_host>::</listen_host> -->
<!-- 打开监听地址 vim ./config/config.xml , 修改如下：-->

<listen_host>0.0.0.0</listen_host>
<!-- 查看users.xml文件，在<users></users> 中加入自定义用户dev -->

<dev>
    <password>123456</password>
    <networks incl="networks" replace="replace">
        <ip>::/0</ip>
    </networks>
    <profile>default</profile>
    <quota>default</quota>
    <allow_databases>
        <database>default</database>
    </allow_databases>
</dev>
     

docker-compose.yml

version: '3'
 
services:
  clickhouse:
    image: yandex/clickhouse-server:latest
    restart: always
    container_name: clickhouse
    ports:
      - "8123:8123"
      - "9000:9000"
    volumes:
      # 默认配置
      - /opt/module/clickhouse/config/docker_related_config.xml:/etc/clickhouse-server/config.d/docker_related_config.xml
      - /opt/module/clickhouse/config/config.xml:/etc/clickhouse-server/config.xml
      - /opt/module/clickhouse/config/users.xml:/etc/clickhouse-server/users.xml
      - /etc/localtime:/etc/localtime
      # 运行日志
      - /opt/module/clickhouse/log:/var/log/clickhouse-server
      # 数据持久
      - /opt/module/clickhouse/data:/var/lib/clickhouse

停用容器

docker stop ch-server && docker rm ch-server

重启容器

docker-compse -f docker-compose.yml up -d