离线安装clickhouse 集群部署

1、下载离线安装包：

Index of /clickhouse/rpm/stable/x86_64/

选择版本：21.9.7.2-2

2、离线安装包清单：

clickhouse-common-static-21.9.7.2-2.x86_64.rpm

clickhouse-server-21.9.7.2-2.noarch.rpm

clickhouse-client-21.9.7.2-2.noarch.rpm

（可选）clickhouse-test-21.9.7.2-2.noarch.rpm

（可选）clickhouse-common-static-dbg-21.9.7.2-2.x86_64.rpm

3、安装RPM包

rpm -ivh clickhouse-common-static

rpm -ivh clickhouse-server

rpm -ivh clickhouse-client

4、启动服务

systemctl start clickhouse-server.service

systemctl stop clickhouse-server.service

systemctl restart clickhouse-server

5、测试客户端

clickhouse-client -u default --password 123456

show databases;

6、修改密码

echo -n 123456 | openssl dgst -sha256

7、下载Zookeeper

https://dlcdn.apache.org/zookeeper/zookeeper-3.7.0/apache-zookeeper-3.7.0-bin.tar.gz

8、安装配置Zookeeper集群

zkServer.sh start

zkServer.sh stop

zkServer.sh status

9、修改CK数据存储目录/etc/clickhouse-server/config.xml，安装时生成的默认文件迁移

chown -Rc clickhouse:clickhouse /data/clickhouse

10、配置/etc/clickhouse-server/config.d/metrika.xml

11、配置/etc/clickhouse-server/config.xml

12、验证集群

clickhouse-client -u default --password 123456

select * from system.clusters;

select * from system.zookeeper where path = '/';