战斗民族的ClickHouse安装异常及应对及升级

偶然接触ClickHouse这种快速开源的OLAP列式数据库管理系统，就按照随手搜索的帖子操作，看ClickHouse官网上打了会酱油，看了看文档，貌似太深奥，就直奔installation，可是文档太专业，从环境检测到Deb安装、Rpm安装、Tgz安装，最后还有Docker安装，也不确定那种方式靠谱，就找了偏步骤比较详细的帖子操练了起来

稳定版有两套，就选择了较高的版本，打算试吃一下。

第一步：下载安装包

clickhouse-server-common-1.1.54236-4.el7.x86_64.rpm
clickhouse-client-1.1.54236-4.el7.x86_64.rpm
clickhouse-server-1.1.54236-4.el7.x86_64.rpm

第二步：上传云主机

CPU&内存        1核2 GiB
操作系统        CentOS 7.9 64位
实例规格        ecs.n4.small
实例规格族      共享计算型
云盘            1
快照            0
镜像ID          centos_7_9_x64_20G_alibase_20210420.vhd
当前使用带宽    1Mbps

sftp:/opt/software/clickhouse> ls
-rw-r--r--    1 root     root         8164 Jul 21 18:12 clickhouse-server-common-1.1.54236-4.el7.x86_64.rpm
drwxr-xr-x    2 root     root         4096 Jul 21 18:12 .
-rw-r--r--    1 root     root         3048 Jul 21 18:12 clickhouse-client-1.1.54236-4.el7.x86_64.rpm
-rw-r--r--    1 root     root     33680608 Jul 21 18:12 clickhouse-server-1.1.54236-4.el7.x86_64.rpm
drwxr-xr-x    4 root     root         4096 Jul 21 18:11 ..

第三步：开始安装（然而报错了）

[root@yaong clickhouse]# rpm -ivh ./clickhouse*.rpm
error: Failed dependencies:
	libicudata.so.50()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64
	libicui18n.so.50()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64
	libicuuc.so.50()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64
	libltdl.so.7()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64
	libodbc.so.2()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64

第四步：搜索相似案例，解决一下   yum -y install unixODBC

[root@yaong clickhouse]# yum -y install unixODBC

第五步：再尝试安装，还有依赖异常

[root@yaong clickhouse]# rpm -ivh ./clickhouse*.rpm
error: Failed dependencies:
	libicudata.so.50()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64
	libicui18n.so.50()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64
	libicuuc.so.50()(64bit) is needed by clickhouse-server-1.1.54236-4.el7.x86_64

第六步：搜索相似案例，再解决一下   yum install libicu.x86_64

[root@yaong clickhouse]# yum search libicu
[root@yaong clickhouse]# yum install libicu.x86_64

最终：安装成功

[root@yaong clickhouse]# rpm -ivh ./clickhouse*.rpm
Preparing