使用zookeeper设置clickhouse 3节点循环群集时,clickhouse副本/服务器无法相互连接

ki0zmccv  于 2021-07-15  发布在  ClickHouse
关注(0)|答案(2)|浏览(596)

没有将数据复制到每个clickhouse副本。在检查clickhouse服务器日志时,它显示
db::storagereplicatedmergetree::queuetask()::poco::异常。代码:1000,e.code()=0,e.displaytext()=找不到主机:ip-172-1-140-243(版本19.9.2.4)
我有3个不同的机器在每台机器上我都安装了clickhouse和zookeeper。我正在尝试使用zookeeper设置3节点clickhouse集群。我已经按照这些步骤进行了配置https://blog.uiza.io/replicated-and-distributed-on-clickhouse-part-2/ . 我已经在所有clickhouse示例上创建了表和副本,并在zookeeper中进行了验证。在zookeeper中为所有副本创建了目录。已经在所有示例上创建了/etc/metrica.xml、zoo.cfg、/etc/clickhouse server/config.xml。提供来自1个示例的所有3个文件
/etc/metrica.xml文件

<?xml version="1.0"?>
<yandex>
<clickhouse_remote_servers>
    <perftest_3shards_1replicas>
        <shard>
             <internal_replication>true</internal_replication>
            <replica>
                <default_database>dwh01</default_database>
                <host>172.1.34.199</host>
                <port>9000</port>
            </replica>
            <replica>
                <default_database>dwh01</default_database>
                <host>172.1.73.156</host>
                <port>9000</port>
            </replica>
        </shard>

         <shard>
             <internal_replication>true</internal_replication>
            <replica>
                <default_database>dwh02</default_database>
                <host>172.1.73.156</host>
                <port>9000</port>
            </replica>
            <replica>
                <default_database>dwh02</default_database>
                <host>172.1.140.243</host>
                <port>9000</port>
            </replica>
        </shard>

        <shard>
             <internal_replication>true</internal_replication>
            <replica>
                <default_database>dwh03</default_database>
                <host>172.1.140.243</host>
                <port>9000</port>
            </replica>
            <replica>
                <default_database>dwh03</default_database>
                <host>172.1.34.199</host>
                <port>9000</port>
            </replica>
        </shard>
    </perftest_3shards_1replicas>
</clickhouse_remote_servers>

<zookeeper-servers>
  <node index="1">
    <host>172.1.34.199</host>
    <port>2181</port>
  </node>
 <node index="2">
    <host>172.1.73.156</host>
    <port>2181</port>
  </node>
 <node index="3">
    <host>172.1.140.243</host>
    <port>2181</port>
  </node> 
</zookeeper-servers>

<macros replace="replace">
  <cluster>OLAPLab</cluster>
  <dwhshard00>01</dwhshard00>
  <dwhshard01>03</dwhshard01>
  <dwhreplica00>01</dwhreplica00>
  <dwhreplica01>02</dwhreplica01>
  <shard>01</shard>
  <replica>node1</replica>
</macros>
<interserver_http_host>ip-172-1-34-199</interserver_http_host>
</yandex>

/etc/clickhouse服务器/config.xml

Only added this line rest of the config is default config
<listen_host>::</listen_host>

/usr/lib/zookeeper/conf/zoo.cfg文件

maxClientCnxns=50

# The number of milliseconds of each tick

tickTime=2000

# The number of ticks that the initial

# synchronization phase can take

initLimit=10

# The number of ticks that can pass between

# sending a request and getting an acknowledgement

syncLimit=5

# the directory where the snapshot is stored.

dataDir=/var/lib/zookeeper

# the port at which the clients will connect

clientPort=2181

# the directory where the transaction logs are stored.

dataLogDir=/var/lib/zookeeper
server.1=172.1.34.199:2888:3888
server.2=172.1.73.156:2888:3888
server.3=172.1.140.243:2888:3888

/etc/主机

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost6 localhost6.localdomain6
127.0.0.1    ip-172-1-34-199
127.0.0.1    172.1.34.199

我应该更改什么来获取属于所有示例的所有副本中的复制数据

q5iwbnjs

q5iwbnjs1#

似乎需要将字符串添加到两个节点(172.1.34.199和172.1.73.156)的hosts文件中

172.1.140.243 ip-172-1-140-243
tzdcorbm

tzdcorbm2#

clickhouse和zookeeper端口在机器之间是否可以访问?
你能跑吗 wget http://172.1.140.243:9000 ? 这同样适用于zookeper端口。

相关问题