ClickHouse 安装部署
1、前置环境准备
1.1、查看是否存在旧版本ClickHouse
[hui@hadoop201 ~]$ rpm -qa |grep clickhouse
如果存在安装数据可以卸载
yum remove -y clickhouse-common-static yum remove -y clickhouse-server-common rm -rf /var/lib/clickhouse rm -rf /etc/clickhouse-* rm -rf /var/log/clickhouse-server
注意：安装卸载使用root用户
1.2、关闭防火墙
systemctl stop firewalld
systemctl disable firewalld.service
1.3、CentOS设置打开文件数限制
查看限制
[hui@hadoop201 ~]$ ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 63372 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 65536 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 131072 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited
sudo vim /etc/security/limits.conf文件的末尾加入以下内容
[hui@hadoop201 ~]$ sudo vim /etc/security/limits.conf
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
sudo vim /etc/security/limits.d/20-nproc.conf文件的末尾加入以下内容
[hui@hadoop201 ~]$ sudo vim /etc/security/limits.d/20-nproc.conf
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
参数说明：
- 第一列表示用户组，* 表示所有用户所有组，hui@hui 表示hui的组下的hui用户；
- 第二列：软限制和隐限制，soft 要小于 hard
- 第三列：nofile 打开的文件数 nproc 进程数
- 第四列：具体数
以上配置完毕无需重启，重新登录系统即生效。
1.4、安装依赖
[hui@hadoop201 ~]$ sudo yum install -y libtool
[hui@hadoop201 ~]$ sudo yum install -y *unixODBC*
1.5、CentOS取消SELINUX
修改/etc/selinux/config中的SELINUX=disabled
[hui@hadoop201 ~]$ sudo vim /etc/selinux/config
SELINUX=disabled
设置完毕 SELINUX 如果不方便重启机器可以使其临时生效；
setenforce 0
2、安装 ClickHouse
2.1、上传安装文件
[hui@hadoop201 clickhouse]$ ll total 938164 -rw-rw-r-- 1 hui hui 78074 Jul 27 2021 clickhouse-client-21.7.3.14-2.noarch.rpm -rw-rw-r-- 1 hui hui 174283244 Jul 27 2021 clickhouse-common-static-21.7.3.14-2.x86_64.rpm -rw-rw-r-- 1 hui hui 786208040 Jul 27 2021 clickhouse-common-static-dbg-21.7.3.14-2.x86_64.rpm -rw-rw-r-- 1 hui hui 101969 Jul 27 2021 clickhouse-server-21.7.3.14-2.noarch.rpm
2.2、安装 rpm 文件
[root@hadoop201 clickhouse]# rpm -ivh *.rpm
2.3、配置
配置其它主机可以访问clickhouse服务——远程访问
[hui@hadoop201 software]$ sudo vim /etc/clickhouse-server/config.xml
把 <listen_host>::</listen_host> 的注释打开，这样的话才能让ClickHouse被除本机以外的服务器访问
安装后路径说明
bin/ ==> /usr/bin/ conf/ ==> /etc/clickhouse-server/ lib/ ==> /var/lib/clickhouse/ lib 也存放数据 log/ ==> /var/log/clickhouse/
config.xml 一些配置说明
<listen_host>::</listen_host> #远程主机可防问当前clickhouse服务 <!-- Path to data directory, with trailing slash. 数据目录 --> <path>/var/lib/clickhouse/</path> <log>/var/log/clickhouse-server/clickhouse-server.log</log> 日志 <errorlog>/var/log/clickhouse-server/clickhouse-server.err.log</errorlog> 错误日志
配置文件说明
[root@hadoop201 clickhouse-server]# pwd
/etc/clickhouse-server
[root@hadoop201 clickhouse-server]# ll
total 64
dr-x------ 2 clickhouse clickhouse 6 Aug 2 08:35 config.d 默认配置
-r-------- 1 clickhouse clickhouse 56004 Aug 6 16:40 config.xml 服务端配置
dr-x------ 2 clickhouse clickhouse 6 Aug 2 08:24 users.d 用户密码权限CPU内存在这里配置
-r-------- 1 clickhouse clickhouse 6053 Jul 14 2021 users.xml 默认配置
2.4、启动
[root@hadoop201 clickhouse]# clickhouse start chown --recursive clickhouse '/var/run/clickhouse-server/' Will run su -s /bin/sh 'clickhouse' -c '/usr/bin/clickhouse-server --config-file /etc/clickhouse-server/config.xml --pid-file /var/run/clickhouse-server/clickhouse-server.pid --daemon' Waiting for server to start Waiting for server to start Server started
此时ClickHouse 已经启动
[root@hadoop201 clickhouse]# clickhouse status /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 3154. The process with pid = 3154 is running.
clickhouse 默认端口 9000，如和现有端口冲突，建议修改。配置文件在 /etc/clickhouse-server/config.xml
2.5、连接测试
[root@hadoop201 clickhouse]# clickhouse-client -m ClickHouse client version 21.7.3.14 (official build). Connecting to localhost:9000 as user default. Connected to ClickHouse server version 21.7.3 revision 54449. hadoop201 :) show databases; SHOW DATABASES Query id: f052da3a-a091-4bf5-95cd-e6045db2f6cb ┌─name────┐ │ default │ │ system │ └─────────┘ 2 rows in set. Elapsed: 0.005 sec.
至此,CLickHouse 安装完毕。
