1.环境要求
Clickhouse 必须支持SSE4.2 指令集
命令:
grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"
效果:
2.取消文件打开的限制数以及取消SELINUX
1)修改/etc/security/limits.conf文件内容
* soft nofile 65535
* hard nofile 65535
* soft nproc 131072
* hard nproc 131072上面的前两个是打开文件限制数,后面两个是打开线程限制数
2)取消SELINUX
修改/etc/selinux/config中的SELINUX=disabled后重启
3) 通过命令查看是否生效(重启服务器)
3.关闭防火墙以及防火墙自启动
systemctl stop firewalld.service
systemctl disable firewalld.service
4.版本选择及下载
下载地址:https://packagecloud.io/Altinity/clickhouse
选择所需的安装包,只需要下面四种即可,其中el/7表示为centos7版本:
命令:
- wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-server-common-19.7.3.9-1.el7.x86_64.rpm/download.rpm
- wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-server-19.7.3.9-1.el7.x86_64.rpm/download.rpm
- wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-common-static-19.7.3.9-1.el7.x86_64.rpm/download.rpm
- wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-client-19.7.3.9-1.el7.x86_64.rpm/download.rpm
我们下载在/opt/clickhouse目录下:
5.安装命令,在/opt/clickhouse目录下执行
命令:
rpm -ivh ./*.rpm
如果有问题提前安装依赖:
- yum search libicu
- yum install libicu.x86_64
6.启动clickhouse
命令:service clickhouse-server start
7.使用命令行客户端连接到服务
命令:clickhouse-client
8.客户端常用的参数
9.关闭clickhouse-server
命令:service clickhouse-server stop