可能出现的问题
如果无法启动,大概率为权限问题,如果测试环境,将使用到的目录改为777,如果正式环境,改为拥有者为clickhouse再次尝试
IP |
---|
192.168.0.81 |
192.168.0.102 |
192.168.0.103 |
1 准备工作
1.1 CentOS 取消打开文件数限制 (所有机器)
在 /etc/security/limits.conf 的末尾分别加入以下内容:
[root@ch1 ~]# vim /etc/security/limits.conf
在文件末尾添加:
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
1.2 CentOS 取消 SELINUX (所有机器)
修改 /etc/selinux/config 中的 SELINUX=disabled 后重启
[root@ch1 ~]# vim /etc/selinux/config
# 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=disabled
# SELINUXTYPE= can take one of these two values:
# targeted - Targeted processes are protected,
# mls - Multi Level Security protection.
SELINUXTYPE=targeted
1.3 关闭防火墙 (所有机器)
[root@ch1 ~]# systemctl stop firewalld.service
[root@ch1 ~]# systemctl disable firewalld.service
1.4 安装依赖 (所有机器)
sudo yum install yum-utils
sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/clickhouse.repo
2 Zookeeper 安装
Zookeeper 需要安装奇数台来安装
2.1 下载zookeeper (所有机器)
mkdir /usr/local/zookeeper
cd /usr/local/zookeeper
wget https://mirrors.cnnic.cn/apache/zookeeper/zookeeper-3.4.14/zookeeper-3.4.14.tar.gz
tar -xvf zookeeper-3.4.14.tar.gz
2.2 创建配置 (所有机器)
cp /usr/local/zookeeper/zookeeper-3.4.14/conf/zoo_sample.cfg /usr/local/zookeeper/zookeeper-3.4.14/conf/zoo.cfg
2.3 修改配置参数 (所有机器)
vim /usr/local/zookeeper/zookeeper-3.4.14/conf/zoo.cfg
dataDir=/home/apps/zookeeper/data
dataLogDir=/home/apps/zookeeper/logs
server.1=ip1:2888:3888
server.2=ip2:2888:3888
server.3=ip3:2888:3888
2.4 每台创建不一样的server id标识 (所有机器)
# /tmp在linux中是临时目录,linux会对此目录定期清理,所以需要修改此目录
[root@ch1 ~]# mkdir -p /home/apps/zookeeper/data
[root@ch1 ~]# mkdir -p /home/apps/zookeeper/logs
[root@ch1 ~]# touch /home/apps/zookeeper/data/myid
[root@ch1 ~]# vim /home/apps/zookeeper/data/myid
# ip1输入1, ip2输入2, ip3输入3
2.5 启动zk (所有机器)
/usr/local/zookeeper/zookeeper-3.4.14/bin/zkServer.sh start
# 查看状态
/usr/local/zookeeper/zookeeper-3.4.14/bin/zkServer.sh status
3 分布式安装
3.1 安装 (所有机器)
[root@ch1 ~]# sudo yum install clickhouse-server clickhouse-client
3.2 修改配置文件 config.xml (所有机器)
#日志存放位置 根据个人所需修改
<log>/var/log/clickhouse-server/clickhouse-server.log</log>
<errorlog>/var/log/clickhouse-server/clickhouse-server.err.log</errorlog>
#数据目录 个人所需修改
<path>/var/lib/clickhouse/</path>
<tmp_path>/var/lib/clickhouse/tmp/</tmp_path>
#允许被访问 放开注释
<listen_host>::</listen_host>
#映射(可选)
<remote_servers incl="clickhouse_remote_servers">
<zookeeper incl="zookeeper-servers" optional="true" />
<macros incl="macros" optional="true" />
<include_from>/etc/clickhouse-server/metrika.xml</include_from&