坏境: linux centos6.5
机器:node01,node02,node03 共三台
ClickHouse版本: 21.9.6
1.系统要求
ClickHouse可以在任何具有x86_64,AArch64或PowerPC64LE CPU架构的Linux,FreeBSD或Mac OS X上运行。
官方预构建的二进制文件通常针对x86_64进行编译,并利用SSE 4.2
指令集,因此,除非另有说明,支持它的CPU使用将成为额外的系统需求。下面是检查当前CPU是否支持SSE 4.2的命令:
检测命令:
> grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"
如图所示:此系统支持
1.下载安装包
安装包列表:
clickhouse-common-static
— ClickHouse编译的二进制文件。clickhouse-server
— 创建clickhouse-server
软连接,并安装默认配置服务clickhouse-client
— 创建clickhouse-client
客户端工具软连接,并安装客户端配置文件。clickhouse-common-static-dbg
— 带有调试信息的ClickHouse二进制文件
Clickhouse安装包https://packages.clickhouse.com/tgz/stable/tgz安装包安装
1.wget下载
> wget https://packages.clickhouse.com/tgz/stable/clickhouse-common-static-22.2.3.5.tgz
> wget https://packages.clickhouse.com/tgz/stable/clickhouse-common-static-dbg-22.2.3.5.tgz
> wget https://packages.clickhouse.com/tgz/stable/clickhouse-server-22.2.3.5.tgz
> wget https://packages.clickhouse.com/tgz/stable/clickhouse-client-22.2.3.5.tgz
2解压安装:
> tar -zxvf clickhouse-common-static-22.2.3.5.tgz
> tar -zxvf clickhouse-common-static-dbg-22.2.3.5.tgz
> tar -zxvf clickhouse-server-22.2.3.5.tgz
> tar -zxvf clickhouse-client-22.2.3.5.tgz
配置:
clickhouse-common-static-21.9.4.35
clickhouse-server-22.2.3.5/etc/clickhouse-server/config.xml
修改点:
打开远程访问注释listen_host
<listen_host>::</listen_host>
配置分片和副本:
remote_servers>
<!-- 配置3分片2副本集群 -->
<cluster_three_shard_two_replicas_jyong> <!--集群名称 自定义-->
<shard>
<weight>1</weight>
<internal_replication>true</internal_replication>
<replica>
<host>node01</host>
<port>9000</port>
</replica>
<replica>
<host>node02</host>
<port>9000</port>
</replica>
</shard>
<shard>
<weight>1</weight>
<internal_replication>true</internal_replication>
<replica>
<host>node01</host>
<port>9001</port>
</replica>
<replica>
<host>node03</host>
<port>9000</port>
</replica>
</shard>
<shard>
<weight>1</weight>
<internal_replication>true</internal_replication>
<replica>
<host>node02</host>
<port>9001</port>
</replica>
<replica>
<host>node03</host>
<port>9001</port>
</replica>
</shard>
</cluster_three_shard_two_replicas_jyong>
</remote_servers>
配置zookeeper:
<!--配置zk-->
<zookeeper>
<node>
<host>node01</host>
<port>2181</port>
</node>
<node>
<host>node02</host>
<port>2181</port>
</node>
<node>
<host>node03</host>
<port>2181</port>
</node>
</zookeeper>
配置实例:
<!--定义该clickhouse实例存放什么-->
<macros>
<shard>01</shard>
<replica>cluster_three_shard_two_replicas_jyong-01-1</replica>
</macros>
clickhouse-server-22.2.3.5/etc/clickhouse-server/user.xml
此配置里可进行用户自定义配置
用户名、密码发等
分发
将每个部署包进行分发到每台机器
启动:
1.启动每个安装包install/doinst.sh 下的启动脚本
2.启动clickhouse-server服务
>service clickhouse-server start
浏览器访问:8123端口 ,返回ok则搭建成功