前提
- 需要一个Zookeeper集群
- 需要三个节点部署ClickHouse
config.xml基础配置
vi config.xml
通常要检查xml里面这几个:
listen_host # 改成<listen_host>::</listen_host>
tcp_port # 要改端口这里http 和 tcp
http_port
path
timezone #时区
user_scripts_path #自定义方法的一些实现
user_defined_executable_functions_config
include_from # 这里面应该是要有metrika.xml
分片配置
/etc/clickhouse-server/config.d/metrika.xml
<yandex><remote_servers><clickhouse_cluster_3shards_1replicas><shard><internal_replication>true</internal_replication><replica><host>master</host><port>9000</port></replica></shard><shard><internal_replication>true</internal_replication><replica><host>slave1</host><port>9000</port></replica></shard><shard><internal_replication>true</internal_replication><replica><host>slave2</host><port>9000</port></replica></shard></clickhouse_cluster_3shards_1replicas></remote_servers><zookeeper><node index="1"><host>master</host><port>2181</port></node><node index="2"><host>slave1</host><port>2181</port></node><node index="3"><host>slave2</host><port>2181</port></node></zookeeper><macros><shard>1</shard> <replica>1-2</replica><replica>1-2-1</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>
集群节点配置clickhouse_remote_servers
clickhouse_cluster_3shards_1replicas 集群分片的名称
zookeeper配置 zookeeper-server
副本分片 macros
网络 networks
压缩相关配置 clickhouse_compression