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

 
   
     
       
        true  
         
          192.168.23.144  
          9000 
         
        
       
         
          true  
          192.168.23.145  
          9000 
         
        
       
        true  
         
          192.168.23.146  
          9000 
         
       
     
    
    
   
     
      192.168.23.144  
      2182 
      
     
      192.168.23.145  
      2182 
      
     
      192.168.23.146  
      2182 
     
    
  
         
    192.168.23.144 
    
   
    ::/0 
    
   
     
      10000000000  
      0.01  
      lz4 
     
   

停止clickhouse

service clickhouse-server stop

启动clickhouse

service clickhouse-server start

连接clickhouse

clickhouse-client

查看clickhouse集群是否搭建成功

select * from system.clusters;