创建目录并更改权限
mkdir -p /app/cloud/clickhouse/data mkdir -p /app/cloud/clickhouse/conf mkdir -p /app/cloud/clickhouse/log chmod -R 777 /app/cloud/clickhouse/data chmod -R 777 /app/cloud/clickhouse/conf chmod -R 777 /app/cloud/clickhouse/log |
拉取镜像
docker pull yandex/clickhouse-server:20.3.5.21 |
创建临时容器
docker run --rm -d --name=clickhouse-server \ --ulimit nofile=262144:262144 \ -p 8123:8123 -p 9009:9009 -p 9090:9000 \ yandex/clickhouse-server:20.3.5.21 |
复制临时容器内配置文件到宿主机
docker cp clickhouse-server:/etc/clickhouse-server/config.xml /app/cloud/clickhouse/conf/config.xml docker cp clickhouse-server:/etc/clickhouse-server/users.xml /app/cloud/clickhouse/conf/users.xml |
停掉临时容器
docker stop clickhouse-server |
创建default账号密码
PASSWORD=$(base64 < /dev/urandom | head -c8); echo "$PASSWORD"; echo -n "$PASSWORD" | sha256sum | tr -d '-' 会输出明码和SHA256密码(每个人生成的不一样) jQ+72k17 a70b3173bfef01aff0d2472fd1f86a4be647aed4e0624f1b6c867a69072e1273 |
创建root账号密码
PASSWORD=$(base64 < /dev/urandom | head -c8); echo "$PASSWORD"; echo -n "$PASSWORD" | sha256sum | tr -d '-' 会输出明码和SHA256密码(每个人生成的不一样) EhKo9q0z 3d37e813ba8e840306a17158aa6027251c064dc9c36fb1146ae6c5d001993acc |
修改 /app/cloud/clickhouse/conf/users.xml
vim /app/cloud/clickhouse/conf/users.xml
|
创建容器
docker run -d --name=clickhouse-server \ -p 8123:8123 -p 9009:9009 -p 9090:9000 \ --ulimit nofile=262144:262144 \ -v /app/cloud/clickhouse/data:/var/lib/clickhouse:rw \ -v /app/cloud/clickhouse/conf/config.xml:/etc/clickhouse-server/config.xml \ -v /app/cloud/clickhouse/conf/users.xml:/etc/clickhouse-server/users.xml \ -v /app/cloud/clickhouse/log:/var/log/clickhouse-server:rw \ yandex/clickhouse-server:20.3.5.21 |
重启clickhouse
systemctl restart clickhouse-server.service |
客户端连接
clickhouse-client
|
至此结束
此文参考:使用Docker安装ClickHouse