clickhouse集群版安装之高可用
发布于 8 天前 作者 mayday 96 次浏览 来自 问答

各位大神好,我按照文档装好了集群版的clickhouse,这是/etc/metrika.xml的配置文件: <yandex> <clickhouse_remote_servers> <perftest_3shards_1replicas> <shard> <internal_replication>true</internal_replication> <replica> <host>data1</host> <port>9000</port> </replica> </shard> <shard> <replica> <internal_replication>true</internal_replication> <host>data2</host> <port>9000</port> </replica> </shard> <shard> <internal_replication>true</internal_replication> <replica> <host>data3</host> <port>9000</port> </replica> </shard> </perftest_3shards_1replicas> </clickhouse_remote_servers>

<zookeeper-servers> <node index=“1”> <host>10.181.218.146</host> <port>2181</port> </node> </zookeeper-servers>

<macros> <replica>10.181.218.146</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> 我发现这个不是高可用的,仅仅是3个节点3个副本而已,我把其中一台停掉,从另一台查数据就查不到了。有人说高可用是另外一种配置,2个节点,2个副本,想问下大神们具体怎么配置呢? Received exception from server (version 1.1.54336): Code: 279. DB::Exception: Received from localhost:9000, ::1. DB::NetException. DB::NetException: All connection tries failed. Log:

Code: 32, e.displayText() = DB::Exception: Attempt to read after eof, e.what() = DB::Exception Code: 210, e.displayText() = DB::NetException: Connection refused: (data2:9000, 10.181.218.147), e.what() = DB::NetException Code: 210, e.displayText() = DB::NetException: Connection refused: (data2:9000, 10.181.218.147), e.what() = DB::NetException

1 回复

已解决,见http://www.clickhouse.com.cn/topic/5a366e97828d76d75ab5d5a0

回到顶部