clickhouse分布式安装

安装zookeeper

我用的zookeeper-3.4.13.tar.gz

下载地址：https://archive.apache.org/dist/zookeeper/zookeeper-3.4.13/

分别部署在三台机器上

修改/etc/hostst 添加

192.168.0.101 node1
192.168.0.102 node2
192.168.0.103 node3

在zookeeper-3.4.13/conf/zoo.cfg 配置文件中加入

server.1=node1:2888:3888
server.2=node2:2888:3888
server.3=node3:2888:3888

启动三台 zookeeper-3.4.13/bin/zkServer.sh start

zookeeper-3.4.13/bin/zkServer.sh status 查询状态其中一台leader 两台状态为follower

安装clickhouse

我是用的版本为clickhouse-server-20.8.3.18 

编辑/etc/metrika.xml

<yandex>
    <clickhouse_remote_servers>
        <clickhouse1>
            <shard>
                <replica>
                    <host>node1</host>
                    <port>9000</port>
                </replica>
                <replica>
                    <host>node2</host>
                    <port>9000</port>
                </replica>
                <replica>
                    <host>node3</host>
                    <port>9000</port>
                </replica>

            </shard>
        </clickhouse1>
    </clickhouse_remote_servers>

    <zookeeper-servers>
        <node index="1">
            <host>node1</host>
            <port>2181</port>
        </node>
        <node index="2">
            <host>node2</host>
            <port>2181</port>
        </node>
        <node index="3">
            <host>node3</host>
            <port>2181</port>
        </node>
    </zookeeper-servers>
    <macros>
        <replica>01</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>

编辑/etc/clickhouse-server/config.xml 打开注释cli

<listen_host>::</listen_host>

使用clickhouse-client 进入数据库查看可以显示集群信息

select * from system.clusters;

测试建表是否可以成功

create table if not exists t_cst on cluster clickhouse1 (id UInt8)engine =Memory();