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

<?xml version="1.0" encoding="utf-8"?>

<yandex> 
  <clickhouse_remote_servers> 
    <perftest_3shards_1replicas> 
      <shard> 
        <internal_replication>true</internal_replication>  
        <replica> 
          <host>192.168.23.144</host>  
          <port>9000</port> 
        </replica> 
      </shard>  
      <shard> 
        <replica> 
          <internal_replication>true</internal_replication>  
          <host>192.168.23.145</host>  
          <port>9000</port> 
        </replica> 
      </shard>  
      <shard> 
        <internal_replication>true</internal_replication>  
        <replica> 
          <host>192.168.23.146</host>  
          <port>9000</port> 
        </replica> 
      </shard> 
    </perftest_3shards_1replicas> 
  </clickhouse_remote_servers>  
  <!--zookeeper相关配置-->  
  <zookeeper-servers> 
    <node index="1"> 
      <host>192.168.23.144</host>  
      <port>2182</port> 
    </node>  
    <node index="2"> 
      <host>192.168.23.145</host>  
      <port>2182</port> 
    </node>  
    <node index="3"> 
      <host>192.168.23.146</host>  
      <port>2182</port> 
    </node> 
  </zookeeper-servers>  
  <macros>
      <!--不同的机器修改次数的ip即可-->   
    <replica>192.168.23.144</replica> 
  </macros>  
  <networks> 
    <ip>::/0</ip> 
  </networks>  
  <clickhouse_compression> 
    <case> 
      <min_part_size>10000000000</min_part_size>  
      <min_part_size_ratio>0.01</min_part_size_ratio>  
      <method>lz4</method> 
    </case> 
  </clickhouse_compression> 
</yandex>

停止clickhouse

service clickhouse-server stop

启动clickhouse

service clickhouse-server start

连接clickhouse

clickhouse-client

查看clickhouse集群是否搭建成功

select * from system.clusters;