ClickHouse部署文档

坏境:  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则搭建成功