1.下載
下載地址：https://packagecloud.io/Altinity/clickhouse
2.上傳rpm
上傳rpm包到服務(wù)器node01、node02、node03服務(wù)器上的/kkb/soft路徑下
3.每臺節(jié)點安裝下面的2個依賴
sudo yum install -y libtool
sudo yum install -y *unixODBC*
每臺節(jié)點安裝ck服務(wù)
cd /kkb/soft/
sudo rpm -ivh clickhouse*rpm
#注意：請確保soft目錄下沒有除ClickHouse.rpm結(jié)尾以外的rpm結(jié)尾的安裝包
4.修改配置文件
修改config.xml三臺機器都修改配置文件
# node01
sudo vim /etc/clickhouse-server/config.xml
#放開注釋的這一行
<listen_host>::</listen_host>
#將配置文件拷貝到其他機器上面去
sudo scp /etc/clickhouse-server/config.xml node02:/etc/clickhouse-server/
sudo scp /etc/clickhouse-server/config.xml node03:/etc/clickhouse-server/
#注意：如果此不報錯，則說明第三部操作失敗 ，請從第三部重試。
創(chuàng)建metrika.xml
#node01
sudo vim /etc/metrika.xml
<yandex>
<!-- 集群配置 -->
<clickhouse_remote_servers>
<bip_ck_cluster>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>node01</host>
<port>9000</port>
</replica>
</shard>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>node02</host>
<port>9000</port>
</replica>
</shard>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>node03</host>
<port>9000</port>
</replica>
</shard>
</bip_ck_cluster>
</clickhouse_remote_servers>
?
<!-- 本節(jié)點副本，不同的機器配置不同 -->
<macros>
<replica>node01</replica>
</macros>
?
<!-- ZK -->
<zookeeper-servers>
<node index="1">
<host>node01</host>
<port>2181</port>
</node>
<node index="2">
<host>node02</host>
<port>2181</port>
</node>
<node index="3">
<host>node03</host>
<port>2181</port>
</node>
</zookeeper-servers>
?
<!-- 監(jiān)聽網(wǎng)絡(luò) -->
<networks>
<ip>::/0</ip>
</networks>
<!-- 數(shù)據(jù)壓縮算法 -->
<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>
node02服務(wù)器創(chuàng)建metrika.xml
#node02
sudo vim /etc/metrika.xml
<yandex>
<!-- 集群配置 -->
<clickhouse_remote_servers>
<bip_ck_cluster>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>node01</host>
<port>9000</port>
</replica>
</shard>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>node02</host>
<port>9000</port>
</replica>
</shard>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>node03</host>
<port>9000</port>
</replica>
</shard>
</bip_ck_cluster>
</clickhouse_remote_servers>
?
<!-- 本節(jié)點副本，不同的機器配置不同 -->
<macros>
<replica>node02</replica>
</macros>
?
<!-- ZK -->
<zookeeper-servers>
<node index="1">
<host>node01</host>
<port>2181</port>
</node>
<node index="2">
<host>node02</host>
<port>2181</port>
</node>
<node index="3">
<host>node03</host>
<port>2181</port>
</node>
</zookeeper-servers>
?
<!-- 監(jiān)聽網(wǎng)絡(luò) -->
<networks>
<ip>::/0</ip>
</networks>
?
<!-- 數(shù)據(jù)壓縮算法 -->
<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>
node03服務(wù)器創(chuàng)建metrika.xml
#node03
sudo vim /etc/metrika.xml
<yandex>
<!-- 集群配置 -->
<clickhouse_remote_servers>
<bip_ck_cluster>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>node01</host>
<port>9000</port>
</replica>
</shard>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>node02</host>
<port>9000</port>
</replica>
</shard>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>node03</host>
<port>9000</port>
</replica>
</shard>
</bip_ck_cluster>
</clickhouse_remote_servers>
?
<!-- 本節(jié)點副本，不同的機器配置不同 -->
<macros>
<replica>node03</replica>
</macros>
<!-- ZK -->
<zookeeper-servers>
<node index="1">
<host>node01</host>
<port>2181</port>
</node>
<node index="2">
<host>node02</host>
<port>2181</port>
</node>
<node index="3">
<host>node03</host>
<port>2181</port>
</node>
</zookeeper-servers>
?
<!-- 監(jiān)聽網(wǎng)絡(luò) -->
<networks>
<ip>::/0</ip>
</networks>
<!-- 數(shù)據(jù)壓縮算法 -->
<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>
給予權(quán)限
#創(chuàng)建目錄
sudo mkdir -p /var/lib/clickhouse/data
sudo mkdir -p /var/lib/clickhouse/metadata
sudo chmod -R 777 /var/lib/clickhouse/data
sudo chmod -R 777 /var/lib/clickhouse/metadata
搭建clickhouse過程中會生成對應(yīng)的目錄
配置文件路徑：/etc/clickhouse-server/config.xml
日志文件路徑：/var/log/clickhouse-server/
建表信息路徑：/data/clickhouse/metadata/
分區(qū)數(shù)據(jù)路徑：/data/clickhouse/data/
5.啟動ClickHouse啟動
sudo service clickhouse-server start
# 命令查看ck是否啟動成功
ps -ef | grep clickhouse
連接客戶端
clickhouse-client
show databases;
ClickHouse的服務(wù)停止
三個節(jié)點執(zhí)行
sudo server clickhouse-server stop
5.命令行客戶端連接ClickHouse
clickhouse-client -m -u [username] -h [ip] --password [password] --port [port]
--user 或者 -u
用戶名。 默認(rèn)值： default。
--password
密碼。 默認(rèn)值：空字符串。
--host 或者 -h
服務(wù)端的 host 名稱, 默認(rèn)是 'localhost'
--port
連接的端口，默認(rèn)值： 9000。
--multiline 或者 -m
如果指定，允許多行語句查詢（Enter 僅代表換行，不代表查詢語句完結(jié)）。
演示：開啟多行查詢
clickhouse-client -m 或者 clickhouse-client -multiline
