ClickHouse安装步骤
环境要求
CPU需支持 SSE 4.2
验证方法
grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"
返回结果必须为supported 才可以应用
上传RPM包
[root@localhost data]# ll -h
总用量 93M
-rw-r--r--. 1 root root 113K 5月 11 09:40 clickhouse-client-19.17.2.4-2.noarch.rpm
-rw-r--r--. 1 root root 92M 5月 11 09:41 clickhouse-common-static-19.17.2.4-2.x86_64.rpm
-rw-r--r--. 1 root root 133K 5月 11 09:40 clickhouse-server-19.17.2.4-2.noarch.rpm
安装
yum localinstall * -y
修改配置文件
vim /etc/clickhouse-server/config.xml
<!-- Path to data directory, with trailing slash. -->
<path>/data/clickhouse/</path>
<!-- Path to temporary data for processing hard queries. -->
<tmp_path>/data/clickhouse/tmp/</tmp_path>
<!-- Directory with user provided files that are accessible by 'file' table function. -->
<user_files_path>/data/clickhouse/user_files/</user_files_path>
打开注释
<!-- <listen_host>::</listen_host> -->
<listen_host>::</listen_host>
启动服务
[root@localhost data]# /etc/init.d/clickhouse-server start
Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /data/clickhouse/
Changing owner of [/data/clickhouse/] to [clickhouse:clickhouse]
DONE
防火墙加策略
[root@localhost ~]# firewall-cmd --permanent --add-port=8123/tcp
success
[root@localhost ~]# firewall-cmd --reload
success
[root@localhost ~]# firewall-cmd --list-all
重启一下服务器
init 6
查看clickhouse服务状态
安装好后。默认是自动启动的
systemctl status clickhouse-server
systemctl stop clickhouse-server
systemctl start clickhouse-server
修改users.xml配置文件需重启
配置用户名密码(明文)
vim /etc/clickhouse-server/users.xml
在 <users></user>
中加入 (明文方式)
<ck>
<password>ck@123</password>
<networks incl="networks" replace="replace">
<ip>::/0</ip>
</networks>
<profile>default</profile>
<quota>default</quota>
</ck>
配置用户名密码(Sha256加密,使用命令后,会随机生成密码2zWXojjD
)
[root@localhost ~]# PASSWORD=$(base64 < /dev/urandom | head -c8); echo "$PASSWORD"; echo -n "$PASSWORD" | sha256sum | tr -d '-'
2zWXojjD
5ebc037f13722d2ed624d19d09cc94dd2faa2e20671d495f6cdf1ac90bde7dc1
2zWXojjD
5ebc037f13722d2ed624d19d09cc94dd2faa2e20671d495f6cdf1ac90bde7dc1
在 <password_sha256_hex> 放入生成的密文
<cksha>
<password_sha256_hex>
5ebc037f13722d2ed624d19d09cc94dd2faa2e20671d495f6cdf1ac90bde7dc1
</password_sha256_hex>
<networks incl="networks" replace="replace">
<ip>::/0</ip>
</networks>
<profile>default</profile>
<quota>default</quota>
</cksha>
使用密码登录
clickhouse-client -u cksha --password 2zWXojjD
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-u7gSmgqM-1620702422940)(en-resource://database/4140:1)]
使用DBeaver连接
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-3b7ksvr1-1620702422943)(en-resource://database/4144:1)]
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-ZpB6vjSt-1620702422945)(en-resource://database/4142:1)]