CentOS安装clickhouse

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