Docker ClickHouse搭建

• 拉取镜像

docker pull yandex/clickhouse-server:20.3.10.75

• 生成初始容器

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

• 进入初始容器

docker exec -it clickhouse-server /bin/bash

• 查看容器所有数据库

clickhouse-client

show databases;

为了让容器clickhouse 允许远程访问，将clickhouse的配置文件拷贝出来

• 复制容器文件

docker cp clickhouse-server:/etc/clickhouse-server/ /usr/local/clickhouse-server/

• 进入本地config.xml配置文件

cd /usr/local/clickhouse-server/ vim config.xml

将 <!-- <listen_host>::</listen_host> --> 修改为 <listen_host>::</listen_host> 允许外网访问

• 进入本地user.xml配置文件

vim user.xml

• 配置root账户：

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

• 移除初始容器

docker stop clickhouse-server

docker rm clickhouse-server

docker ps

• 构建容器

sudo docker run --privileged --restart=always -itd

-p 8123:8123 -p 9000:9000 -p 9009:9009

--name clickhouse

--ulimit nofile=262144:262144

-v /usr/local/Cellar/clickhouse/clickhouse_db:/var/lib/clickhouse

-v /usr/local/Cellar/clickhouse:/etc/clickhouse-server/config.xml

-v /usr/local/Cellar/clickhouse/users.xml:/etc/clickhouse-server/users.xml

yandex/clickhouse-server:20.3.10.75



sudo docker run --privileged --restart=always -itd

-p 8123:8123 -p 9000:9000 -p 9009:9009

--name clickhouse --ulimit nofile=262144:262144

-v /usr/local/clickhouse-server/clickhouse_db:/var/lib/clickhouse

yandex/clickhouse-server:20.3.10.75

• 复制配置文件进容器

docker cp /usr/local/clickhouse-server clickhouse:/etc/

• 重启clickhouse容器

docker restart clickhouse

• 链接DBeaver