一,准备工作
1,确定防火墙处于关闭状态
2,CentOS取消打开文件数限制
vim /etc/security/limits.conf
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
vim /etc/security/limits.d/20-nproc.conf
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
3,将上述配置文件同步到其他要安装ClickHouse的节点
scp /etc/security/limits.d/20-nproc.conf node2:/etc/security/limits.d/20-nproc.conf
scp /etc/security/limits.d/20-nproc.conf node3:/etc/security/limits.d/20-nproc.conf
4,安装依赖
yum install -y libtool
yum install -y *unixODBC*
5,Centos取消selinux
vim /etc/selinux/config
SELINUX=disabled
分发到其他结点:
scp /etc/selinux/config node2:/etc/selinux/config
scp /etc/selinux/config node3:/etc/selinux/config
5,重启服务器
二,单机安装
1,从官网下载ClickHouse安装包
下载地址:http://repo.red-soft.biz/repos/clickhouse/stable/el6/
2,将安装包分发到其他服务器
scp ./* node2:$PWD
scp ./* node3:$PWD
3,下载完成后执行安装命令
sudo rpm -ivh *.rpm
4,修改配置文件
vim /etc/clickhouse-server/config.xml
把<listen_host>::</listen_host>
的注释打开,这样的话才能让ClickHouse被除本机以外的服务器访问。
5,分发配置文件到其他服务器
scp /etc/clickhouse-server/config.xml node2:/etc/clickhouse-server/config.xml
scp /etc/clickhouse-server/config.xml node3:/etc/clickhouse-server/config.xml
6,启动ClickHouse-sever
systemctl start clickhouse-server
7,关闭开机启动
systemctl disable clickhouse-server
8,测试,使用客户端连接server
clickhouse-client -m
执行简单查询:show databases;