Clickhouse单机部署

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 131072

1.2、验证修改

需要退出当前连接，重新建立tty虚拟终端

[root@master ~]#

ulimit -a

1.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/config

2、安装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-static

2.2、安装click-common

[root@master ~]#

/usr/local/src/clickhouse-common-static/install/doinst.sh 

3、安装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-server

3.2、安装click-server

[root@master ~]#

/usr/local/src/clickhouse-server/install/doinst.sh

3.3、启动click-server

[root@master ~]#

systemctl start clickhouse-server.service

3.4、查看状态

[root@master ~]#

systemctl status  clickhouse-server.service

3.5、查看端口

[root@master ~]#

netstat -ntlp

4、安装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-client

4.2、安装客户端

[root@master ~]#

/usr/local/src/clickhouse-client-21.1.9.41/install/doinst.sh 

4.3、客户端连接服务端

[root@master ~]#

clickhouse-client

默认情况下，它localhost:9000代表用户连接，default无需密码。它还可以用于使用--host参数连接到远程服务器。