ClickHouse 安装

1.1、安装

[root@s205 clickhouse]# du -sh *
56K     clickhouse-client-20.4.5.36-2.noarch.rpm
112M    clickhouse-common-static-20.4.5.36-2.x86_64.rpm
1.1G    clickhouse-common-static-dbg-20.4.5.36-2.x86_64.rpm
80K     clickhouse-server-20.4.5.36-2.noarch.rpm
51M     DBeaver_x64_v7.1.0.zip
[root@s205 clickhouse]# rpm -ivh *.rpm
warning: clickhouse-client-20.4.5.36-2.noarch.rpm: Header V4 RSA/SHA1 Signature, key ID e0c56bd4: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:clickhouse-common-static-20.4.5.3################################# [ 25%]
   2:clickhouse-client-20.4.5.36-2    ################################# [ 50%]
   3:clickhouse-server-20.4.5.36-2    ################################# [ 75%]
Created symlink from /etc/systemd/system/multi-user.target.wants/clickhouse-server.service to /etc/systemd/system/clickhouse-server.service.
Path to data directory in /etc/clickhouse-server/config.xml: /var/lib/clickhouse/
   4:clickhouse-common-static-dbg-20.4################################# [100%]
[root@s205 clickhouse]# ll
total 1313572
-rw-r--r-- 1 root root      56708 Mar  2 15:06 clickhouse-client-20.4.5.36-2.noarch.rpm
-rw-r--r-- 1 root root  117222435 Mar  2 15:06 clickhouse-common-static-20.4.5.36-2.x86_64.rpm
-rw-r--r-- 1 root root 1175204526 Mar  2 15:10 clickhouse-common-static-dbg-20.4.5.36-2.x86_64.rpm
-rw-r--r-- 1 root root      78318 Mar  2 15:06 clickhouse-server-20.4.5.36-2.noarch.rpm
-rw-r--r-- 1 root root   52523511 Mar  2 15:06 DBeaver_x64_v7.1.0.zip

1.2、修改配置文件

[root@s205 clickhouse]# vi  /etc/clickhouse-server/config.xml

把:: 的注释打开，这样的话才能让 ClickHouse 被除本机以外的服务器访问

在这个文件中，有 ClickHouse 的一些默认路径配置，比较重要的

数据文件路径：/var/lib/clickhouse/
日志文件路径：/var/log/clickhouse-server/clickhouse-server.log

1.3、启动Server

systemctl start clickhouse-server

1.4、使用 client 连接 server

clickhouse-client 

报错Code: 210. DB::NetException: Connection refused (localhost:9000, ::1 修改配置文件 9001 在使用--port指定端口

clickhouse-client --port 9001

[root@s205 clickhouse]# clickhouse-client --port 9001
ClickHouse client version 20.4.5.36 (official build).
Connecting to localhost:9001 as user default.
Connected to ClickHouse server version 20.4.5 revision 54434.

s205 :)