Clickhouse 21.9.4.35 离线安装配置
安装
解压安装包
解压Clickhouse四个压缩包,到/opt/module/clickhouse下
tar -zxvf /opt/software/clickhouse-server-21.9.4.35.tgz -C /opt/module/clickhouse
tar -zxvf /opt/software/clickhouse-common-static-21.9.4.35.tgz -C /opt/module/clickhouse
tar -zxvf /opt/software/clickhouse-common-static-dbg-21.9.4.35.tgz -C /opt/module/clickhouse
tar -zxvf /opt/software/clickhouse-client-21.9.4.35.tgz -C /opt/module/clickhouse运行脚本
运行每个文件夹下install/doinst.sh脚本
./clickhouse-server-21.9.4.35/install/doinst.sh
./clickhouse-client-21.9.4.35/install/doinst.sh
./clickhouse-common-static-21.9.4.35/install/doinst.sh
./clickhouse-common-static-dbg-21.9.4.35/install/doinst.sh在安装clickhouse-server的时候会提示设置默认密码,无密码直接回车即可
修改配置文件
默认Hadoop已经占用9000端口了,这里将Clickhouse 的tcp_port 改为 9001
配置文件在/etc/clickhouse-server下
cd /etc/clickhouse-server如果config.d有默认 listen.xml 文件则需要删除listen.xml没有就不用删
rm /etc/clickhouse-server/config.d/listen.xml修改根目录的config.xml文件,修改配置项tcp_port(82行)
<tcp_port>9001</tcp_port>
修改根目录的config.xml文件,修改配置项listen_host(157行)
添加或去除注释
<listen_host>0.0.0.0</listen_host>修改完成后保存退出
运行
启动clickhouse-server
systemctl start clickhouse-server查看clickhouse-server状态
systemctl status clickhouse-server客户端连接
运行clickhouse client(有密码输入密码)
clickhouse client --port 9001
clickhouse-client --port 9001