clickhouse是由俄罗斯Yandex公司开发的列式存储数据库,于2016年开源,clickhouse的定位是快速的数据分析,对于处理海量数据的情况性能非常好,在网上也有很多测试的案例,在大数据的情况下性能远超过其他数据库,并且不依赖于hadoop的生态系统,都是独立使用,在大数据存储业务上还是可以考虑的.
clickhouse官网地址:https://clickhouse.yandex/,文档地址:https://clickhouse.yandex/docs/en/
另外推荐单页文档,更方便:https://clickhouse.yandex/docs/en/single
下面开始安装
安装依赖项
安装过程需要curl
下载包。此外,ClickHouse测试包在EPEL中有一些依赖关系,因此epel-release
必须安装,以防您想要安装ClicKhouse测试包确保curl
安装在系统上
1 2 3 | sudo yum install -y curl #如果安装了测试包,添加epel-release sudo yum install -y epel-release |
让我们下载并运行packagecloud.io提供的安装shell脚本
对于CentOS 6和7
1 | curl -s https: //packagecloud .io /install/repositories/altinity/clickhouse/script .rpm.sh | sudo bash |
脚本后安装包
首先,确保我们有可用于安装的ClickHouse软件包
1 | sudo yum list 'clickhouse*' |
ClickHouse包应该列为可用,如下所示:
1 2 3 4 5 6 7 8 9 | #可用包组 clickhouse-client.x86_64 18.1.0-1.el7 Altinity_clickhouse clickhouse-common-static.x86_64 18.1.0-1.el7 Altinity_clickhouse clickhouse-compressor.x86_64 1.1.54336-3.el7 Altinity_clickhouse clickhouse-debuginfo.x86_64 18.1.0-1.el7 Altinity_clickhouse clickhouse-mysql.noarch 0.0.20180319-1 Altinity_clickhouse clickhouse-server.x86_64 18.1.0-1.el7 Altinity_clickhouse clickhouse-server-common.x86_64 18.1.0-1.el7 Altinity_clickhouse clickhouse- test .x86_64 18.1.0-1.el7 Altinity_clickhouse |
有多个软件包可用(新版本和旧工具),其中一些已经弃用,因此无需安装所有可用的RPM。
现在让我们安装ClickHouse主要部件 - 服务器和客户端应用程序。
1 | sudo yum install -y clickhouse-server clickhouse-client |
并验证它是否已列为已安装
1 | sudo yum list installed 'clickhouse*' |
ClickHouse软件包应列为已安装,如下所示:
1 2 3 4 5 | Installed Packages clickhouse-client.x86_64 18.1.0-1.el7 @Altinity_clickhouse clickhouse-common-static.x86_64 18.1.0-1.el7 @Altinity_clickhouse clickhouse-server.x86_64 18.1.0-1.el7 @Altinity_clickhouse clickhouse-server-common.x86_64 18.1.0-1.el7 @Altinity_clickhouse |
确保ClickHouse服务器正在运行
1 | sudo /etc/init .d /clickhouse-server restart |
然后连接到它 clickhouse-client
ClickHouse服务器应该响应,如下所示:
1 2 3 4 5 | ClickHouse客户端版本18.1.0。 连接到localhost:9000作为用户默认值。 连接到ClickHouse服务器版本18.1.54396。 :) |
第二种方式手动安装:
让我们手动添加Altinity的repo
安装所需的包
我们需要在beforehands之前安装以下软件包:
EL6 repo file
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | cat << "EOF" | sudo tee /etc/yum .repos.d /altinity_clickhouse .repo [altinity_clickhouse] name=altinity_clickhouse baseurl=https: //packagecloud .io /altinity/clickhouse/el/6/ $basearch repo_gpgcheck=1 gpgcheck=0 enabled=1 gpgkey=https: //packagecloud .io /altinity/clickhouse/gpgkey sslverify=1 sslcacert= /etc/pki/tls/certs/ca-bundle .crt metadata_expire=300 [altinity_clickhouse- source ] name=altinity_clickhouse- source baseurl=https: //packagecloud .io /altinity/clickhouse/el/6/SRPMS repo_gpgcheck=1 gpgcheck=0 enabled=1 gpgkey=https: //packagecloud .io /altinity/clickhouse/gpgkey sslverify=1 sslcacert= /etc/pki/tls/certs/ca-bundle .crt metadata_expire=300 EOF |
EL7 repo file
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | cat << "EOF" | sudo tee /etc/yum .repos.d /altinity_clickhouse .repo [altinity_clickhouse] name=altinity_clickhouse baseurl=https: //packagecloud .io /altinity/clickhouse/el/7/ $basearch repo_gpgcheck=1 gpgcheck=0 enabled=1 gpgkey=https: //packagecloud .io /altinity/clickhouse/gpgkey sslverify=1 sslcacert= /etc/pki/tls/certs/ca-bundle .crt metadata_expire=300 [altinity_clickhouse- source ] name=altinity_clickhouse- source baseurl=https: //packagecloud .io /altinity/clickhouse/el/7/SRPMS repo_gpgcheck=1 gpgcheck=0 enabled=1 gpgkey=https: //packagecloud .io /altinity/clickhouse/gpgkey sslverify=1 sslcacert= /etc/pki/tls/certs/ca-bundle .crt metadata_expire=300 |
更新缓存
创建repo文件后,让我们yum
使用新添加的altinity_clickhouse
repo中的包更新缓存
1 | sudo yum -q makecache -y --disablerepo = ' * ' - enablerepo = ' altinity_clickhouse ' |
安装到此结束:)
第三种方法为离线安装:
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTYyNjc3My8yMDE5MDYvMTYyNjc3My0yMDE5MDYxOTE1MDc1NDA3My0xMTE0ODY5MDUucG5n?x-oss-process=image/format,png)
查看系统版本为CentOS7.6
执行命令查看是否支持安装:
1 | grep -q sse4_2 /proc/cpuinfo && echo “SSE 4.2 supported” || echo “SSE 4.2 not supported” |
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTYyNjc3My8yMDE5MDYvMTYyNjc3My0yMDE5MDYxOTE1MDkyMTI0NC01ODU2Mzk4NDgucG5n?x-oss-process=image/format,png)
然后下载ClickHouse所需的离线安装包,下载地址:http://repo.red-soft.biz/repos/clickhouse/stable/el7/
1 2 3 4 5 | 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 |
下载完毕开始安装
1 2 3 4 5 6 7 | 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 报错:错误:依赖检测失败:libodbc.so.2()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要 解决办法:yum install *ODBC* rpm -ivh clickhouse-debuginfo-1.1.54236-4.el7.x86_64.rpm rpm -ivh clickhouse-compressor-1.1.54236-4.el7.x86_64.rpm rpm -ivh clickhouse-client-1.1.54236-4.el7.x86_64.rpm |
安装完成后关闭防火墙和Selinux
1 2 3 | systemctl stop firewalld.service #停止firewall systemctl disable firewalld.service #禁止firewall开机启动 setenforce 0 #关闭selinux |
启动clickhouse服务端
1 | service clickhouse-server start |
通过客户端连接
![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTYyNjc3My8yMDE5MDYvMTYyNjc3My0yMDE5MDYxOTE1MTM0MTUzMC0xNDE5NjgxMjU2LnBuZw?x-oss-process=image/format,png)
出现笑脸代表成功:)