|NO.Z.00001|——————————|Deployment|——|Hadoop&OLAP数据库管理系统.v01|——|ClickHouse.v01|单击模式|集群模式|
一、ClickHouse下载
### --- 下载地址
~~~ 官网：https://clickhouse.yandex/
~~~ 下载地址：http://repo.red-soft.biz/repos/clickhouse/stable/el6/二、ClickHouse单击模式安装
### --- 单机模式：hadoop01
~~~ # 上传4个文件到/root/apps/software/clickhouse_rpm
[root@hadoop01 ~]# ll /opt/yanqi/software/clickhouse_rpm/
clickhouse-client-20.5.4.40-1.el7.x86_64.rpm
clickhouse-common-static-20.5.4.40-1.el7.x86_64.rpm
clickhouse-server-20.5.4.40-1.el7.x86_64.rpm
clickhouse-server-common-20.5.4.40-1.el7.x86_64.rpm### --- 分别安装这4个rpm文件
[root@hadoop01 ~]# cd /opt/yanqi/software/clickhouse_rpm/
[root@hadoop01 clickhouse_rpm]# rpm -ivh ./*.rpm
~~~输出参数
Preparing... ################################# [100%]
Updating / installing...
1:clickhouse-server-common-20.5.4.4################################# [ 25%]
2:clickhouse-common-static-20.5.4.4################################# [ 50%]
3:clickhouse-server-20.5.4.40-1.el7################################# [ 75%]
Create user clickhouse.clickhouse with datadir /var/lib/clickhouse
4:clickhouse-client-20.5.4.40-1.el7################################# [100%]
Create user clickhouse.clickhouse with datadir /var/lib/clickhouse~~~ # 默认安装路径
[root@hadoop01 ~]# ll /etc/clickhouse-
clickhouse-client/ clickhouse-server/### --- 启动ClickServer
~~~ # 前台启动：
[root@hadoop01 ~]# clickhouse clickhouse-server \
--config-file=/etc/clickhouse-server/config.xml~~~ # 后台启动：
[root@hadoop01 ~]# nohup clickhouse clickhouse-server \
--config-file=/etc/clickhouse-server/config.xml >null 2>&1 &
~~~ # OR
[root@hadoop01 ~]# systemctl start clickhouse-server### --- 使用client连接server
~~~ # 使用client连接server
[root@hadoop01 ~]# clickhouse-client -m
ClickHouse client version 20.5.4.40.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 20.5.4 revision 54435.
hadoop01 :)三、分布式集群安装
### --- 在hadoop02、hadoop03上面执行单机安装的所有步骤：修改配置文件config.xml
~~~ # 三台机器修改配置文件config.xml
[root@hadoop01 ~]# vim /etc/clickhouse-server/config.xml
<!-- 注意点：空间容量一定要大 -->
<!-- Path to data directory, with trailing slash. -->
<path>/var/lib/clickhouse/</path>
<!-- zookeeper标签上面增加：metrics.xml文件：自己创建 -->
<zookeeper incl="zookeeper-servers" optional="true" />
<include_from>/etc/clickhouse-server/config.d/metrika.xml</include_from>### --- 在三台机器的/etc/clickhouse-server/config.d目录下新建metrika.xml文件
[root@hadoop01 ~]# mkdir /etc/clickhouse-server/config.d
[root@hadoop01 ~]# vim /etc/clickhouse-server/config.d/metrika.xml
~~~添加如下内容：注意：标签中的内容对应自己的主机名
<yandex>
<!-- 修改remote-servers集群配置节点信息 -->
<clickhouse_remote_servers>
<perftest_3shards_1replicas>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>hadoop01</host>
<port>9000</port>
</replica>
</shard>
<shard>
<replica>
<internal_replication>true</internal_replication>
<host>hadoop02</host>
<port>9000</port>
</replica>
</shard>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>hadoop03</host>
<port>9000</port>
</replica>
</shard>
</perftest_3shards_1replicas>
</clickhouse_remote_servers>
<!--zookeeper集群配置信息 -->
<zookeeper-servers>
<node index="1">
<host>hadoop01</host>
<port>2181</port>
</node>
<node index="2">
<host>hadoop02</host>
<port>2181</port>
</node>
<node index="3">
<host>hadoop03</host>
<port>2181</port>
</node>
</zookeeper-servers>
<!--副本存放地址：不同主机配置不同副本号及主机名 -->
<macros>
<shard>01</shard>
<replica>hadoop01</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>### --- 将配置文件发送到其它主机
~~~ # 发送到其它主机
[root@hadoop01 ~]# rsync-script /etc/clickhouse-server/config.d/metrika.xml~~~ # 修改其它两台主机的副本存放地址
[root@hadoop02 ~]# vim /etc/clickhouse-server/config.d/metrika.xml
<!--副本存放地址：不同主机配置不同主机名 -->
<macros>
<shard>02</shard>
<replica>hadoop02</replica>
[root@hadoop03 ~]# vim /etc/clickhouse-server/config.d/metrika.xml
</macros>
<!--副本存放地址：不同主机配置不同主机名 -->
<macros>
<shard>03</shard>
<replica>hadoop03</replica>
</macros>四、启动ClickServer服务
### --- 启动zookeeper集群
~~~ # 启动zookeeper集群
[root@hadoop01 ~]# ./zk.sh start### --- 三台机器启动ClickServer：
~~~ 注意：此方式为clickhouse官方提供的启动方式另外也可以：
~~~ service clickhouse-server start或者systemctl start clickhouse-server方式启动几种方式首选官方提供的方式。
~~~ # 前台启动：所有主机
[root@hadoop01 ~]# clickhouse clickhouse-server \
--config-file=/etc/clickhouse-server/config.xml~~~ # 后台启动：所有主机
[root@hadoop01 ~]# nohup clickhouse clickhouse-server \
--config-file=/etc/clickhouse-server/config.xml >null 2>&1 &
~~~ # OR
[root@hadoop01 ~]# systemctl start clickhouse-server### --- 验证集群
~~~ 可以确定为ClickServer集群启动成功了：
~~~ 需要在三台主机上启动ClickServer启动并逐个验证
~~~ # 验证ClickServer集群是否启动成功
[root@hadoop01 ~]# clickhouse-client -m
hadoop01 :) select * from system.clusters;
┌─cluster───────────────────────────┬─shard_num─┬─shard_weight─┬─replica_num─┬─host_name─┬─host_address──┬─port─┬─is_local─┬─user────┬─default_database─┬─errors_count─┬─estimated_recovery_time─┐
│ perftest_3shards_1replicas │ 1 │ 1 │ 1 │ hadoop01 │ 192.168.1.121 │ 9000 │ 1 │ default │ │ 0 │ 0 │
│ perftest_3shards_1replicas │ 2 │ 1 │ 1 │ hadoop02 │ 192.168.1.122 │ 9000 │ 0 │ default │ │ 0 │ 0 │
│ perftest_3shards_1replicas │ 3 │ 1 │ 1 │ hadoop03 │ 192.168.1.123 │ 9000 │ 0 │ default │ │ 0 │ 0 │
└───────────────────────────────────┴───────────┴──────────────┴─────────────┴───────────┴───────────────┴──────┴──────────┴─────────┴──────────────────┴──────────────┴─────────────────────────┘Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of life.It sinks, and I am ready to depart
——W.S.Landor
分类:
dov005-olap
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· 全程不用写代码，我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了，比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15：你的「微服务管家」又秀新绝活了