clickhouse入门与安装

单机版安装

下载如下四个安装包

-rw-r--r--. 1 root root     76140 1月   8 16:47 clickhouse-client-20.5.2.7-2.noarch.rpm
-rw-r--r--. 1 root root 120798350 1月   8 16:47 clickhouse-common-static-20.5.2.7-2.x86_64.rpm
-rw-r--r--. 1 root root     98612 1月   8 16:47 clickhouse-server-20.5.2.7-2.noarch.rpm
-rw-r--r--. 1 root root   2178089 1月   8 16:47 clickhouse-test-20.5.2.7-2.noarch.rpm

进行安装

[root@mypc01 mysoft]# yum -y install /mysoft/clickhouse-*.rpm

修改配置文件,直接覆盖源文件

[root@mypc]# vim /etc/clickhouse-server/config.xml
<?xml version="1.0"?>
<yandex>
    <!-- 配置日志文件 -->
    <logger>
        <level>trace</level>
        <log>/data/clickhouse/logs/server.log</log>
        <errorlog>/data/clickhouse/logs/error.log</errorlog>
        <size>1000M</size>
        <count>10</count>
    </logger>
    
    <!--配置http、tcp端口和监听地址-->
    <http_port>8123</http_port>
    <tcp_port>9009</tcp_port>
    <interserver_http_port>9010</interserver_http_port>
    <listen_host>::</listen_host>

    <path>/data/clickhouse/clickhousedata/</path>
    <tmp_path>/data/clickhouse/tmp/</tmp_path>
    <users_config>users.xml</users_config>

    <default_profile>default</default_profile>
    <default_database>default</default_database>
    <remote_servers incl="clickhouse_remote_servers" />

    <zookeeper incl="zookeeper-servers" optional="true" />
    <macros incl="macros" optional="true" />
    <include_from>/etc/clickhouse-server/metrika.xml</include_from>
    
    <mark_cache_size>5368709120</mark_cache_size>
</yandex>

创建metrika.xml,其中ip替换为自己的ip

[root@node1 home]# vi /etc/clickhouse-server/metrika.xml
#覆盖如下内容即可

<yandex>

<clickhouse_remote_servers>
    <news_ck_cluster>
        <shard>
            <weight>1</weight>
            <internal_replication>false</internal_replication>
            <replica>
                <host>192.168.xx.111</host>
                <port>9009</port>
                <user>default</user>
                <password>123456</password>
            </replica>
        </shard>
    </news_ck_cluster>
</clickhouse_remote_servers>

<macros>
    <replica>192.168.xx.111</replica> <!--默认当前服务器ip即可-->
</macros>

<networks>
   <ip>::/0</ip>
</networks>

<zookeeper-servers>
    <node index="1">
        <host>192.168.xx.111</host>
        <port>2181</port>
    </node>
</zookeeper-servers>

<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>

修改/etc/clickhouse-server/users.xml

[root@node1 home]# mv /etc/clickhouse-server/users.xml /etc/clickhouse-server/users.xml_bak
[root@node1 home]# vi /etc/clickhouse-server/users.xml
#覆盖如下内容

<?xml version="1.0"?>
<yandex>
    <profiles>
        <!-- 读写用户设置  -->
        <default>
            <max_memory_usage>10000000000</max_memory_usage>
            <use_uncompressed_cache>0</use_uncompressed_cache>
            <load_balancing>random</load_balancing>
        </default>
        <!-- 只读用户设置  -->
        <readonly>
            <max_memory_usage>10000000000</max_memory_usage>
            <use_uncompressed_cache>0</use_uncompressed_cache>
            <load_balancing>random</load_balancing>
            <readonly>1</readonly>
        </readonly>
    </profiles>
    <!-- 配额  -->
    <quotas>
        <!-- Name of quota. -->
        <default>
            <interval>
                <duration>3600</duration>
                <queries>0</queries>
                <errors>0</errors>
                <result_rows>0</result_rows>
                <read_rows>0</read_rows>
                <execution_time>0</execution_time>
            </interval>
        </default>
    </quotas>
    <users>
        <!-- 读写用户  -->
        <default>
            <password_sha256_hex>8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92</password_sha256_hex>
            <networks incl="networks" replace="replace">
                <ip>::/0</ip>
            </networks>
            <profile>default</profile>
            <quota>default</quota>
        </default>
        <!-- 只读用户  -->
        <readonly>
            <password_sha256_hex>8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92</password_sha256_hex>
            <networks incl="networks" replace="replace">
                <ip>::/0</ip>
            </networks>
            <profile>readonly</profile>
            <quota>default</quota>
        </readonly>
    </users>
</yandex>

启动服务

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

客户端连接

 clickhouse-client \
--host=localhost \
--port=9009 \
--user=default \
--password=123456

总结