docker 部署 clickhouse

最新推荐文章于 2025-10-27 16:42:27 发布

原创最新推荐文章于 2025-10-27 16:42:27 发布 · 474 阅读

CC 4.0 BY-SA版权

文章标签：

# 1、可以参考下面连接，也可以参考我的博文
https://blog.youkuaiyun.com/qq_20042935/article/details/132554426

# 2、begin

启用ipv4转发
vim /etc/sysctl.conf
net.ipv4.ip_forward=1
systemctl network restart 

https://hub.docker.com/r/clickhouse/clickhouse-server

docker pull clickhouse/clickhouse-server:24.1.5.6

docker run --name clickhouse --ulimit nofile=262144:262144 -p 8123:8123 -p 9000:9000 -p 9009:9009 --privileged=true -d clickhouse/clickhouse-server:24.1.5.6

mkdir -p /home/db/clickhouse/config.d
mkdir -p /home/db/clickhouse/users.d

docker cp clickhouse:/etc/clickhouse-server/config.d /home/db/clickhouse/
docker cp clickhouse:/etc/clickhouse-server/config.xml /home/db/clickhouse/
docker cp clickhouse:/etc/clickhouse-server/users.d /home/db/clickhouse/
docker cp clickhouse:/etc/clickhouse-server/users.xml /home/db/clickhouse/

docker run --name clickhouse --restart=always --ulimit nofile=262144:262144 -p 8123:8123 -p 9000:9000 -p 9009:9009 --privileged=true -v /home/db/clickhouse/log:/var/log/clickhouse-server -v /home/db/clickhouse/config.d:/etc/clickhouse-server/config.d -v /home/db/clickhouse/config.xml:/etc/clickhouse-server/config.xml -v /home/db/clickhouse/users.d:/etc/clickhouse-server/users.d -v /home/db/clickhouse/users.xml:/etc/clickhouse-server/users.xml -v /home/db/clickhouse/data:/var/lib/clickhouse -d clickhouse/clickhouse-server:24.1.5.6

#防止磁盘空间越用越大
TRUNCATE table system.query_log;
TRUNCATE table system.trace_log;
TRUNCATE table system.asynchronous_metric_log;
TRUNCATE table system.metric_log;
TRUNCATE table system.part_log;

ALTER TABLE system.query_log MODIFY TTL event_date + toIntervalDay(1);
ALTER TABLE system.trace_log MODIFY TTL event_date + toIntervalDay(1);
ALTER TABLE system.asynchronous_metric_log MODIFY TTL event_date + toIntervalDay(1);
ALTER TABLE system.metric_log MODIFY TTL event_date + toIntervalDay(1);
ALTER TABLE system.part_log MODIFY TTL event_date + toIntervalDay(1);


修改时区
在配置文件config.xml中
<timezone>Asia/Shanghai</timezone>

# 启用防火墙
firewall-cmd --zone=public --add-port=8123/tcp --permanen
firewall-cmd --zone=public --add-port=9000/tcp --permanen
firewall-cmd --zone=public --add-port=9009/tcp --permanen
firewall-cmd --reload

# 验证服务是否可用
curl http://IP地址:8123            #OK

# clickhouse-client接入
docker exec -it clickhouse-server bash

#打开交互
clickhouse-client        

#查看已有数据库
show databases;

#执行SQL语句生成柱图
select bar(number,0,10) from numbers(10)

# dbeaver客户端接入