为了我们方便找到我们的配置信息，我们将CK集群做分开配置

修改集群配置

  • 修改vim /etc/clickhouse-server/config.xml配置文件
  1. <zookeeper>
  2.     <node index="1">
  3.         <host>zk1</host>
  4.         <port>2181</port>
  5.     </node>
  6.     <node index="2">
  7.         <host>zk2</host>
  8.         <port>2181</port>
  9.     </node>
  10.     <node index="3">
  11.         <host>zk3</host>
  12.         <port>2181</port>
  13.     </node>
  14. </zookeeper>
  16. <remote_servers>
  17.     <ck_cluster>
  18.         <shard>
  19.             <weight>1</weight>
  20.             <internal_replication>true</internal_replication>
  21.             <replica>
  22.                 <host>ck1</host>
  23.                 <port>9000</port>
  24.             </replica>
  25.             <replica>
  26.                 <host>ck2</host>
  27.                 <port>9000</port>
  28.             </replica>
  29.         </shard>
  30.         <shard>
  31.             <weight>1</weight>
  32.             <internal_replication>true</internal_replication>
  33.             <replica>
  34.                 <host>ck2</host>
  35.                 <port>9000</port>
  36.             </replica>
  37.             <replica>
  38.                 <host>ck3</host>
  39.                 <port>9000</port>
  40.             </replica>
  41.         </shard>
  42.         <shard>
  43.             <weight>1</weight>
  44.             <internal_replication>true</internal_replication>
  45.             <replica>
  46.                 <host>ck3</host>
  47.                 <port>9000</port>
  48.             </replica>
  49.             <replica>
  50.                 <host>ck1</host>
  51.                 <port>9000</port>
  52.             </replica>
  53.         </shard>
  54.     </ck_cluster>
  55. </remote_servers>

删除以上两个配置信息，新增以下内容

  1. <remote_servers incl="clickhouse_remote_servers" />
  2. <zookeeper incl="zookeeper-servers" optional="true" />
  4. <include_from>/etc/clickhouse-server/ck-cluster.xml</include_from>
  • remote_servers 标志我们在外部文件中引用的集群配置节点是clickhouse_remote_servers
  • zookeeper 标志我们在外部文件引用的ZK集群配置节点是zookeeper-servers
  • include_from 标志我们引用的外部配置文件，指定文件的绝对路径

新建集群配置文件

刚刚我们指定了/etc/clickhouse-server/ck-cluster.xml配置文件，此时我们需要去对该文件做配置

  • 创建新的配置文件
  1. touch /etc/clickhouse-server/ck-cluster.xml

在新的配置文件中增加zookeeper和clickhouse集群信息

  1. <yandex>
  2.     <zookeeper-servers>
  3.         <node index="1">
  4.             <host>zk1</host>
  5.             <port>2181</port>
  6.         </node>
  7.         <node index="2">
  8.             <host>zk2</host>
  9.             <port>2181</port>
  10.         </node>
  11.         <node index="3">
  12.             <host>zk3</host>
  13.             <port>2181</port>
  14.         </node>
  15.     </zookeeper-servers>
  17.     <clickhouse_remote_servers>
  18.         <ck_cluster>
  19.             <shard_1>
  20.                 <weight>1</weight>
  21.                 <internal_replication>true</internal_replication>
  22.                 <replica>
  23.                     <host>ck1</host>
  24.                     <port>9000</port>
  25.                 </replica>
  26.                 <replica>
  27.                     <host>ck2</host>
  28.                     <port>9000</port>
  29.                 </replica>
  30.             </shard_1>
  31.             <shard_2>
  32.                 <weight>1</weight>
  33.                 <internal_replication>true</internal_replication>
  34.                 <replica>
  35.                     <host>ck2</host>
  36.                     <port>9000</port>
  37.                 </replica>
  38.                 <replica>
  39.                     <host>ck3</host>
  40.                     <port>9000</port>
  41.                 </replica>
  42.             </shard_2>
  43.             <shard_3>
  44.                 <weight>1</weight>
  45.                 <internal_replication>true</internal_replication>
  46.                 <replica>
  47.                     <host>ck3</host>
  48.                     <port>9000</port>
  49.                 </replica>
  50.                 <replica>
  51.                     <host>ck1</host>
  52.                     <port>9000</port>
  53.                 </replica>
  54.             </shard_3>
  55.         </ck_cluster>
  56.     </clickhouse_remote_servers> 
  58.     <networks>
  59.         <ip>::/0</ip>
  60.     </networks>
  61. </yandex>

此处需要注意的是在yandex中配置的相关节点一定到和config.xml中的<remote_servers incl="clickhouse_remote_servers" /> <zookeeper incl="zookeeper-servers" optional="true" />这两个属性的incl一致，否则会扫描不到集群标志

修改配置后我们不需要重启服务，ClickHouse会自动加载修改后的配置信息

我们配置多个集群使用多个配置文件即可，多个replica节点配置多个也是可以的