clickhouse集群部署21.6

环境:
OS:Centos 7
版本:21.6.6.51
机器:
192.168.1.118
192.168.1.134
192.168.1.135

-----------------------zookeeper部署-----------------------------------------
安装步骤请参考:https://www.cnblogs.com/hxlasky/p/14665752.html

------------------------单机安装---------------------------------------------
每台机器安装步骤相同
1.下载clickhouse
需要下载如下3个按照包
clickhouse-common-static-21.6.6.51-2.x86_64.rpm
clickhouse-client-21.6.6.51-2.noarch.rpm
clickhouse-server-21.6.6.51-2.noarch.rpm

下载地址为:https://packagecloud.io/Altinity/clickhouse
或是这里下载

https://mirrors.tuna.tsinghua.edu.cn/clickhouse/rpm/stable/x86_64/

2.安装
rpm -ivh clickhouse-common-static-21.6.6.51-2.x86_64.rpm
rpm -ivh clickhouse-client-21.6.6.51-2.noarch.rpm
rpm -ivh clickhouse-server-21.6.6.51-2.noarch.rpm

这里会提示输入默认的密码,可以直接回车 不需要密码，后面单独对用户进行设置密码

3.修改数据目录和日志目录
vi /etc/clickhouse-server/config.xml

数据目录修改的地方

/var/lib/clickhouse/

日志目录修改的地方
trace
/var/log/clickhouse-server/clickhouse-server.log
/var/log/clickhouse-server/clickhouse-server.err.log

4.配置远程登录
vi /etc/clickhouse-server/config.xml

将之前注释掉的

去掉注释并修改为
0.0.0.0
localhost

5.启动
[root@localhost clickhouse21]# systemctl start clickhouse-server.service

6.登录
clickhouse-client --host localhost --port=9000 -m
clickhouse-client --host 192.168.1.118 --port=9000 -m

------------------------集群安装---------------------------------------------

1.创建 /etc/metrika.xml 文件

<?xml version="1.0"?>

  
    
      
        true
        
          192.168.1.118
          9000
        
      
      
        
          true
          192.168.1.134
          9000
        
      
      
        true
        
          192.168.1.135
          9000
        
      
    
  
  
  
    "1">
      192.168.1.118
      2182
    
    "2">
      192.168.1.134
      2182
    
    "3">
      192.168.1.135
      2182
    
  
  
    01
    192.168.1.118
  
  
    ::/0
  
  
    <case>
      10000000000
      0.01
      lz4
    case>
  

每台机器都创建该文件,红色部分需要根据机器ip进行修改,不同的地方如下,同时注意zookeeper配置的端口
192.168.1.118:

01
192.168.1.118


192.168.1.134:

02
192.168.1.134


192.168.1.135:

03
192.168.1.135

2.修改 /etc/clickhouse-server/config.xml 文件

    
    /etc/metrika.xml
    
    
    incl="zookeeper-servers" optional="true">
    
    
    incl="clickhouse_remote_servers">  
        
        
            
							


						

							
							
			ClickHouse