1.創(chuàng)建目錄

mkdir /clickhouse
cd /clickhouse
mkdir app data log soft

2. 解壓縮

cd /clickhouse/app
tar zxvf /clickhouse/soft/clickhouse-common-static-20.11.6.6.tgz
tar zxvf /clickhouse/soft/clickhouse-common-static-dbg-20.11.6.6.tgz
tar zxvf /clickhouse/soft/clickhouse-server-20.11.6.6.tgz
tar zxvf /clickhouse/soft/clickhouse-client-20.11.6.6.tgz

3. 改名

mv clickhouse-common-static-20.11.6.6 clickhouse-common-static
mv clickhouse-common-static-dbg-20.11.6.6 clickhouse-common-static-dbg
mv clickhouse-server-20.11.6.6 clickhouse-server
mv clickhouse-client-20.11.6.6 clickhouse-client

4. 安裝前修改配置

4.1 修改默認(rèn)安裝路徑

vi clickhouse-server/install/doinst.sh

/**
CLICKHOUSE_DATADIR=${CLICKHOUSE_DATADIR:=/var/lib/clickhouse}
CLICKHOUSE_LOGDIR=${CLICKHOUSE_LOGDIR:=/var/log/clickhouse-server}
*/
改成自己創(chuàng)建的路徑
CLICKHOUSE_DATADIR=${CLICKHOUSE_DATADIR:=/clickhouse/data}
CLICKHOUSE_LOGDIR=${CLICKHOUSE_LOGDIR:=/clickhouse/log}

4.2 修改默認(rèn)配置文件

• 修改路徑

# 更改日志路徑
sed -i "s:/var/log/clickhouse-server:/clickhouse/log:g" clickhouse-server/etc/clickhouse-server/config.xml
# 更改數(shù)據(jù)路徑
sed -i "s:/var/lib/clickhouse:/clickhouse/data:g" clickhouse-server/etc/clickhouse-server/config.xml

• 更改config其他參數(shù)

vi clickhouse-server/etc/clickhouse-server/config.xml

/** 1.更改listen_host限制
<!-- <listen_host>::</listen_host> -->

改為無限制
<listen_host>::</listen_host>

/** 2.更改時(shí)區(qū)
<!-- <timezone>Europe/Moscow</timezone> -->
*/
改為
<timezone>Asia/Shanghai</timezone>

• 更改user其他參數(shù)

vi clickhouse-server/etc/clickhouse-server/users.xml

/** 1.打開默認(rèn)可創(chuàng)建其他用戶與授權(quán)
<!-- <access_management>1</access_management> -->
*/
改為
<access_management>1</access_management>

/** 2.處理單個(gè)查詢的最大內(nèi)存使用量（字節(jié)）
<max_memory_usage>10000000000</max_memory_usage>
*/
默認(rèn)10G，若內(nèi)存大可考慮設(shè)置為物理內(nèi)存的一半，如128G物理內(nèi)存設(shè)置為50G或60G

5. 執(zhí)行安裝

./clickhouse-common-static/install/doinst.sh
./clickhouse-common-static-dbg/install/doinst.sh
# 會(huì)詢問是否所有都能訪問，輸入y
./clickhouse-server/install/doinst.sh
./clickhouse-client/install/doinst.sh

6.啟動(dòng)關(guān)閉

-- 啟動(dòng)
systemctl start clickhouse-server
-- 查看狀態(tài)
systemctl status clickhouse-server
-- 關(guān)閉
systemctl stop clickhouse-server
-- 開啟自啟
systemctl enable clickhouse-server

7. 查看是否能正常登陸

[root@localhost data]# clickhouse-client 
ClickHouse client version 20.11.6.6 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 20.11.6 revision 54442.

localhost :) show databases;

SHOW DATABASES

Query id: 3369539c-bee5-427b-976a-01780af07e76

┌─name───────────────────────────┐
│ _temporary_and_external_tables │
│ default                        │
│ system                         │
└────────────────────────────────┘

3 rows in set. Elapsed: 0.004 sec. 

localhost :) 

或用戶名密碼登陸

clickhouse-client -h 127.0.0.1 --user default --port 9000 --password