shells/clickhouse.sh

 

#!/bin/bash
case $1 in
"start"){
clickhouse-client -m --port=9000 -u default --password root
};;
"server-start"){
#.启动服务
service clickhouse-server start
};;
"server-stop"){
#.停止服务
service clickhouse-server stop
};;
"restart"){
systemctl restart clickhouse-server.service
};;
"open-port"){
# 开放端口
firewall-cmd --zone=public --add-port=8123/tcp --permanent
# 配置生效
firewall-cmd --reload
};;
"close-port"){
#关闭端口
firewall-cmd --zone=public --remove-port=8123/tcp --permanent
# 配置生效
firewall-cmd --reload
};;
"port-list"){
#查看端口
firewall-cmd --zone=public --list-ports
};;
esac;