新版Clickhouse 的安装部署

示例版本21.3.3

环境检查

grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"

显示：SSE 4.2 supported，则环境支持

下载安装（单机模式）

1. 安装依赖

yum install -y curl
yum install -y libtool

2. 添加Clickhouse 的yum镜像

curl -s https://packagecloud.io/install/repositories/altinity/clickhouse/script.rpm.sh | sudo bash

3. 检查镜像情况

yum list installed | grep clickhouse

4. 安装 server client

yum install -y clickhouse-server 
yum install -y clickhouse-client

5. 启动server

systemctl start clickhouse-server

6. 查看server端服务状态

systemctl status clickhouse-server

7. 启动client CLI

clickhouse-client
clickhouse-client -m #可以在命令窗口输入多行命令

8. 停止

systemctl stop clickhouse-server

修改配置文件（可选）

外网访问

vim /etc/clickhouse-server/config.xml

把 <listen_host>::</listen_host> 的注释打开，这样的话才能让ClickHouse被除本机以外的服务器访问

如果禁用了ipv6，使用下面配置

<listen_host>0.0.0.0</listen_host>

修改默认目录

• 服务端的配置目录：/etc/clickhouse-server
• 数据文件路径：var/lib/clickhouse <path>/var/lib/clickhouse/</path>
• 日志文件路径： /var/log/clickhouse-server/ 如<log>/var/log/clickhouse-server/clickhouse-server.log
  存储和日志需要建议修改为非系统盘，其他默认即可

卸载

查看安装

yum list installed | grep clickhouse
clickhouse-client.noarch               21.3.3.14-2                     @repo.clickhouse.tech_rpm_stable_x86_64
clickhouse-common-static.x86_64        21.3.3.14-2                     @repo.clickhouse.tech_rpm_stable_x86_64
clickhouse-server.noarch               21.3.3.14-2                     @repo.clickhouse.tech_rpm_stable_x86_64

卸载并删除目录

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*

参考资料

• https://clickhouse.tech/#quick-start
• https://clickhouse.tech/docs/zh/getting-started/install/#from-rpm-packages
• https://github.com/ClickHouse/ClickHouse/issues/14861