ClickHouse分布式集群部署

前提：首先每个集群上搭建zookeeper集群。
ZooKeeper入门（五）配置集群和选举机制_怪只怪满眼尽是人间烟火的博客-CSDN博客一. 配置集群1. 准备多台ZooKeeper服务器 2. 配置ZooKeeper服务器在每台服务器的conf/zoo.cfg文件中添加如下内容：server.20=192.168.4.20:2888:3888server.21=192.168.4.21:2888:3888server.22=192.168.4.22:2888:3888格式： server.A=B...https://blog.csdn.net/weixin_38959210/article/details/97800533
然后每个集群上都部署ClickHouse
CentOS安装ClickHouse_怪只怪满眼尽是人间烟火的博客-CSDN博客安装前准备：1.取消打开文件数限制：修改打开文件限制，修改修改两个文件，分别是： vi /etc/security/limits.confvim /etc/security/limits.d/20-nproc.conf在上面两个文件末尾都添加：* soft nofile 1024000* hard nofile 1024000* soft nproc 1024000* hard nproc 10240002.关闭selinux：sudo vim /etc/shttps://blog.csdn.net/weixin_38959210/article/details/120123128
集群部署：每个集群上都新建一个文件：/etc/metrika.xml
touch /etc/metrika.xml true192.168.23.144【ClickHouse分布式集群部署】9000true192.168.23.1459000true192.168.23.1469000192.168.23.1442182192.168.23.1452182192.168.23.1462182192.168.23.144::/0100000000000.01lz4 停止clickhouse
service clickhouse-server stop 启动clickhouse
service clickhouse-server start 连接clickhouse
clickhouse-client 查看clickhouse集群是否搭建成功
select * from system.clusters;