Clickhouse keeper方式搭建集群（不再依赖zookeeper）

wyl15982038375

已于 2024-06-27 10:07:58 修改

阅读量3.1k

点赞数 5

CC 4.0 BY-SA版权

文章标签： clickhouse zookeeper 分布式

于 2024-06-26 22:08:07 首次发布

本文链接：https://blog.csdn.net/wyl15982038375/article/details/139999634

下面是如何在三个节点（192.168.250.140, 192.168.250.146, 192.168.250.147）上部署 ClickHouse 集群，并使用 ClickHouse Keeper 作为分布式协调服务的详细步骤。

Step 1: 安装 ClickHouse

首先，在每个节点上安装 ClickHouse。以下命令适用于 Debian 系统。

wget -O clickhouse-client_24.4.3.25_amd64.deb https://github.com/ClickHouse/ClickHouse/releases/download/v24.4.3.25-stable/clickhouse-client_24.4.3.25_amd64.deb
wget -O clickhouse-common-static_24.4.3.25_amd64.deb https://github.com/ClickHouse/ClickHouse/releases/download/v24.4.3.25-stable/clickhouse-common-static_24.4.3.25_amd64.deb
wget -O clickhouse-server_24.4.3.25_amd64.deb https://github.com/ClickHouse/ClickHouse/releases/download/v24.4.3.25-stable/clickhouse-server_24.4.3.25_amd64.deb


sudo dpkg -i clickhouse-common-static_24.4.3.25_amd64.deb
sudo dpkg -i clickhouse-client_24.4.3.25_amd64.deb
sudo dpkg -i clickhouse-server_24.4.3.25_amd64.deb
dpkg -l | grep clickhouse  --是否安装成功

Step 2: 配置 ClickHouse Keeper

在每个节点上配置 ClickHouse Keeper。编辑 /etc/clickhouse-server/config.xml 文件，添加 ClickHouse Keeper 的配置。

在每个节点上，添加以下配置：

<clickhouse>
      <keeper_server>
        <tcp_port>9181</tcp_port>
        <server_id>1</server_id>
        <log_storage_path>/var/lib/clickhouse/coordination/log</log_storage_path>
        <snapshot_storage_path>/var/lib/clickhouse/coordination/snapshots</snapshot_storage_path>
        <coordination_settings>
            <operation_timeout_ms>10000</operation_timeout_ms>
            <session_timeout_ms>30000</session_timeout_ms>
            <raft_logs_level&g