【每天1分钟】Centos7安装ClickHouse
如果从官方仓库安装，需要确保您使用的是x86_64处理器构架的Linux并且支持SSE 4.2指令集
1. 查看操作系统版本
more /etc/redhat-release
[root@host77 ~]$ more /etc/redhat-release
CentOS Linux release 7.4.1708 (Core)
2. 检查是否支持SSE 4.2
grep -q sse4_2 /proc/cpuinfo && echo “SSE 4.2 supported” || echo “SSE 4.2 not supported”
[root@host77 ~]# grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"
SSE 4.2 supported
3. 检查终端编码是否为UTF-8
echo $LANG
[root@host77 ~]# echo $LANG
en_US.UTF-8
4. 创建目录
[root@host77 ~]$ mkdir clickhouse
[root@host77 ~]$ cd clickhouse
[root@host77 ~]$ mkdir clickhouse
[root@host77 ~]$ cd clickhouse
5. 下载离线安装包
下载地址：http://repo.red-soft.biz/repos/clickhouse/stable/el7/
wget http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-client-1.1.54236-4.el7.x86_64.rpm
wget http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-compressor-1.1.54236-4.el7.x86_64.rpm
wget http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-debuginfo-1.1.54236-4.el7.x86_64.rpm
wget http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-server-1.1.54236-4.el7.x86_64.rpm
wget http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-server-common-1.1.54236-4.el7.x86_64.rpm
[root@host77 clickhouse]$ wget http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-client-1.1.54236-4.el7.x86_64.rpm
--2019-07-10 09:37:26-- http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-client-1.1.54236-4.el7.x86_64.rpm
Resolving repo.red-soft.biz (repo.red-soft.biz)... 185.61.25.133
Connecting to repo.red-soft.biz (repo.red-soft.biz)|185.61.25.133|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3048 (3.0K) [application/x-rpm]
Saving to: ‘clickhouse-client-1.1.54236-4.el7.x86_64.rpm’
100%[========================================================================================>] 3,048 --.-K/s in 0s
2019-07-10 09:37:28 (305 MB/s) - ‘clickhouse-client-1.1.54236-4.el7.x86_64.rpm’ saved [3048/3048]
[root@host77 clickhouse]$ wget http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-compressor-1.1.54236-4.el7.x86_64.rpm
--2019-07-10 09:37:51-- http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-compressor-1.1.54236-4.el7.x86_64.rpm
Resolving repo.red-soft.biz (repo.red-soft.biz)... 185.61.25.133
Connecting to repo.red-soft.biz (repo.red-soft.biz)|185.61.25.133|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 901472 (880K) [application/x-rpm]
Saving to: ‘clickhouse-compressor-1.1.54236-4.el7.x86_64.rpm’
100%[=================================================================================================================================================================================================>] 901,472 30.3KB/s in 26s
2019-07-10 09:38:17 (33.9 KB/s) - ‘clickhouse-compressor-1.1.54236-4.el7.x86_64.rpm’ saved [901472/901472]
[root@host77 clickhouse]$ wget http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-debuginfo-1.1.54236-4.el7.x86_64.rpm
--2019-07-10 09:38:25-- http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-debuginfo-1.1.54236-4.el7.x86_64.rpm
Resolving repo.red-soft.biz (repo.red-soft.biz)... 185.61.25.133
Connecting to repo.red-soft.biz (repo.red-soft.biz)|185.61.25.133|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 9043256 (8.6M) [application/x-rpm]
Saving to: ‘clickhouse-debuginfo-1.1.54236-4.el7.x86_64.rpm’
100%[=================================================================================================================================================================================================>] 9,043,256 27.6KB/s in 4m 49s
2019-07-10 09:43:15 (30.6 KB/s) - ‘clickhouse-debuginfo-1.1.54236-4.el7.x86_64.rpm’ saved [9043256/9043256]
[root@host77 clickhouse]$ wget http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-server-1.1.54236-4.el7.x86_64.rpm
--2019-07-10 09:43:28-- http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-server-1.1.54236-4.el7.x86_64.rpm
Resolving repo.red-soft.biz (repo.red-soft.biz)... 185.61.25.133
Connecting to repo.red-soft.biz (repo.red-soft.biz)|185.61.25.133|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 33680608 (32M) [application/x-rpm]
Saving to: ‘clickhouse-server-1.1.54236-4.el7.x86_64.rpm’
100%[=================================================================================================================================================================================================>] 33,680,608 33.9KB/s in 16m 7s
2019-07-10 09:59:35 (34.0 KB/s) - ‘clickhouse-server-1.1.54236-4.el7.x86_64.rpm’ saved [33680608/33680608]
[root@host77 clickhouse]$ wget http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-server-common-1.1.54236-4.el7.x86_64.rpm
--2019-07-10 09:59:45-- http://repo.red-soft.biz/repos/clickhouse/stable/el7/clickhouse-server-common-1.1.54236-4.el7.x86_64.rpm
Resolving repo.red-soft.biz (repo.red-soft.biz)... 185.61.25.133
Connecting to repo.red-soft.biz (repo.red-soft.biz)|185.61.25.133|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 8164 (8.0K) [application/x-rpm]
Saving to: ‘clickhouse-server-common-1.1.54236-4.el7.x86_64.rpm’
100%[=================================================================================================================================================================================================>] 8,164 --.-K/s in 0s
2019-07-10 09:59:45 (21.6 MB/s) - ‘clickhouse-server-common-1.1.54236-4.el7.x86_64.rpm’ saved [8164/8164]
6. 安装
rpm -ivh clickhouse-server-common-1.1.54236-4.el7.x86_64.rpm
rpm -ivh clickhouse-server-1.1.54236-4.el7.x86_64.rpm
rpm -ivh clickhouse-client-1.1.54236-4.el7.x86_64.rpm
rpm -ivh clickhouse-debuginfo-1.1.54236-4.el7.x86_64.rpm
rpm -ivh clickhouse-compressor-1.1.54236-4.el7.x86_64.rpm
7. 关闭防火墙
systemctl stop firewalld.service #停止firewall
systemctl disable firewalld.service #禁止firewall开机启动
[root@host77 clickhouse]# systemctl stop firewalld.service
[root@host77 clickhouse]# systemctl disable firewalld.service
8. 启动clickhouse服务端
service clickhouse-server start
如果不行，用下面的命令
clickhouse-server --config-file=/etc/clickhouse-server/config.xml
[root@host77 clickhouse]# clickhouse-server --config-file=/etc/clickhouse-server/config.xml
9. 通过客户端连接服务端
clickhouse-client -m
[root@host77 clickhouse]# clickhouse-client -m
10. Q&A
- Q1
[root@host77 clickhouse]# rpm -ivh clickhouse-server-1.1.54236-4.el7.x86_64.rpm
error: Failed dependencies:
libicudata.so.50()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64
libicui18n.so.50()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64
libicuuc.so.50()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64
libltdl.so.7()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64
libodbc.so.2()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64
解决：yum install -y unixODBC libicudata