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> -->
改為無(wú)限制
<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ì)詢問(wèn)是否所有都能訪問(wèn)袒哥，輸入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
