1.创建目录
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 修改默认安装路径
vi clickhouse-server/install/doinst.sh
/**
CLICKHOUSE_DATADIR=${CLICKHOUSE_DATADIR:=/var/lib/clickhouse}
CLICKHOUSE_LOGDIR=${CLICKHOUSE_LOGDIR:=/var/log/clickhouse-server}
*/
改成自己创建的路径
CLICKHOUSE_DATADIR=${CLICKHOUSE_DATADIR:=/clickhouse/data}
CLICKHOUSE_LOGDIR=${CLICKHOUSE_LOGDIR:=/clickhouse/log}
4.2 修改默认配置文件
- 修改路径
# 更改日志路径
sed -i "s:/var/log/clickhouse-server:/clickhouse/log:g" clickhouse-server/etc/clickhouse-server/config.xml
# 更改数据路径
sed -i "s:/var/lib/clickhouse:/clickhouse/data:g" clickhouse-server/etc/clickhouse-server/config.xml
- 更改config其他参数
vi clickhouse-server/etc/clickhouse-server/config.xml
/** 1.更改listen_host限制
<!-- <listen_host>::</listen_host> -->
改为无限制
<listen_host>::</listen_host>
/** 2.更改时区
<!-- <timezone>Europe/Moscow</timezone> -->
*/
改为
<timezone>Asia/Shanghai</timezone>
- 更改user其他参数
vi clickhouse-server/etc/clickhouse-server/users.xml
/** 1.打开默认可创建其他用户与授权
<!-- <access_management>1</access_management> -->
*/
改为
<access_management>1</access_management>
/** 2.处理单个查询的最大内存使用量(字节)
<max_memory_usage>10000000000</max_memory_usage>
*/
默认10G,若内存大可考虑设置为物理内存的一半,如128G物理内存设置为50G或60G
5. 执行安装
./clickhouse-common-static/install/doinst.sh
./clickhouse-common-static-dbg/install/doinst.sh
# 会询问是否所有都能访问,输入y
./clickhouse-server/install/doinst.sh
./clickhouse-client/install/doinst.sh
6.启动关闭
-- 启动
systemctl start clickhouse-server
-- 查看状态
systemctl status clickhouse-server
-- 关闭
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