clickhouse卸载重装

1. 卸载及删除安装文件

• yum list installed | grep clickhouse
• yum remove -y clickhouse-common-static
• yum remove -y clickhouse-server-common
• rm -rf /var/lib/clickhouse
• rm -rf /etc/clickhouse-*
• rm -rf /var/log/clickhouse-server

2.下载rpm包

https://packagecloud.io/app/Altinity/clickhouse/search?

3. 安装

• yum install -y clickhouse-common-static-18.12.17-1.el7.x86_64.rpm
• yum install -y clickhouse-server-common-18.12.17-1.el7.x86_64.rpm
• yum install -y clickhouse-server-18.12.17-1.el7.x86_64.rpm
• yum install -y clickhouse-client-18.12.17-1.el7.x86_64.rpm

 

4. 启动服务

service clickhouse-server start

5. 查询服务状态

service clickhouse-server status

6.判断client端口是否被占用，默认为9000

netstat -tunlp|grep 9000

占用则可以修改server的配置文件。

7.开启访问权限

修改server的配置文件

 

8.剩余的是一些内存设置调整