ubuntu安装clickhouse

wget https://github.com/ClickHouse/ClickHouse/releases/download/v25.7.8.71-stable/clickhouse-server-25.7.8.71-amd64.tgz
tar zxvf clickhouse-server-25.7.8.71-amd64.tgz
clickhouse-server-25.7.8.71/install/doinst.sh
4、下载clickhouse-client包，然后解压运行脚本

wget https://github.com/ClickHouse/ClickHouse/releases/download/v25.7.8.71-stable/clickhouse-client-25.7.8.71-amd64.tgz
tar zxvf clickhouse-client-25.7.8.71-amd64.tgzclickhouse-client-25.7.8.71-amd64.tgz
clickhouse-client-25.7.8.71/install/doinst.sh

config1

<listen_host>0.0.0.0</listen_host>
<http_port>8123</http_port>
<tcp_port>9000</tcp_port>
/data/clickhouse/ch1/
<tmp_path>/data/clickhouse/ch1/tmp/</tmp_path>

<remote_servers>
    <cluster_3s>
        <shard><replica><host>127.0.0.1</host><port>9000</port></replica></shard>
        <shard><replica><host>127.0.0.1</host><port>9001</port></replica></shard>
        <shard><replica><host>127.0.0.1</host><port>9002</port></replica></shard>
    </cluster_3s>
</remote_servers>

<!-- 以下是修复缺失 profile 的关键配置 -->
<profiles>
    <default>
        <max_memory_usage>10000000000</max_memory_usage>
        <load_balancing>random</load_balancing>
    </default>
</profiles>

<users>
    <default>
        <password></password>
        <networks><ip>::/0</ip></networks>
        <profile>default</profile>
        <quota>default</quota>
    </default>
</users>

<quotas>
    <default>
        <interval>
            <duration>3600</duration>
            <queries>0</queries>
        </interval>
    </default>
</quotas>

config2 0.0.0.0 8124 9001 /data/clickhouse/ch2/ /data/clickhouse/ch2/tmp/

<remote_servers>
    <cluster_3s>
        <shard><replica><host>127.0.0.1</host><port>9000</port></replica></shard>
        <shard><replica><host>127.0.0.1</host><port>9001</port></replica></shard>
        <shard><replica><host>127.0.0.1</host><port>9002</port></replica></shard>
    </cluster_3s>
</remote_servers>

<profiles>
    <default>
        <max_memory_usage>10000000000</max_memory_usage>
        <load_balancing>random</load_balancing>
    </default>
</profiles>

<users>
    <default>
        <password></password>
        <networks><ip>::/0</ip></networks>
        <profile>default</profile>
        <quota>default</quota>
    </default>
</users>

<quotas>
    <default>
        <interval>
            <duration>3600</duration>
            <queries>0</queries>
        </interval>
    </default>
</quotas>

config3 0.0.0.0 8125 9002 /data/clickhouse/ch3/ /data/clickhouse/ch3/tmp/

<remote_servers>
    <cluster_3s>
        <shard><replica><host>127.0.0.1</host><port>9000</port></replica></shard>
        <shard><replica><host>127.0.0.1</host><port>9001</port></replica></shard>
        <shard><replica><host>127.0.0.1</host><port>9002</port></replica></shard>
    </cluster_3s>
</remote_servers>

<profiles>
    <default>
        <max_memory_usage>10000000000</max_memory_usage>
        <load_balancing>random</load_balancing>
    </default>
</profiles>

<users>
    <default>
        <password></password>
        <networks><ip>::/0</ip></networks>
        <profile>default</profile>
        <quota>default</quota>
    </default>
</users>

<quotas>
    <default>
        <interval>
            <duration>3600</duration>
            <queries>0</queries>
        </interval>
    </default>
</quotas>

users.xml 10000000000 0 random

<users>
    <default>
        <password></password>
        <networks>
            <ip>::/0</ip>
        </networks>
        <profile>default</profile>
        <quota>default</quota>
    </default>
</users>

<quotas>
    <default>
        <interval>
            <duration>3600</duration>
            <queries>0</queries>
            <errors>0</errors>
            <result_rows>0</result_rows>
            <read_rows>0</read_rows>
        </interval>
    </default>
</quotas>

mkdir -p /data/clickhouse/ch1/data /data/clickhouse/ch1/logs
mkdir -p /data/clickhouse/ch2/data /data/clickhouse/ch2/logs
mkdir -p /data/clickhouse/ch3/data /data/clickhouse/ch3/logs
chmod -R 777 /data/clickhouse
clickhouse-server --config-file=/etc/clickhouse-server/config-ch1.xml &
clickhouse-server --config-file=/etc/clickhouse-server/config-ch2.xml &
clickhouse-server --config-file=/etc/clickhouse-server/config-ch3.xml &

clickhouse-server --config-file=/etc/clickhouse-server/config-ch1.xml --daemon
clickhouse-server --config-file=/etc/clickhouse-server/config-ch2.xml --daemon
clickhouse-server --config-file=/etc/clickhouse-server/config-ch3.xml --daemon

users.xml