男子公众号下单做防水补漏_公司企业网络推广_免费的模板网站_国内重大新闻十条

前提

• 需要一个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