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.confscp /etc/security/limits.d/20-nproc.conf node3:/etc/security/limits.d/20-nproc.conf
4,安装依赖
yum install -y libtoolyum install -y *unixODBC*
5,Centos取消selinux
vim /etc/selinux/configSELINUX=disabled
分发到其他结点:
scp /etc/selinux/config node2:/etc/selinux/configscp /etc/selinux/config node3:/etc/selinux/config
5,重启服务器
二,单机安装1,从官网下载ClickHouse安装包
下载地址:http://repo.red-soft.biz/repos/clickhouse/stable/el6/
2,将安装包分发到其他服务器
scp ./* node2:$PWDscp ./* node3:$PWD
3,下载完成后执行安装命令
sudo rpm -ivh *.rpm
4,修改配置文件
vim /etc/clickhouse-server/config.xml
把::的注释打开,这样的话才能让ClickHouse被除本机以外的服务器访问。
5,分发配置文件到其他服务器
scp /etc/clickhouse-server/config.xml node2:/etc/clickhouse-server/config.xmlscp /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;