CentOS7下搭建ClickHouse集群

cd /opt
rz上传clickhouse.zip
unzip clickhouse.zip
#所在节点执行对应的安装脚本
#例如node1执行sh jdk_zookeeper_clickhouse_node1.sh 
sh jdk_zookeeper_clickhouse_node1.sh 

[root@node1 opt]# cat jdk_zookeeper_clickhouse_node1.sh 
#!/bin/bash
#wget -O /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo
#sed -i -e '/mirrors.cloud.aliyuncs.com/d' -e '/mirrors.aliyuncs.com/d' /etc/yum.repos.d/CentOS-Base.repo
#wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo
#yum clean all
#yum makecache
echo "-----------基础环境配置----------------"
setenforce 0
sed -i 's/^SELINUX=.*$/SELINUX=disabled/' /etc/selinux/config
systemctl disable firewalld
systemctl stop firewalld

cat >> /etc/security/limits.conf << EOF
* soft nofile 65536 
* hard nofile 65536 
* soft nproc 131072 
* hard nproc 131072
EOF

cat >> /etc/security/limits.d/90-nproc.conf << EOF
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
EOF

cat >> /etc/hosts << EOF
192.168.31.121 node1
192.168.31.122 node2
192.168.31.123 node3
EOF

cat > /etc/yum.repos.d/clickhouse.repo << EOF
[repo.yandex.ru_clickhouse_rpm_stable_x86_64]
name=clickhouse stable
baseurl=https://mirrors.tuna.tsinghua.edu.cn/clickhouse/rpm/stable/x86_64
enabled=1
EOF

echo "-----------安装JDK----------------"
cd /opt
sleep 5
rpm -ivh jdk-8u251-linux-x64.rpm
echo "export JAVA_HOME=/usr/java/jdk1.8.0_251-amd64" >> /etc/profile
echo "export PATH=\$PATH:\$JAVA_HOME/bin" >> /etc/profile
echo "export CLASSPATH=.:\$JAVA_HOME/jre/lib:\$JAVA_HOME/lib:\$JAVA_HOME/lib/tools.jar" >> /etc/profile

echo "-----------安装zookeeper----------------"
cd /opt
tar -zxf apache-zookeeper-3.6.2-bin.tar.gz
mv apache-zookeeper-3.6.2-bin zookeeper
cd zookeeper
mkdir data
cd conf
cp zoo_sample.cfg zoo.cfg

sed -i "s#dataDir=/tmp/zookeeper#dataDir=/opt/zookeeper/data#g" zoo.cfg
echo "server.1=node1:2888:3888" >> zoo.cfg
echo "server.2=node2:2888:3888" >> zoo.cfg
echo "server.3=node3:2888:3888" >> zoo.cfg

echo 1 > /opt/zookeeper/data/myid
#echo 2 > /opt/zookeeper/data/myid
#echo 3 > /opt/zookeeper/data/myid

echo "export PATH=\$PATH:/opt/zookeeper/bin" >> /etc/profile
. /etc/profile

echo "-----------安装clickhouse---------------"
sed -i "s/gpgcheck=1/gpgcheck=0/g" /etc/yum.conf 
yum install clickhouse-server clickhouse-client -y
\cp -rf /opt/config_node1.xml /etc/clickhouse-server/config.xml
#\cp -rf /opt/config_node2.xml /etc/clickhouse-server/config.xml
#\cp -rf /opt/config_node3.xml /etc/clickhouse-server/config.xml
\cp -rf /opt/users.xml /etc/clickhouse-server/

mkdir -p /opt/clickhouse
chown -R clickhouse:clickhouse /opt/clickhouse


echo "-----------启动zookeeper---------------"
zkServer.sh start
sleep 2
zkServer.sh status

echo "-----------启动clickhouse---------------"
systemctl enable clickhouse-server 
systemctl start clickhouse-server 
systemctl status clickhouse-server 

sleep 2
echo "-----------clickhouse-client连接---------------"
clickhouse-client --user=ck --password=clickhouse2021 -m --host=node1 --port=9000
#clickhouse-client --user=ck --password=clickhouse2021 -m --host=node2 --port=9000
#clickhouse-client --user=ck --password=clickhouse2021 -m --host=node3 --port=9000

zkServer.sh status
systemctl status clickhouse-server
clickhouse-client --user=ck --password=clickhouse2021 -m --host=node1 --port=9000
:)select * from system.clusters;