1、installation
sudo yum install yum-utils
sudo rpm --import https://repo.yandex.ru/clickhouse/CLICKHOUSE-KEY.GPG
sudo yum-config-manager --add-repo https://repo.yandex.ru/clickhouse/rpm/stable/x86_64
sudo yum install clickhouse-server clickhouse-client
安裝以后就可以用"service clickhouse-server start"來啟動(dòng)clickhouse，默認(rèn)安裝路徑在/etc/clickhouse-server
2、configuration update
(1)config.xml
| parameter | update |
|---|---|
| interserver_http_host | 修改成機(jī)器ip |
| listen_host | <listen_host>::</listen_host>,ipv4跟ipv6都可以連接 |
| path | 存儲(chǔ)數(shù)據(jù)的路徑 |
| tmp_path | {path}/tmp |
| <include_from>/etc/clickhouse-server/metrika.xml</include_from> | 添加這個(gè)配置，指定metrika.xml |
| <remote_servers incl="clickhouse_remote_servers" /> | 把里面的配置刪掉，加上尾巴的斜杠。具體配置在metrika.xml |
| <compression incl="clickhouse_compression"/> | 把里面的配置刪掉，加上尾巴的斜杠。具體配置在metrika.xml |
| <max_table_size_to_drop>0</max_table_size_to_drop><max_partition_size_to_drop>0</max_partition_size_to_drop> | 把這些配置開起來，去掉刪除時(shí)候大小的限制 |
3、users.xml
| parameter | update |
|---|---|
| <log_queries>1</log_queries> | 在profiles里面把log_queries開起來 |
| <root><password_sha256_hex></password_sha256_hex><networks><ip>127.0.0.1</ip><ip>::/0</ip></networks><profile>default</profile><quota>default</quota></user></root> | 把users里面刪掉，加上root這個(gè)用戶的信息 |
4、metrika.xml
<yandex>
<clickhouse_remote_servers>
<my_cluster>
<shard>
<weight>1</weight>
<replica>
<host>{IP}</host>
<port>{CH-TCP-PORT}</port>
</replica>
</shard>
</my_cluster>
</clickhouse_remote_servers>
<!-- optional
<macros>
<shard>SHARD1</shard>
<replica>{IP}</replica>
</macros>
-->
<!-- optional
<zookeeper-servers>
<node index="1">
<host>{ZK-IP}</host>
<port>{ZK-PORT}</port>
</node>
</zookeeper-servers>
-->
<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>
