ClickHouse安装

安装前的准备

CentOS取消打开文件数限制

在/etc/security/limits.conf、/etc/security/limits.d/90-nproc.conf这2个文件的末尾加入一下内容：

[root@software]# vim /etc/security/limits.conf
在文件末尾添加：
* soft nofile 65536 
* hard nofile 65536 
* soft nproc 131072 
* hard nproc 131072

[root@software]# vim /etc/security/limits.d/90-nproc.conf(ps:你机器的文件名可能和我的不一样,比如20-nproc.conf)
在文件末尾添加：
 * soft nofile 65536 
 * hard nofile 65536 
 * soft nproc 131072 
 * hard nproc 131072

重启服务器之后生效，用ulimit -n 或者ulimit -a查看设置结果

[root@~]# ulimit -n
65536

CentOS取消SELINUX

修改/etc/selinux/config中的SELINUX=disabled后重启

[root@~]# vim /etc/selinux/config
SELINUX=disabled

关闭防火墙

[root@~]# service iptables stop 
[root@~]# service ip6tables stop
ip6tables：将 chains 设置为 ACCEPT 策略：filter            [确定]
ip6tables：清除防火墙规则：                                [确定]
：正在卸载模块：                   

安装依赖

[root@~]# yum install -y libtool
[root@~]# yum install -y *unixODBC*

安装

官网

https://clickhouse.yandex/

下载地址

http://repo.red-soft.biz/repos/clickhouse/stable/el7/
或者我的百度网盘提供:链接：https://pan.baidu.com/s/1WhgGLbRqndL5GcVkwKAeNg
提取码：m2mc

yum安装

系统要求
如果从官方仓库安装，需要确保您使用的是x86_64处理器构架的Linux并且支持SSE 4.2指令集
检查是否支持SSE 4.2：
grep -q sse4_2 /proc/cpuinfo && echo “SSE 4.2 supported” || echo “SSE 4.2 not supported”
#使用脚本安装yum源
curl -s https://packagecloud.io/install/repositories/altinity/clickhouse/script.rpm.sh | sudo bash
#yum 安装 server 以及 client
sudo yum install -y clickhouse-server clickhouse-client
#查看是否安装完成
sudo yum list installed ‘clickhouse*’
#开机启动clickhouse-server
systemctl enable clickhouse-server
#启动clickhouse-client
systemctl start clickhouse-client

单机模式

上传5个文件到/opt/software/(或者你的安装目录)

[root@software]# ls
clickhouse-client-1.1.54236-4.el7.x86_64.rpm      
clickhouse-server-1.1.54236-4.el7.x86_64.rpm
clickhouse-compressor-1.1.54236-4.el7.x86_64.rpm  
clickhouse-server-common-1.1.54236-4.el7.x86_64.rpm
clickhouse-debuginfo-1.1.54236-4.el7.x86_64.rpm

分别安装这5个rpm文件

[root@software]# rpm -ivh *.rpm
Preparing...                ########################################### [100%]
   1:clickhouse-server-commo########################################### [ 20%]
   2:clickhouse-server      ########################################### [ 40%]
   3:clickhouse-client      ########################################### [ 60%]
   4:clickhouse-debuginfo   ########################################### [ 80%]
   5:clickhouse-compressor  ########################################### [100%]

安装后如果再本目录找不到,表数据的存放位置可以去:/var/lib/clickhouse找 sh命令可以在/usr/bin下去找 配置文件去:/etc/clickhouse-server下去找

启动ClickServer

前台启动：

[root@software]# clickhouse-server --config-file=/etc/clickhouse-server/config.xml

后台启动：

[root@software]# nohup clickhouse-server --config-file=/etc/clickhouse-server/config.xml  >null 2>&1 &
[1] 2696

使用client连接server

[root@software]# clickhouse-client 
ClickHouse client version 1.1.54236.
Connecting to localhost:9000.
Connected to ClickHouse server version 1.1.54236.
:)

分布式集群安装

在其他机器(需要安装的机器)上面执行之前的所有步骤

三台机器修改配置文件config.xml

[root@master~]# vim /etc/clickhouse-server/config.xml

<listen_host>::</listen_host>
<!-- <listen_host>::1</listen_host> -->
<!-- <listen_host>127.0.0.1</listen_host> -->

[root@slave1~]# vim /etc/clickhouse-server/config.xml

<listen_host>::</listen_host>
<!-- <listen_host>::1</listen_host> -->
<!-- <listen_host>127.0.0.1</listen_host> -->

[root@slave2~]# vim /etc/clickhouse-server/config.xml
<listen_host>::</listen_host>
<!-- <listen_host>::1</listen_host> -->
<!-- <listen_host>127.0.0.1</listen_host> -->

在三台机器的etc目录下新建metrika.xml文件

[root@master ~]# vim /etc/metrika.xml
添加如下内容：
<yandex>
<clickhouse_remote_servers>
    <perftest_3shards_1replicas>
        <shard>
             <internal_replication>true</internal_replication>
            <replica>
                <host>master</host>
                <port>9000</port>
            </replica>
        </shard>
        <shard>
            <replica>
                <internal_replication>true</internal_replication>
                <host>slave1</host>
                <port>9000</port>
            </replica>
        </shard>
        <shard>
            <internal_replication>true</internal_replication>
            <replica>
                <host>slave2</host>
                <port>9000</port>
            </replica>
        </shard>
    </perftest_3shards_1replicas>
</clickhouse_remote_servers>


<zookeeper-servers>
  <node index="1">
    <host>master</host>
    <port>2181</port>
  </node>

  <node index="2">
    <host>slave1</host>
    <port>2181</port>
  </node>
  <node index="3">
    <host>slave2</host>
    <port>2181</port>
  </node>
</zookeeper-servers>

<macros>
    <replica>master</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>

三台机器启动ClickServer

首先在三台机器开启Zookeeper
前台启动：
[root@master software]# clickhouse-server --config-file=/etc/clickhouse-server/config.xml
后台启动：
[root@master software]# nohup clickhouse-server --config-file=/etc/clickhouse-server/config.xml >null 2>&1 &
[1] 2696