ClickHouse集群配置

最新推荐文章于 2025-05-24 08:20:54 发布

Yanko24

最新推荐文章于 2025-05-24 08:20:54 发布

阅读量1.4k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： OLAP和OLTP工具文章标签： ClickHouse

本文链接：https://blog.youkuaiyun.com/weixin_43495317/article/details/116918816

OLAP和OLTP工具专栏收录该内容

1 篇文章

订阅专栏

本文详细介绍了ClickHouse集群的不同配置方案，包括3分片2副本和2分片1副本的具体设置，以及如何根据节点数量调整配置。对于每种配置都提供了XML示例，并解释了在特定条件下使用macros标签的必要性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ClickHouse集群配置

（基于ClickHouse版本21.4.6.55）

1. ClickHouse集群（3分片2副本配置）

<?xml version="1.0"?>
<yandex>
	<remote_servers>
		<shards3_replications2>
			<shard>
				<internal_replication>true</internal_replication>
				<replica>
					<host>hadoop01</host>
					<port>9000</port>
				</replica>
				<replica>
					<host>hadoop02</host>
					<port>9000</port>
				</replica>
			</shard>
			<shard>
				<internal_replication>true</internal_replication>
				<replica>
					<host>hadoop03</host>
					<port>9000</port>
				</replica>
				<replica>
					<host>hadoop04</host>
					<port>9000</port>
				</replica>
			</shard>
            <shard>
				<internal_replication>true</internal_replication>
				<replica>
					<host>hadoop05</host>
					<port>9000</port>
				</replica>
				<replica>
					<host>hadoop06</host>
					<port>9000</port>
				</replica>
			</shard>
		</shards3_replications2>
	</remote_servers>
	
	<zookeeper>
		<node index="1">
			<host>hadoop01</host>
			<port>2181</port>
		</node>
		<node index="2">
			<host>hadoop02</host>
			<port>2181</port>
		</node>
		<node index="3">
			<host>hadoop03</host>
			<port>2181</port>
		</node>
	</zookeeper>
</yandex>

共6个节点，3个分片，每个分片2个副本。由于分片数一样，每个分片的副本数也一样，所以不需要配置macros标签。

2. ClickHouse集群（2分片1副本配置）

<?xml version="1.0"?>
<yandex>
	<remote_servers>
		<shards2_replications1>
			<shard>
				<internal_replication>true</internal_replication>
				<replica>
					<host>hadoop01</host>
					<port>9000</port>
				</replica>
				<replica>
					<host>hadoop02</host>
					<port>9000</port>
				</replica>
			</shard>
			<shard>
				<internal_replication>true</internal_replication>
				<replica>
					<host>hadoop03</host>
					<port>9000</port>
				</replica>
			</shard>
		</shards2_replications1>
	</remote_servers>
	
	<zookeeper>
		<node index="1">
			<host>hadoop01</host>
			<port>2181</port>
		</node>
		<node index="2">
			<host>hadoop02</host>
			<port>2181</port>
		</node>
		<node index="3">
			<host>hadoop03</host>
			<port>2181</port>
		</node>
	</zookeeper>
	
	<macros>
		<shard>01</shard>
		<replica>rep_1_1</replica>
	</macros>
</yandex>