04 - Clickhouse-21.7.3.14-2单机版安装

目录

一、准备工作

1、确定防火墙处于关闭状态

2、CentOS 取消打开文件数限制

3、安装依赖

4、CentOS取消SELINUX

二、单机安装

2.1、下载安装

2.2、安装这4个rpm包

2.3、修改配置文件

2.4、启动服务

2.5、关闭开机自启

2.6、使用Client连接server

---

一、准备工作

1、确定防火墙处于关闭状态

[root@hallo102 ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemonLoaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)Active: inactive (dead)Docs: man:firewalld(1)
[root@hallo102 ~]#

2、CentOS 取消打开文件数限制

在 /etc/security/limits.conf 文件的末尾加入以下内容

* soft nofile 65536 
* hard nofile 65536 
* soft nproc 131072 
* hard nproc 131072 

• 第一列是限制的用户和用户组
• soft软限制，hard硬限制
• nofile打开文件数，nproc用户进程数

在/etc/security/limits.d/20-nproc.conf文件的末尾加入以下内容

* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072

退出当前用户，重启登录，ulimit -a查看打开文件数和用户进程数是否更改

[root@hallo102 ~]# 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) 11687
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
[root@hallo102 ~]#

3、安装依赖

[root@hallo102 ~]# yum install -y libtool

[root@hallo102 ~]# yum install -y *unixODBC*

4、CentOS取消SELINUX

[root@hallo102 ~]# vim /etc/selinux/config

SELINUX=disabled

修改完重启服务器

二、单机安装

官网：https://clickhouse.tech/

下载地址：https://repo.yandex.ru/clickhouse/rpm/stable/x86_64/

2.1、下载安装

需要以下四个rpm包：

clickhouse-client-21.7.3.14-2.noarch.rpm
clickhouse-common-static-21.7.3.14-2.x86_64.rpm
clickhouse-common-static-dbg-21.7.3.14-2.x86_64.rpm
clickhouse-server-21.7.3.14-2.noarch.rpm

2.2、安装这4个rpm包

[root@hallo102 clickhouse]# rpm -ivh *.rpm

[root@hallo102 clickhouse]# ll
总用量 938164
-rw-r--r-- 1 root root     78074 11月 16 21:40 clickhouse-client-21.7.3.14-2.noarch.rpm
-rw-r--r-- 1 root root 174283244 11月 16 21:40 clickhouse-common-static-21.7.3.14-2.x86_64.rpm
-rw-r--r-- 1 root root 786208040 11月 16 21:40 clickhouse-common-static-dbg-21.7.3.14-2.x86_64.rpm
-rw-r--r-- 1 root root    101969 11月 16 21:40 clickhouse-server-21.7.3.14-2.noarch.rpm
[root@hallo102 clickhouse]# rpm -ivh *.rpm

2.3、修改配置文件

[root@hallo102 clickhouse]# cd /etc/clickhouse-server/
[root@hallo102 clickhouse-server]# chmod 777 config.xml
[root@hallo102 clickhouse-server]# ls
config.d  config.xml  users.d  users.xml
[root@hallo102 clickhouse-server]# vim config.xml

把<listen_host>0.0.0.0</listen_host>的注释打开，这样的话才能让ClickHouse被除本机之外的服务器访问

这个配置文件中，ClickHouse一些默认路径配置：

• 数据文件路径：<path>/var/lib/clickhouse/</path>
• 日志文件路径：<log>/var/log/clickhouse-server/clickhouse-server.log</log>

2.4、启动服务

[root@hallo102 clickhouse-server]# systemctl start clickhouse-server

或者

[root@hallo102 clickhouse-server]# clickhouse start

[root@hallo102 clickhouse-server]# systemctl status clickhouse-server
● clickhouse-server.service - ClickHouse Server (analytic DBMS for big data)Loaded: loaded (/etc/systemd/system/clickhouse-server.service; enabled; vendor preset: disabled)Active: active (running) since 六 2024-11-16 21:59:16 CST; 3s agoMain PID: 2343 (clckhouse-watch)Tasks: 157CGroup: /system.slice/clickhouse-server.service├─2343 clickhouse-watchdog --config=/etc/clickhouse-server/config.xml --pid-file=/run/clickhouse-server/clickhouse-server.pid└─2346 /usr/bin/clickhouse-server --config=/etc/clickhouse-server/config.xml --pid-file=/run/clickhouse-server/clickhouse-server.pid11月 16 21:59:16 hallo102 systemd[1]: Started ClickHouse Server (analytic DBMS for big data).
11月 16 21:59:16 hallo102 systemd[1]: Starting ClickHouse Server (analytic DBMS for big data)...
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Processing configuration file '/etc/clickhouse-server/config.xml'.
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Logging trace to /var/log/clickhouse-server/clickhouse-server.log
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Processing configuration file '/etc/clickhouse-server/config.xml'.
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Processing configuration file '/etc/clickhouse-server/users.xml'.
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
[root@hallo102 clickhouse-server]#

2.5、关闭开机自启

[root@hallo102 clickhouse-server]# systemctl disable clickhouse-server
Removed symlink /etc/systemd/system/multi-user.target.wants/clickhouse-server.service.
[root@hallo102 clickhouse-server]#

2.6、使用Client连接server

[root@hallo102 clickhouse-server]# 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.hallo102 :) show databases;SHOW DATABASESQuery id: 29827428-607c-42d3-84f7-24333732908c┌─name────┐
│ default │
│ system  │
└─────────┘2 rows in set. Elapsed: 0.006 sec.hallo102 :)