Clickhouse搭建
安装前准备
/etc/security/limits.conf 、 /etc/security/limits.d/90-nproc.conf 在 这 2 个文件的末尾加入以下内容
vim /etc/security/limits.conf
在文件末尾添加:
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
重启服务器之后生效,用 ulimit -n 或者 ulimit -a 查看设置结果
ulimit -n
CentOS 取消 SELINUX
修改/etc/selinux/config 中的 SELINUX=disabled 后重启
vim /etc/selinux/config
SELINUX=disabled
关闭防火墙
service iptables stop
安装依赖
yum install -y libtool
yum install -y *unixODBC*
安装包下载
clickhouse-common-static-20.8.4.11-1.el7.x86_64.rpm
clickhouse-server-common-20.8.4.11-1.el7.x86_64.rpm
clickhouse-server-20.8.4.11-1.el7.x86_64.rpm
clickhouse-client-20.8.4.11-1.el7.x86_64.rpm
将安装包上传至服务器
安装
rpm -ivh clickhouse-common-static-20.8.4.11-1.el7.x86_64.rpm
rpm -ivh clickhouse-server-common-20.8.4.11-1.el7.x86_64.rpm
rpm -ivh clickhouse-server-20.8.4.11-1.el7.x86_64.rpm
rpm -ivh clickhouse-client-20.8.4.11-1.el7.x86_64.rpm
启动 ClickServer
clickhouse-server
使用 client 连接 server
clickhouse-client
show databases;