一、安装clickhouse
1.使用Xshell工具上传clickhouse安装包到/opt/software目录下:
2.在/opt/software目录下使用tar命令解压到/opt/module目录下,每解压一个文件就执行一次该文件:
tar -zxvf clickhouse-common-static-21.9.6.24.tgz -C /opt/module
../module/clickhouse-common-static-21.9.6.24/install/doinst.sh
tar -zxvf clickhouse-common-static-dbg-21.9.6.24.tgz -C /opt/module
../module/clickhouse-common-static-dbg-21.9.6.24/install/doinst.sh
tar -zxvf clickhouse-server-21.9.6.24.tgz -C /opt/module
../module/clickhouse-server-21.9.6.24/install/doinst.sh
注:这里不需要设置密码直接回车。
tar -zxvf clickhouse-client-21.9.6.24.tgz -C /opt/module
../module/clickhouse-client-21.9.6.24/install/doinst.sh
3.启动clickhouse:
systemctl start clickhouse-server.service
4.查看clickhouse运行状态:
systemctl status clickhouse-server.service
执行结果如下:
clickhouse安装成功!
二、配置远程访问
1.打开/etc/clickhouse-server/config.xml文件:
vim /etc/clickhouse-server/config.xml
2.找到<listen_host>0.0.0.0</listen_host>并解除注释:
3.将此文件中9000全部改为9001。
4.重启clickhouse服务:
systemctl restart clickhouse-server.service
5.再次查看clickhouse运行状态:
systemctl status clickhouse-server.service
执行结果如下:
远程访问配置成功!