1.环境信息:
[root@bigdata003 clickhouse-server]# cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)
2. 在/etc/hosts中添加主机信息
10.29.35.240 bigdataxxx3
10.29.35.241 bigdataxxx4
10.29.35.243 bigdataxxx5
3.关闭防火墙和selinux
4. 修改linux文件限制参数
5. 安装和删除clickhouse-server
yum -y install yum-utils
rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/stable/x86_64
yum -y install clickhouse-server clickhouse-client
yum -y remove clickhouse-server clickhouse-client
注意:在remove时,需要到/etc/clickhouse-server目录,把相关的内容全部删除干净,然后才能重新安装
cd /etc/clickhouse-server
rm -rf *
5.验证zookeeper的状态,和CDH集群共用zookeeper
配置文件: /opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/etc/zookeeper/conf.dist/zoo.cfg
/opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/lib/zookeeper/bin/zkCli.sh
用如下命令,无法正常获取zookeeper的状态信息
#/opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/lib/zookeeper/bin/zkServer.sh status
JMX enabled by default
Using config: /opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/lib/zookeeper/bin/../conf/zoo.cfg
Error contacting service. It is probably not running
6. 配置集群信息, metrika.xml文件内容如下:
(1) 由于9000端口被CDH占用,所以临时修改为9006,在使用clickhouse-client登录时,需要使用clickhouse --port 9006
注意:此配置文件,是没有副本的。
<yandex>
<clickhouse_remote_servers>
<perftest_3shards_1replicas>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>bigdata003</host>
<port>9006</port>
</replica>
</shard>
<shard>
<replica>
<internal_replication>true</internal_replication>
<host>bigdata004</host>
<port>9006</port>
</replica>
</shard>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>bigdata005</host>
<port>9006</port>
</replica>
</shard>
</perftest_3shards_1replicas>
</clickhouse_remote_servers>
<zookeeper-servers>
<node index="1">
<host>bigdata003</host>
<port>2181</port>
</node>
<node index="2">
<host>bigdata004</host>
<port>2181</port>
</node>
<node index="3">
<host>bigdata005</host>
<port>2181</port>
</node>
</zookeeper-servers>
#不同服务器,replica需要修改为不同的hostname
<macros>
<replica>bigdata003</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>
7. 修改配置文件信息
vi /etc/clickhouse-server/config.xml
(1) 修改绑定端口
<tcp_port>9006</tcp_port>
(2) 修改IPv4, IPv6访问权限
<listen_host>::</listen_host>
找到<listen_host>::</listen_host>的配置项,取消注释,这样就同时支持IPv4和IPv6了。
也可以选择取消注释<listen_host>0.0.0.0</listen_host>,就仅支持IPv4,不允许IPv6。