安装部署clickhouse

一 下载rpm包

1.查看Linux

cat /prod/version

我的如下
[root@server04 clickhouse-server]# cat /proc/version
Linux version 3.10.0-862.el7.x86_64 (builder@kbuilder.dev.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-28) (GCC) ) #1 SMP Fri Apr 20 16:44:24 UTC 2018
2.到此网址 https://packagecloud.io/Altinity/clickhouse/复制对应版本的下载包方法
3.采用wget方式下载到指定目录/opt/software/clickhouse/

cd /opt/software/clickhouse/

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-server-common-19.17.10.1-1.el7.x86_64.rpm/download.rpm

用同样的方式获取到同一版本的下面的包

[root@server04 clickhouse]# ll
total 38504
-rw-r--r-- 1 root root     6380 Aug  6 06:02 clickhouse-client-19.17.10.1-1.el7.x86_64.rpm
-rw-r--r-- 1 root root 26818100 Aug  6 06:02 clickhouse-common-static-19.17.10.1-1.el7.x86_64.rpm
-rw-r--r-- 1 root root 11138292 Aug  6 06:05 clickhouse-server-19.17.10.1-1.el7.x86_64.rpm
-rw-r--r-- 1 root root    10552 Aug  6 06:05 clickhouse-server-common-19.17.10.1-1.el7.x86_64.rpm
-rw-r--r-- 1 root root  1442264 Aug  6 06:05 clickhouse-test-19.17.10.1-1.el7.x86_64.rpm

4.依次安装

rpm -ivh clickhouse-common-static-19.17.10.1-1.el7.x86_64.rpm
rpm -ivh clickhouse-server-common-19.17.10.1-1.el7.x86_64.rpm
rpm -ivh clickhouse-server-19.17.10.1-1.el7.x86_64.rpm
rpm -ivh clickhouse-client-19.17.10.1-1.el7.x86_64.rpm

5.启动

/etc/init.d/clickhouse-server start

出现以下成功

[root@server04 clickhouse-server]# /etc/init.d/clickhouse-server start
Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /var/lib/clickhouse/
DONE

6.客户端查询

[root@server04 clickhouse-server]# clickhouse-client localhost 9000
ClickHouse client version 19.17.10.1.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 19.17.10 revision 54428.

server04 :) show databases;

SHOW DATABASES

┌─name────┐
│ default │
│ system  │
└─────────┘

2 rows in set. Elapsed: 0.003 sec. 

server04 :) select 1;

SELECT 1

┌─1─┐
│ 1 │
└───┘

1 rows in set. Elapsed: 0.002 sec.

7.可以修改密码
默认是defafult用户无密码,密码支持明文和暗文
这里只参考明文密码

[root@server04 opt]# /etc/init.d/clickhouse-server stop
Stop clickhouse-server service: DONE
[root@server04 opt]# cd /etc/clickhouse-server/
[root@server04 clickhouse-server]# ll
total 28
-rw-r--r-- 1 root root 19817 Aug  6 05:42 config.xml
-rw-r--r-- 1 root root  6250 Aug  6 05:42 users.xml
[root@server04 clickhouse-server]# vi users.xml

在文件里写上密码123456
重新启动

[root@server04 clickhouse-server]# clickhouse-client localhost 9000 --password 123456
ClickHouse client version 19.17.10.1.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 19.17.10 revision 54428.

7.集群部署