ClickHouse单节点安装与部署

可乐可乐乐～

已于 2022-08-17 16:51:48 修改

阅读量321

点赞数

分类专栏： ClickHouse 文章标签： clickhouse

于 2022-08-17 14:32:57 首次发布

本文链接：https://blog.csdn.net/lidepan/article/details/126384792

版权

ClickHouse 专栏收录该内容

8 篇文章 1 订阅

订阅专栏

下载安装包

地址：

https://repo.yandex.ru/clickhouse/rpm/stable/x86_64/
https://packagecloud.io/altinity/clickhouse

下载以下四个安装包文件：（这里用的是19.17.4.11版本）

clickhouse-client-19.17.4.11-1.el7.x86_64.rpm
clickhouse-common-static-19.17.4.11-1.el7.x86_64.rpm

clickhouse-server-19.17.4.11-1.el7.x86_64.rpm
clickhouse-server-common-19.17.4.11-1.el7.x86_64.rpm

上传安装包

将四个安装包上传到三台机器的/home/software/clickhouse文件夹中

安装ClickHouse

[root@vm01 clickhouse]# ls
clickhouse-client-19.17.4.11-1.el7.x86_64.rpm         clickhouse-server-19.17.4.11-1.el7.x86_64.rpm
clickhouse-common-static-19.17.4.11-1.el7.x86_64.rpm  clickhouse-server-common-19.17.4.11-1.el7.x86_64.rpm
[root@vm01 clickhouse]#  rpm -ivh ./*.rpm
Preparing... ################################# [100%]
Updating / installing...
1:clickhouse-server-common-19.17.4.################################# [ 25%]
2:clickhouse-common-static-19.17.4.#######...

启动ClickHouse

[root@vm01 clickhouse]#  service clickhouse-server start
Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /var/lib/clickhouse/
DONE

测试

[root@vm01 cron.d]# clickhouse-client
ClickHouse client version 19.17.4.11.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 19.17.4 revision 54428.

vm01 :) show databases;

SHOW DATABASES

┌─name────┐
│ default │
│ system  │
└─────────┘

2 rows in set. Elapsed: 0.002 sec.

说明：clickhouse-client -h 10.16.3.xx -d default -u default --port 9123

clickhouse-client命令后可加-h表示连接的服务地址，--port表示clickhouse的端口号，默认9000，-d是连接的某个数据库，-u是登入用户名，--password是登入密码，默认是没有的，想要设置可以在/etc/clickhouse-server/users.xml中修改