ClickHouse部署教程
组件版本
组件 |
版本 |
JDK |
1.8 |
Mysql |
5.7.25 |
ClickHouse-client |
21.1.9.41 |
ClickHouse-server |
21.1.9.41 |
ClickHouse-common |
21.1.9.41 |
机器环境
IP |
主机名 |
密码 |
192.168.222.201 |
master |
password |
192.168.222.202 |
slave1 |
password |
192.168.222.203 |
slave2 |
password |
1、Linux调优（三台同步做）
检查机器是否支持SSE 4.2命令
[root@master ~]#4
grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"1.1、取消打开文件数限制
[root@master ~]#
vim /etc/security/limits.conf修改内容:
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072说明:
soft: 软线程
hard: 硬线程
nofile: 文件数
noproc: 进程数vim /etc/security/limits.d/20-nproc.conf添加内容:
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 1310721.2、验证修改
需要退出当前连接，重新建立tty虚拟终端
[root@master ~]#
ulimit -a1.3、安装依赖
[root@master ~]#
yum install -y libtool *unixODBC*1.4、关闭selinux
[root@master ~]#
vim /etc/selinux/config修改内容:
SELINUX=disabled[root@master ~]#
setenforce 0注：临时设置selinux为Permissive状态，三台机器都要做
1.5、发送子机同步文件
[root@master ~]#
scp /etc/security/limits.conf root@slave1:/etc/security/
scp /etc/security/limits.conf root@slave2:/etc/security/
scp /etc/security/limits.d/20-nproc.conf root@slave1:/etc/security/limits.d/
scp /etc/security/limits.d/20-nproc.conf root@slave2:/etc/security/limits.d/
scp /etc/selinux/config root@slave1:/etc/selinux/config
scp /etc/selinux/config root@slave2:/etc/selinux/config2、安装click-common
2.1、解压click-common
[root@master ~]#
tar -xzvf /chinaskills/clickhouse-common-static-21.1.9.41.tgz -C /usr/local/src/
mv /usr/local/src/clickhouse-common-static-21.1.9.41 /usr/local/src/clickhouse-common-static2.2、安装click-common
[root@master ~]#
/usr/local/src/clickhouse-common-static/install/doinst.sh3、安装click-server
3.1、解压click-server
[root@master ~]#
tar -xzvf /chinaskills/clickhouse-server-21.1.9.41.tgz -C /usr/local/src/
mv /usr/local/src/clickhouse-server-21.1.9.41 /usr/local/src/clickhouse-server3.2、安装click-server
[root@master ~]#
/usr/local/src/clickhouse-server/install/doinst.sh3.3、启动click-server
[root@master ~]#
systemctl start clickhouse-server.service3.4、查看状态
[root@master ~]#
systemctl status clickhouse-server.service3.5、查看端口
[root@master ~]#
netstat -ntlp4、安装click-client
4.1、解压click-client
[root@master ~]#
tar -xzvf /chinaskills/clickhouse-client-21.1.9.41.tgz -C /usr/local/src/
mv /usr/local/src/clickhouse-client-21.1.9.41 /usr/local/src/clickhouse-client4.2、安装客户端
[root@master ~]#
/usr/local/src/clickhouse-client-21.1.9.41/install/doinst.sh4.3、客户端连接服务端
[root@master ~]#
clickhouse-client默认情况下，它localhost:9000代表用户连接，default无需密码。它还可以用于使用--host参数连接到远程服务器。