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.081249001/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.081259002/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>

<max_memory_usage>10000000000</max_memory_usage>
<use_uncompressed_cache>0</use_uncompressed_cache>
<load_balancing>random</load_balancing>

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

users.xml