ClickHouse分布式集群部署
前提:首先每个集群上搭建zookeeper集群。然后每个集群上都部署ClickHouse集群部署:每个集群上都新建一个文件:/etc/metrika.xmltouch /etc/metrika.xml<?xml version="1.0" encoding="utf-8"?><yandex><clickhouse_remote_servers><perft
·
前提:
首先每个集群上搭建zookeeper集群。
然后每个集群上都部署ClickHouse
集群部署:
每个集群上都新建一个文件:/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;
魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。
更多推荐
https://blog.csdn.net/weixin_38959210/article/details/97800533
所有评论(0)