Clickhouse连接多zookeeper集群

1.配置:
在clickhouse配置文件config.xml中设置zookeeper/HouseKeeper多集群地址

<zookeeper>
    <node>
        <host>example1</host>
        <port>2181</port>
    </node>
    <node>
        <host>example2</host>
        <port>2181</port>
    </node>
    <node>
        <host>example3</host>
        <port>2181</port>
    </node>
</zookeeper>
<auxiliary_zookeepers>
    <zookeeper2>
        <node>
            <host>example_2_1</host>
            <port>2181</port>
        </node>
        <node>
            <host>example_2_2</host>
            <port>2181</port>
        </node>
        <node>
            <host>example_2_3</host>
            <port>2181</port>
        </node>
    </zookeeper2>
    <zookeeper3>
        <node>
            <host>example_3_1</host>
            <port>2181</port>
        </node>
    </zookeeper3>
</auxiliary_zookeepers>

2.使用:
为了将表元数据存储在辅助ZooKeeper集群中，而不是默认的ZooKeeper集群中，我们可以使用SQL使用ReplicatedMergeTree引擎创建表

示例:
CREATE TABLE table_name( … )
ENGINE=ReplicatedMergeTree(‘zookeeper2:/clickhouse/tables/{uuid}/{shard}’, ‘{replica}’)