一、 安装
每台机器上按照单节点模式安装,按照官网步骤安装:

sudo yum install yum-utils
sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/clickhouse.repo
sudo yum install clickhouse-server clickhouse-client

sudo /etc/init.d/clickhouse-server start
clickhouse-client

二、 配置
在每台机器上添加配置文件/etc/metrika.xml

<yandex>
    <!-- /etc/clickhouse-server/config.xml 中配置的remote_servers的incl属性值,-->
    <clickhouse_remote_servers>
    <!-- 3分片2备份 -->
        <perftest_3shards_2replicas>
        <!-- 数据分片1  -->
            <shard>
                <internal_replication>true</internal_replication>
                <replica>
                    <host>master</host>
                    <port>9000</port>
                </replica>
            </shard>
            <!-- 数据分片2  -->
            <shard>
                <replica>
                    <internal_replication>true</internal_replication>
                    <host>salve1</host>
                    <port>9000</port>
                </replica>
            </shard>
            <!-- 数据分片3  -->
            <shard>
                <internal_replication>true</internal_replication>
                <replica>
                    <host>salve2</host>
                    <port>9000</port>
                </replica>
            </shard>
             <!-- 数据分片4  -->
            <shard>
                <replica>
                    <host>master</host>
                    <port>9000</port>
                </replica>
            </shard>
             <!-- 数据分片5  -->
            <shard>
                <replica>
                    <host>salve1</host>
                    <port>9000</port>
                </replica>
            </shard>
        </perftest_3shards_2replicas>
    </clickhouse_remote_servers>
    <!--zookeeper相关配置-->
    <zookeeper-servers>
        <node index="1">
            <host>master</host>
            <port>2181</port>
        </node>
        <node index="2">
            <host>salve1</host>
            <port>2181</port>
        </node>
        <node index="3">
            <host>salve2</host>
            <port>2181</port>
        </node>
    </zookeeper-servers>
    
    <macros>
        <replica>master</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-server
先启动zookeeper集群

 sudo /etc/init.d/clickhouse-server start
 sudo /etc/init.d/clickhouse-server status

四、 任意一台机器上启动clickhouse-client,查看集群
如果在命令行中需要换行输入,需要加-m参数,clickhouse-client -m在这里插入图片描述

五、导入外部json数据(待续)
cat stu.json | clickhouse-client --query=“INSERT INTO jsontest.stu_new FORMAT JSONEachRow”

更多推荐