ClickHouse 单机环境安装【二进制包】

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