clickhouse 21.x 集群部署

标签（空测试用例格分隔）：clickhouse 系列

系统：
   centos7.9x64
 
 主机名字:
   cat /etc/hosts 
   
   -----
   
172.16.10.11    flyfishsrvs01
172.16.10.12    flyfishsrvs02
172.16.10.13    flyfishsrvs03
172.16.10.14    flyfishsrvs04
172.16.10.15    flyfishsrvs05
172.16.10.16    flyfishsrvs06
172.16.10.17    flyfishsrvs07 

   ------
  本次部署前四台服务器 

在flyfishsrvs02,flyfishsrvs03,flyfishsrvs04 上面部署

tar -zxvf jdk-8u301-linux-x64.tar.gz
mv jdk1.8.0_301/ /usr/local/jdk
vim /etc/profile 
----

### jdk
export JAVA_HOME=/usr/local/jdk
export CLASSPATH=.:$JAVA_HOME/jre/lib:$JAVA_HOME/lib:$JAVA_HOME/lib/tools.jar
PATH=$PATH:$HOME/bin:$JAVA_HOME/bin
----

source /etc/profile

java -version 




在flyfishsrvs02,flyfishsrvs03,flyfishsrvs04 上面部署
tar -zxvf apache-zookeeper-3.7.0-bin.tar.gz
mv apache-zookeeper-3.7.0-bin /usr/local/zookeeper

mkdir -p /usr/local/zookeeper/data
mkdir -p /usr/local/zookeeper/log

cd /usr/local/zookeeper/data/

echo 1 > myid
----
cd /usr/local/zookeeper/conf 

cp zoo_sample.cfg zoo.cfg 

vim zoo.cfg 

----
# 心跳时间
tickTime=2000
# follow连接leader的初始化连接时间，表示tickTime的倍数
initLimit=10
# syncLimit配置表示leader与follower之间发送消息，请求和应答时间长度。如果followe在设置的时间内不能与leader进行通信，那么此follower将被丢弃，tickTime的倍数
syncLimit=5
# 客户端连接端口
clientPort=2181
# 节点数据存储目录，需要提前创建，注意myid添加，用于标识服务器节点
dataDir=/usr/local/zookeeper/data
dataLogDir=/usr/local/zookeeper/log
server.1=172.16.10.12:2888:3888
server.2=172.16.10.13:2888:3888
server.3=172.16.10.14:2888:3888
---
-----

scp -r zookeeper root@172.16.10.13:/usr/local/
scp -r zookeeper root@172.16.10.14:/usr/local/
修改172.16.10.13 节点 myid 
cd /usr/local/zookeeper/data/
echo 2 > myid 
修改172.16.10.14 节点 myid
cd /usr/local/zookeeper/data/
echo 3 > myid


启动zookeeper 

cd /usr/local/zookeeper/bin/

./zkServer.sh start


rpm -ivh clickhouse-* [所有节点都安装处理]


修改listen_host

vim +164 /etc/clickhouse-server/config.xml

----
::1
flyfishsrvs01  ### 其它节点修改对于主机名
-----


配置集群连接文件
cd /etc/clickhouse-server/config.d
vim metrika.xml 
-----
 
     
         
            
               true
                   
                     flyfishsrvs01 
                     9000 
                   
            
            
               true 
                   
                     flyfishsrvs02 
                     9000 
                   
            
            
               true 
                   
                     flyfishsrvs03 
                     9000 
                   
           
            
               true 
                   
                     flyfishsrvs04 
                     9000 
                   
           
           
     
    
        
           flyfishsrvs02 
           2181 
         
        
          flyfishsrvs03 
          2181 
        
        
          flyfishsrvs04 
          2181 
        
     

      
        01 
        flyfishsrvs01 
      
      
         ::/0 
      
      
          
            10000000000 
            0.01 
            lz4 
          
      


---------------
scp metrika.xml root@flyfishsrvs02:/etc/clickhouse-server/config.d/
scp metrika.xml root@flyfishsrvs03:/etc/clickhouse-server/config.d/
scp metrika.xml root@flyfishsrvs04:/etc/clickhouse-server/config.d/



修改对应节点的副本主机名
vim 
#flyfishsrvs02节点修改metrika.xml中的宏变量如下： 
 
02
flyfishsrvs02 
 
#flyfishsrvs03节点修改metrika.xml中的宏变量如下: 
 
03
flyfishsrvs03 


#flyfishsrvs04节点修改metrika.xml中的宏变量如下: 
 
04
flyfishsrvs04 

 


#每台节点启动Clickchouse服务 
service clickhouse-server start
#每台节点查看clickhouse服务状态 
service clickhouse-server status 
#每台节点重启clickhouse服务 
service clickhouse-server restart 
#每台节点关闭Clikchouse服务 
service clickhouse-server stop


验证：
clickhouse-client -h flyfishsrvs01
查看集群：
select * from system.clusters;
select cluster,host_name from system.clusters;


其它节点验证：
select * from system.clusters;
select cluster,host_name from system.clusters;