rpm包下载地址:https://repo.yandex.ru/clickhouse/rpm/stable/x86_64/
官网下载地址:https://clickhouse.tech/#quick-start
- yum安装
sudo yum install yum-utils
sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/clickhouse.repo
sudo yum install clickhouse-server clickhouse-client
sudo /etc/init.d/clickhouse-server start
clickhouse-client
- 修改数据目录
进入包下面的etc/clickhouse-server目录
修改config.xml文件,把所有路径改成你要的路径
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-9bN7DhQU-1634634214157)(http://192.168.10.61:9001/server/…/Public/Uploads/2021-05-06/60935c296fdac.png)]
登录时报错误
错误原因:
/etc/init.d/clickhouse-server start命令没有启动成功
使用systemctl启动成功
- Clickhouse连接端口默认8123,但是Clickhouse默认情况下不允许其他设备进行http连接,所以需要更改clickhouse的默认配置:
[root@master local]# vim /etc/clickhouse-server/config.xml
新增一行,默认是注释的,让本地服务可以远程连接远程部署的Clickhouse服务,如下所示:
如果不添加上面的配置,远程连接,报下面的错误,如下所示:
1 Unexpected driver error occurred while connecting to the database
2 ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 210, host: 192.168.110.133, port: 8123; Connect to 192.168.110.133:8123 [/192.168.110.133] failed: Connection refused: connect
3 ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 210, host: 192.168.110.133, port: 8123; Connect to 192.168.110.133:8123 [/192.168.110.133] failed: Connection refused: connect
4 ClickHouse exception, code: 210, host: 192.168.110.133, port: 8123; Connect to 192.168.110.133:8123 [/192.168.110.133] failed: Connection refused: connect
5 ClickHouse exception, code: 210, host: 192.168.110.133, port: 8123; Connect to 192.168.110.133:8123 [/192.168.110.133] failed: Connection refused: connect
6 Connect to 192.168.110.133:8123 [/192.168.110.133] failed: Connection refused: connect
7 Connect to 192.168.110.133:8123 [/192.168.110.133] failed: Connection refused: connect
8 Connection refused: connect
9 Connection refused: connect