Clickhouse安装部署
1、Clickhouse Yum在线安装安装
(1)、安装管理repository及扩展包的工具
[root@0001 ~]# yum install yum-utils
(2)、添加yum源
[root@0001 ~]# rpm –import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
[root@0001 ~]# yum-config-manager –add-repo https://repo.clickhouse.tech/rpm/clickhouse.repo
(3)、安装clickhouse-server clickhouse-client
[root@0001 ~]# yum install clickhouse-server clickhouse-client
2、Clickhouse RPM包离线安装
![图片[2]-Clickhouse20 Yum部署-飞翔沫沫情](https://www.fxkjnj.com/wp-content/uploads/2021/09/9f491404feefcc30b90747ae31a2cb19_89f31be3-c1c3-4daf-85a2-2e7e4dc4fdd7.png)
3、Clickhouse 配置
(1)、配置客户端连接密码,监听地址
[root@0001 ~]# vim /etc/clickhouse-server/users.xml
<password>helloword@2021</password>
[root@0001 ~]# vim /etc/clickhouse-server/config.xml
#搜索0.0.0.0 ,然后粘贴下面的内容
<listen_host>::</listen_host>
(2)、创建软连接配置数据路径,日志路径
clickhouse安装后,默认的数据目录在/var/lib/clickhouse,将其改到/data/clickhouse/ , 注意提前挂载好磁盘
[root@0001 ~]# mkdir -p /data/clickhouse/
[root@0001 ~]# rm -rf /var/lib/clickhouse/
[root@0001 ~]# ln -s /data/clickhouse/ /var/lib/
clickhouse安装后,默认日志目录在/var/log/clickhouse-server,将其改到 /data/clickhouse-server/ , 注意提前挂载好磁盘
[root@0001 ~]# mkdir -p /data/clickhouse-server/
[root@0001 ~]# rm -rf /var/log/clickhouse-server
[root@0001 ~]# ln -s /data/clickhouse-server/ /var/log/
(3)、赋予clickhouse 目录权限
[root@0001 ~]# chown -Rf clickhouse:clickhouse /data/clickhouse
[root@0001 ~]# chown -Rf clickhouse:clickhouse /data/clickhouse-server
(4)、启动clickhouse-server数据库
[root@0001 ~]# systemctl start clickhouse-server
(8)、客户端clickhouse-client 登陆,密码 helloword@2021
[root@0001 ~]# clickhouse-client –password
ClickHouse client version 20.4.6.53 (official build).
Password for user (default):
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 20.4.6 revision 54434.
0001 🙂 exit
Bye.
4、 Clickhouse项目部署路径及启停方式
(1)、项目路径:
Clickhouse数据路径: /data/clickhouse/
Clickhouse日志路径: /data/clickhouse-server/
配置文件: /etc/clickhouse-server/
(2)、启停方式:
启动: systemctl start clickhouser-server
停止:systemctl stop clickhouser-server
(3)、其他:
服务端口: 【8123,9000,9004,9009】
运行用户: 【clickhouse】
- 最新
- 最热
只看作者