Clickhouse -- 安装部署和测试

安装前的准备

1. CentOS取消打开文件数限制

#在/etc/security/limits.conf、/etc/security/limits.d/90-nproc.conf这2个文件的末尾加入一下内容：
* soft nofile 65536 
* hard nofile 65536 
* soft nproc 131072 
* hard nproc 131072

2. CentOS取消SELINUX，修改/etc/selinux/config中的SELINUX=disabled后重启
3. 关闭防火墙
4. 安装依赖

sudo yum install yum-utils libtool *unixODBC*
sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/stable/x86_64

安装

单机模式

1. 直接yum安装即可

sudo yum install clickhouse-server clickhouse-client

集群模式

1. 在每台机器yum安装

sudo yum install clickhouse-server clickhouse-client

2. 每台机器修改配置文件config.xml，注意：macros需要根据机器不同去修改

vim /etc/clickhouse-server/config.xml

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

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

vim /etc/metrika.xml
添加如下内容：
<yandex>
<clickhouse_remote_servers>
    <perftest_2shards_1replicas>
        <shard>
             <internal_replication>true</internal_replication>
            <replica>
                <host>xxx1</host>
                <port>9000</port>
            </replica>
        </shard>
        <shard>
            <replica>
                <internal_replication>true</internal_replication>
                <host>xxx2</host>
                <port>9000</port>
            </replica>
        </shard>
    </perftest_2shards_1replicas>
</clickhouse_remote_servers>


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

  <node index="2">
    <host>xxx2</host>
    <port>2181</port>
  </node>
  <node index="3">
    <host>xxx3</host>
    <port>2181</port>
  </node>
</zookeeper-servers>

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

修改配置

vim /etc/clickhouse-server/config.xml

# 修改各种path：
<path>/data/clickhouse/</path>
<tmp_path>/data/clickhouse/tmp/</tmp_path>
<user_files_path>/data/clickhouse/user_files/</user_files_path>
<format_schema_path>/data/clickhouse/format_schemas/</format_schema_path>

启动

1. 前台启动：

clickhouse-server --config-file=/etc/clickhouse-server/config.xml

2. 后台启动：

nohup clickhouse-server --config-file=/etc/clickhouse-server/config.xml > /dev/null 2>&1 &

使用client连接server

clickhouse-client

测试结果