初识ClickHouse

安装

拉取镜像

1
docker pull clickhouse/clickhouse-server

创建挂载目录

1
2
3
mkdir -p /data/clickhouse/data
mkdir -p /data/clickhouse/conf
mkdir -p /data/clickhouse/log

拷贝配置文件

1
2
3
4
5
docker run -d --rm --name=clickhouse clickhouse/clickhouse-server
docker cp clickhouse:/etc/clickhouse-server/config.xml /data/clickhouse/conf/config.xml
docker cp clickhouse:/etc/clickhouse-server/users.xml /data/clickhouse/conf/users.xml
docker stop clickhouse
docker rm -f clickhouse

修改配置文件

1
vim /data/clickhouse/conf/users.xml

如果使用明文密码, 需要修改<password>标签, 如果使用sha256密码, 需要修改<password_sha256_hex>标签
<password>明文密码</password>
<password_sha256_hex>密文密码</password_sha256_hex>

密文密码生成方法

1
echo -n "password" | sha256sum

启动 ClickHouse

1
docker run -d --name=clickhouse --ulimit nofile=262144:262144 -p 8123:8123 -p 9000:9000 -v /data/clickhouse/data:/var/lib/clickhouse -v /data/clickhouse/conf:/etc/clickhouse-server -v /data/clickhouse/log:/var/log/clickhouse-server clickhouse/clickhouse-server