clickhouse

最新推荐文章于 2024-08-18 11:29:58 发布

xy908325

最新推荐文章于 2024-08-18 11:29:58 发布

阅读量1.4k

点赞数

本文链接：https://blog.csdn.net/xy908325/article/details/100560909

版权

本文提供了ClickHouse的下载地址，详细介绍了安装前的准备工作、RPM安装步骤以及如何启动服务。接着，文章讲解了配置3分片2备份的详细过程，包括分片配置规划、配置文件的拷贝和创建相关目录，特别提到了metrika.xml配置，并列举了多个节点的IP和端口号。最后，强调了需要修改的/etc/clickhouse-server/config.xml配置文件的部分。

摘要由CSDN通过智能技术生成

下载地址：https://repo.yandex.ru/clickhouse/rpm/stable/x86_64/

clickhouse-test-19.4.0-2.noarch.rpm
clickhouse-common-static-19.4.0-2.x86_64.rpm
clickhouse-common-static-dbg-19.4.0-2.x86_64.rpm
clickhouse-server-common-19.4.0-2.noarch.rpm
clickhouse-server-base-19.4.0-2.x86_64.rpm
clickhouse-server-19.4.0-2.noarch.rpm
clickhouse-client-19.4.0-2.noarch.rpm

安装前准备工作

mkdir /opt/clickhouse/
useradd clickhouse
mkdir /var/log/clickhouse-server/
chown clickhouse.clickhouse /var/log/clickhouse-server/ -R

rpm安装

rpm -ivh clickhouse-common-static-19.4.0-2.x86_64.rpm --force
rpm -ivh clickhouse-common-static-dbg-19.4.0-2.x86_64.rpm --force
rpm -ivh clickhouse-server-base-19.4.0-2.x86_64.rpm --force
rpm -ivh clickhouse-server-19.4.0-2.noarch.rpm --force
rpm -ivh clickhouse-server-common-19.4.0-2.noarch.rpm --force
rpm -ivh clickhouse-client-19.4.0-2.noarch.rpm --force

启动服务

/etc/init.d/clickhouse-server start

配置3分片2备份

分片配置规划

192.168.16.180 tcp 9000, http 8123,同步端口 9009,类型 分片1 副本1
192.168.16.180 tcp 9001, http 8124,同步端口 9010,类型 分片3 副本2
192.168.16.181 tcp 9000, http 8123,同步端口 9009,类型 分片2 副本1
192.168.16.181 tcp 9001, http 8124,同步端口 9010,类型 分片1 副本2
192.168.16.182 tcp 9000, http 8123,同步端口 9009,类型 分片3 副本1
192.168.16.182 tcp 9001, http 8124,同步端口 9010,类型 分片2 副本2

拷贝配置文件并创建相关目录

cp /etc/init.d/clickhouse-server /etc/init.d/clickhouse-server2
mkdir /var/lib/clickhouse/user_files2
mkdir /var/lib/clickhouse2
mkdir /var/lib/clickhouse2/tmp
chown clickhouse.clickhouse /var/lib/clickhouse2 -R
chown clickhouse.clickhouse /var/lib/clickhouse/user_files2 -R

对应metrika.xml配置

192.168.16.180 9000端口

<macros>
    <layer>01</layer>
    <shard>01</shard>
    <replica>cluster01-01-1</replica>
</macros>

192.168.16.180 9001端口

<macros>
    <layer>01</layer>
    <shard>03</shard>
    <replica>cluster01-03-2</replica>
</macros>

192.168.16.181 9000端口

<macros>
    <layer>01</layer>
    <shard>02</shard>
    <replica>cluster01-02-1</replica>
</macros>

192.168.16.181 9001端口

<macros>
    <layer>01</layer>
    <shard>01</shard>
    <replica>cluster01-01-2</replica>
</macros>

192.168.16.182 9000端口

<macros>
    <layer>01</layer>
    <shard>03</shard>
    <replica>cluster01-03-1</replica>
</macros>

192.168.16.182 9001端口

<macros>
    <layer>01</layer>
    <shard>02</shard>
    <replica>cluster01-02-2</replica>
</macros>

/etc/clickhouse-server/config.xml 配置文件修改（以192.168.16.180节点9001端口配置文件为例），** **中间是需修改部分

<?xml version="1.0"?>
<!--
  NOTE: User and query level settings are set up in "users.xml" file.
-->
<yandex>
    <logger>
        <!-- Possible levels: https://github.com/pocoproject/poco/blob/develop/Foundation/include/Poco/Logger.h#L105 -->
        <level>trace</level>
        <log>**/var/log/clickhouse-server/clickhouse-server2.log**</log>
        <errorlog>**/var/log/clickhouse-server/clickhouse-server2.err.log**</errorlog>
        <size>1000M</size>
        <count>10</count>
        <!-- <console>1</console> --> <!-- Default behavior is autodetection (log to console if not daemon mode and is tty) -->
    </logger>
    <!--display_name>production</display_name--> <!-- It is the name that will be shown in the client -->
    <http_port>**8124**</http_port>
    <tcp_port>**9001**</tcp_port>

    <!-- For HTTPS and SSL over native protocol. -->
    <!--
    <https_port>8443</https_port>
    <tcp_port_secure>9440</tcp_port_secure>
    -->

    <!-- Used with https_port and tcp_port_secure. Full ssl options list: https://github.com/ClickHouse-Extras/poco/blob/master/NetSSL_OpenSSL/include/Poco/Net/SSLManager.h#L71 -->
    <openSSL>
        <server> <!-- Used for https server AND secure tcp port -->
            <!-- openssl req -subj "/CN=localhost" -new -newkey rsa:2048 -days 365 -nodes -x509 -keyout /etc/clickhouse-server/s