SS00001.olap——|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 │
└───────────────────────────────────┴───────────┴──────────────┴─────────────┴───────────┴───────────────┴──────┴──────────┴─────────┴──────────────────┴──────────────┴─────────────────────────┘