文章目录


1.准备工作

1.1 打开相关端口或关闭防火墙

1.2 关闭SELinux

vi /etc/selinux/confi
###################################################
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
# SELINUX=enforcing
SELINUX=diable # 默认是enforcing打开状态,修改为disable关闭selinux
# SELINUXTYPE= can take one of three values:
# targeted - Targeted processes are protected,
# minimum - Modification of targeted policy. Only selected processes are protected.
# mls - Multi Level Security protection.
SELINUXTYPE=targeted

1.3 取消打开文件限制

​vi /etc/security/limits.conf​

* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072

​vi /etc/security/limits.d/20-nproc.conf​

* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072

1.4 安装依赖

sudo yum -y install libtool
sudo yum -y install *unixODBC*

ClickHouse-2_安装_OLAP
在软件安装位置创建目录:​​​mkdir clickhouse​​​ 将上面4个文件上传到创建的目录下
在创建的目录下执行安装命令:​​sudo rpm -ivh *.rpm​​ 运行完成后,查看安装情况:​​sudo rpm -qa | grep clickhouse​

ClickHouse-2_安装_大数据_02
接下来修改配置文件​​​vi /etc/clickhouse-server/config.xml​​ 将<listen_host>::</listen_host>的注释打开(该项配置表示可以在任意IP访问服务)

ClickHouse-2_安装_ClickHouse_03
保存配置,接下来就可以开启CK服务了:​​​systemctl start clickhouse-server(clickhouse start)​​​ 可以改用status查看运行状态:​​systemctl status clickhouse-server(clickhouse status)​

ClickHouse-2_安装_OLAP_04

1.5 启动客户端

启动客户端,进入CK命令行:​​clickhouse-client -m​​​(可以使用–help查看可配置项,如–host配置主机IP,–port配置端口,–user配置用户名,–password配置登录密码等)
ClickHouse-2_安装_大数据_05
可以看到,CK默认有两个数据库,system库存放系统相关数据和元数据表格,default库是默认库,当不指定库建表时会存放在该库中。

若客户端无法正常启动,除了查看正常的IP端口用户名密码外,可以注意下CK的日志和错误日志文件权限问题,如果当前用户没有日志文件的操作权限的话,会有连接请求被拒绝的情况
RPM安装模式日志文件位置:​​​/var/log/clickhouse-server/​​​ClickHouse-2_安装_大数据_06
可选择关闭开机自启:​​systemctl disable clickhouse-server​

按照以上步骤在另外两台结点安装ClickHouse,便于后续演示集群功能