滁州商业网站建设3090服务器租用

ClickHouse是一个用于联机分析（OLAP）的列式数据库管理系统（DBMS），来自于俄罗斯本土搜索引擎企业Yandex公司。它是为处理大规模数据集而设计的，并提供高性能和低延迟的查询支持。

注意：此教程的运行环境为CentOS7

卸载clickhouse

如果没有安装过clickhouse可以跳转至安装部分

1.首先查看 clickhouse-server 服务状态 如果服务是开启的 请关闭它

systemctl status clickhouse-server  # 查看服务状态
systemctl stop clickhouse-server    # 关闭服务

2.删除之前安装过clickhouse产生的目录和文件

rm -rf /var/lib/clickhouse
rm -rf /etc/clickhouse-*
rm -rf /var/log/clickhouse-server

3.删除clickhouse所有解压过的安装包

cd /opt/module/clickhouse/  # 此教程将安装包解压至/opt/module/clickhouse/ 
rm -rf ./*

离线安装clickhouse

1、首先准备安装clickhouse所需的安装包
此教程放在了/opt/software/clickhouse/中

[root@bigdata1 clickhouse]# cd /opt/software/clickhouse/
[root@bigdata1 clickhouse]# ll
total 1020904
-rw-r--r-- 1 root root     82788 Apr 29  2022 clickhouse-client-21.9.4.35.tgz
-rw-r--r-- 1 root root 188699225 Apr 29  2022 clickhouse-common-static-21.9.4.35.tgz
-rw-r--r-- 1 root root 856509550 Apr 29  2022 clickhouse-common-static-dbg-21.9.4.35.tgz
-rw-r--r-- 1 root root    103467 Apr 29  2022 clickhouse-server-21.9.4.35.tgz

2、将所有安装包解压至目标目录

cd /opt/software/clickhouse/for i in /opt/software/clickhouse/*;do tar -zxf $i -C /opt/module/clickhouse/;done[root@bigdata1 clickhouse]# cd /opt/module/clickhouse/[root@bigdata1 clickhouse]# ll
total 0
drwxr-xr-x 5 root root 43 Sep 23  2021 clickhouse-client-21.9.4.35
drwxr-xr-x 4 root root 32 Sep 23  2021 clickhouse-common-static-21.9.4.35
drwxr-xr-x 4 root root 32 Sep 23  2021 clickhouse-common-static-dbg-21.9.4.35
drwxr-xr-x 6 root root 54 Sep 23  2021 clickhouse-server-21.9.4.35

3、严格按照顺序执行安装脚本

cd /opt/module/clickhouse/clickhouse-common-static-21.9.4.35/install/doinst.shclickhouse-common-static-dbg-21.9.4.35/install/doinst.shclickhouse-server-21.9.4.35/install/doinst.shclickhouse-client-21.9.4.35/install/doinst.sh

执行到第三个安装脚本时会要求设置default用户的密码，可设置为123456

还会要求输入y/n:Allow server to accept connections from the network (default is localhost only), [y/N] ,这里推荐填y

4、修改配置文件

首先需要修改/etc/clickhouse-server/config.d/listen.xml
将<listen_host>::</listen_host> 修改为 <listen_host>0.0.0.0</listen_host> (如果服务器支持ipv6则不需要改)

vim /etc/clickhouse-server/config.d/listen.xml<yandex><listen_host>0.0.0.0</listen_host>
</yandex>

然后需要修改/etc/clickhouse-server/config.xml

将第82、622、632、638、646、652、661、668、685行的9000修改为9001
，因为9000端口会和hdfs的端口冲突

vim /etc/clickhouse-server/config.xml[root@bigdata1 clickhouse]# cat -n /etc/clickhouse-server/config.xml  | grep 900182      <tcp_port>9001</tcp_port>622                      <port>9001</port>632                       <port>9001</port>638                       <port>9001</port>646                      <port>9001</port>652                      <port>9001</port>661                      <port>9001</port>668                      <port>9001</port>685                      <port>9001</port>

5、启动服务并查看服务状态

systemctl start 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 Fri 2024-05-10 20:55:18 CST; 5s agoMain PID: 17660 (clckhouse-watch)CGroup: /docker/9c3a9bea4923101aab063d7028419e9d0e5d812f6d5bacc91922eb1f310dcdf2/system.slice/clickhouse-server.service├─17660 clickhouse-watchdog --config=/etc/clickhouse-server/config.xml --pid-file=/run/clickho...└─17661 /usr/bin/clickhouse-server --config=/etc/clickhouse-server/config.xml --pid-file=/run/...‣ 17660 clickhouse-watchdog --config=/etc/clickhouse-server/config.xml --pid-file=/run/clickho...

安装完成~

输入clickhouse-client --port 9001 --password 即可进入clickhouse

[root@bigdata1 clickhouse]# clickhouse-client --port 9001 --password
ClickHouse client version 21.9.4.35 (official build).
Password for user (default):
Connecting to localhost:9001 as user default.
Connected to ClickHouse server version 21.9.4 revision 54449.