我的世界做图的网站,网站相互推广怎么做,页面模板 公众号,wordpress淘宝客开发ClickHouse是一个用于联机分析#xff08;OLAP#xff09;的列式数据库管理系统#xff08;DBMS#xff09;#xff0c;来自于俄罗斯本土搜索引擎企业Yandex公司。它是为处理大规模数据集而设计的#xff0c;并提供高性能和低延迟的查询支持。 注意#xff1a;此教程的运… 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-server3.删除clickhouse所有解压过的安装包
cd /opt/module/clickhouse/ # 此教程将安装包解压至/opt/module/clickhouse/
rm -rf ./*离线安装clickhouse
1、首先准备安装clickhouse所需的安装包 此教程放在了/opt/software/clickhouse/中
[rootbigdata1 clickhouse]# cd /opt/software/clickhouse/
[rootbigdata1 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.tgz2、将所有安装包解压至目标目录
cd /opt/software/clickhouse/for i in /opt/software/clickhouse/*;do tar -zxf $i -C /opt/module/clickhouse/;done[rootbigdata1 clickhouse]# cd /opt/module/clickhouse/[rootbigdata1 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_host0.0.0.0/listen_host (如果服务器支持ipv6则不需要改)
vim /etc/clickhouse-server/config.d/listen.xmlyandexlisten_host0.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[rootbigdata1 clickhouse]# cat -n /etc/clickhouse-server/config.xml | grep 900182 tcp_port9001/tcp_port622 port9001/port632 port9001/port638 port9001/port646 port9001/port652 port9001/port661 port9001/port668 port9001/port685 port9001/port5、启动服务并查看服务状态
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
[rootbigdata1 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.
