docker安装clickhouse

图形化管理工具DBeaver

一、docker镜像介绍

• 9000是clickhouse-client使用的端口

• 8123是HTTP连接clickhouse使用的端口。

• --ulimit nofile=65535:65535表示设置打开文件描述符的数量。

二、安装命令

1. 预先启动

   docker run -d -e CLICKHOUSE_DB=default -e CLICKHOUSE_USER=default -e CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=1 -e CLICKHOUSE_PASSWORD=default -p 9000:9000 -p 8123:8123 -v /software/clickhouse/data/:/var/lib/clickhouse/ -v /software/clickhouse/log/:/var/log/clickhouse-server/  --name clickhouse-server --ulimit nofile=262144:262144 clickhouse/clickhouse-server:23.1.5

2. 拷贝配置文件到外面（users.xml和config.xml配置文件需要先拷贝出来）

   docker cp clickhouse-server:/etc/clickhouse-server/config.xml /software/clickhouse/conf/config.xml
   docker cp clickhouse-server:/etc/clickhouse-server/users.xml /software/clickhouse/conf/users.xml

3. 实际启动

   docker run -d -e CLICKHOUSE_DB=default -e CLICKHOUSE_USER=default -e CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=1 -e CLICKHOUSE_PASSWORD=default -p 9000:9000 -p 8123:8123 -v /software/clickhouse/data/:/var/lib/clickhouse/ -v /software/clickhouse/log/:/var/log/clickhouse-server/ -v /software/clickhouse/conf/config.xml:/etc/clickhouse-server/config.xml -v /software/clickhouse/conf/users.xml:/etc/clickhouse-server/users.xml  --name clickhouse-server --ulimit nofile=262144:262144 clickhouse/clickhouse-server:23.1.5