vim /etc/clickhouse-server/config.xml
<listen_host>::</listen_host><!-- <listen_host>::1</listen_host> --><!-- <listen_host>127.0.0.1</listen_host> -->
在每台机器的etc目录下新建metrika.xml文件
vim /etc/metrika.xml
添加如下内容:
<yandex><clickhouse_remote_servers><perftest_2shards_1replicas><shard><internal_replication>true</internal_replication><replica><host>xxx1</host><port>9000</port></replica></shard><shard><replica><internal_replication>true</internal_replication><host>xxx2</host><port>9000</port></replica></shard></perftest_2shards_1replicas></clickhouse_remote_servers><zookeeper-servers><nodeindex="1"><host>xxx1</host><port>2181</port></node><nodeindex="2"><host>xxx2</host><port>2181</port></node><nodeindex="3"><host>xxx3</host><port>2181</port></node></zookeeper-servers><macros><replica>xxx2</replica></macros><networks><ip>::/0</ip></networks><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>
修改配置
vim /etc/clickhouse-server/config.xml
# 修改各种path:<path>/data/clickhouse/</path><tmp_path>/data/clickhouse/tmp/</tmp_path><user_files_path>/data/clickhouse/user_files/</user_files_path><format_schema_path>/data/clickhouse/format_schemas/</format_schema_path>