安装前准备**：**

    安装依赖 yum install -y libtool
    yum install -y unixODBC

    关闭安全系统
    /etc/selinux/config
    设置
    SELINUXTYPE=disabled

    CentOs取消文件限制（默认一次只能打开1024个文件）
    在 /etc/security/limits.conf 、/etc/security/limits.d/20-nproc.conf后面添加

    soft nofile 65536
     hard nofile 65536
    soft nproc 131072
     hard nproc 131072

    重启生效
    ulimit -n 查看文件限制

    下载安装clickhouse
    下载地址
    https://packagecloud.io/Altinity/clickhouse

    下载 server-common、server、static-common 、client
    image.png

    rpm -ivh *.rpm //安装
    启动service clickhouse start

    vim /etc/clickhouse-server/config.xml 配置clickhouse-server可以被远程访问
    ::
    image.png

    分布式集群安装
    按照以上步骤将clickhouse安装到三台服务器上（因为我是在虚拟机上操作，所以只是克隆了两个虚拟机）

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

    vim /etc/metrika.xml
    添加如下内容：

    1. <yandex>
    2. <clickhouse_remote_servers>
    3.     <clickhouse_nodes>
    4.         <shard>
    5.              <internal_replication>true</internal_replication>
    6.             <replica>
    7.                 <host>vm01</host>
    8.                 <port>9000</port>
    9.             </replica>
    10.         </shard>
    11.         <shard>
    12.             <replica>
    13.                 <internal_replication>true</internal_replication>
    14.                 <host>vm02</host>
    15.                 <port>9000</port>
    16.             </replica>
    17.         </shard>
    18.         <shard>
    19.             <internal_replication>true</internal_replication>
    20.             <replica>
    21.                 <host>vm03</host>
    22.                 <port>9000</port>
    23.             </replica>
    24.         </shard>
    25.     </clickhouse_nodes>
    26. </clickhouse_remote_servers>
    27. <zookeeper-servers>
    28.   <node index="1">
    29.     <host>vm01</host>
    30.     <port>2181</port>
    31.   </node>
    32.   <node index="2">
    33.     <host>vm02</host>
    34.     <port>2181</port>
    35.   </node>
    36.   <node index="3">
    37.     <host>vm03</host>
    38.     <port>2181</port>
    39.   </node>
    40. </zookeeper-servers>
    41. <macros>
    42.     <replica>vm02</replica>
    43. </macros>
    44. <networks>
    45.    <ip>::/0</ip>
    46. </networks>
    47. <clickhouse_compression>
    48. <case>
    49.   <min_part_size>10000000000</min_part_size>
    51.   <min_part_size_ratio>0.01</min_part_size_ratio>                                                                                                                                       
    52.   <method>lz4</method>
    53. </case>
    54. </clickhouse_compression>
    55. </yandex>

    注意：

    1. <macros>
    2.     <replica>vm01</replica>
    3. </macros>

    不同机器这里不能相同

    三台机器启动ClickServer

    1. service clickhouse-server start