|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
 
    
    
    /var/lib/clickhouse/
 
    
    
    /etc/clickhouse-server/config.d/metrika.xml

### --- 在三台机器的/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

~~~添加如下内容：注意：标签中的内容对应自己的主机名

    
    
        
            
                true
                
                    hadoop01
                    9000
                
            
            
                
                    true
                    hadoop02
                    9000
                
            
            
                true
                
                    hadoop03
                    9000
                
            
        
    

    
    
        
            hadoop01
            2181
        
        
            hadoop02
            2181
        
        
            hadoop03
            2181
        
    

    
    
        01
        hadoop01
    

    
        ::/0
    

    
    
        
            10000000000
            0.01
            lz4

### --- 将配置文件发送到其它主机

~~~     # 发送到其它主机
[root@hadoop01 ~]# rsync-script /etc/clickhouse-server/config.d/metrika.xml

~~~     # 修改其它两台主机的副本存放地址

[root@hadoop02 ~]# vim /etc/clickhouse-server/config.d/metrika.xml 
    
    
        02
        hadoop02

[root@hadoop03 ~]# vim /etc/clickhouse-server/config.d/metrika.xml
    
    
    
        03
        hadoop03

四、启动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

|NO.Z.00001|——————————|Deployment|——|Hadoop&OLAP数据库管理系统.v01|——|ClickHouse.v01|单击模式|集群模式|

相关

标签