页面历史

所有集群内的主机均需进行防火墙配置。(集群主机：test1,test2)

systemctl stop firewalld

systemctl disable firewalld

systemctl status firewalld

firewall-cmd --permanent --add-port=9000/tcp
firewall-cmd --permanent --add-port=8123/tcp
firewall-cmd --permanent --add-port=2181/tcp
firewall-cmd --permanent --add-port=2888/tcp
firewall-cmd --permanent --add-port=3888/tcp

firewall-cmd --reload

firewall-cmd --list-all

setenforce 0

sed -i 's/=enforcing/=disabled/g'  /etc/selinux/config

tar -zxvf Smartbi-MPP-Colony.tar.gz
cd Smartbi-MPP-Colony

所有集群内的主机均需设置系统环境(集群主机：test1,test2)

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

192.168.99.104 test1
192.168.99.105 test2

集群内的主机均需安装java环境(集群主机：test1,test2)

tar -zxvf jdk8.0.202-linux_x64.tar.gz -C /opt

export  JAVA_HOME=/opt/jdk8.0.202-linux_x64
export  JRE_HOME=$JAVA_HOME/jre
export  CLASSPATH=.:$JAVA_HOME/lib:$JRE_HOME/jre/lib:$CLASSPATH
export  PATH=$JAVA_HOME/bin:$JRE_HOME/bin:$PATH

source /etc/profile

java -version

tar -zxvf zookeeper-3.4.13.tar.gz

cd zookeeper-3.4.13

mkdir {data,log}

cd conf/ && mv zoo_sample.cfg zoo.cfg && vi zoo.cfg 

tickTime=2000
initLimit=10
syncLimit=5
dataDir=/data/Smartbi-MPP-Colony/zookeeper-3.4.13/data
dataLogDir=/data/Smartbi-MPP-Colony/zookeeper-3.4.13/log
clientPort=2181
#保留20个文件
autopurge.snapRetainCount=20 
#保留48小时
autopurge.purgeInterval=48 
############
#zookeeper集群主机1
server.1=test1:2888:3888 
#zookeeper集群主机2
server.2=test2:2888:3888

scp -r /data/Smartbi-MPP-Colony/zookeeper-3.4.13 root@test2:/data/Smartbi-MPP-Colony  

echo 1 > /data/Smartbi-MPP-Colony/zookeeper-3.4.13/data/myid  

echo 2 > /data/Smartbi-MPP-Colony/zookeeper-3.4.13/data/myid

cd /data/Smartbi-MPP-Colony/zookeeper-3.4.13/bin
./zkServer.sh start #启动zookeeper

./zkServer.sh status 

./zkCli.sh -server test2:2181 
create /zk-cluster-test cluster-data 

./zkCli.sh -server test1:2181 
get /zk-cluster-test

集群内的主机均需安装smartbimpp(集群主机：test1,test2)

cd /data/Smartbi-MPP-Colony/clickhous-package/
rpm -ivh clickhouse-common-static-19.4.2.7-1.el7.x86_64.rpm
rpm -ivh clickhouse-server-common-19.4.2.7-1.el7.x86_64.rpm
rpm -ivh clickhouse-server-19.4.2.7-1.el7.x86_64.rpm
rpm -ivh clickhouse-client-19.4.2.7-1.el7.x86_64.rpm

mkdir /data/clickhouse/{tmp,user_files} -p

echo -n "manager" | sha256sum | tr -d '-'

systemctl start clickhouse-server 

vi /etc/metrika.xml

systemctl restart clickhouse-server

#test1节点：
clickhouse-client --host test1 --port 9000 --database default --user default --password manager
#test2节点：
clickhouse-client --host test2 --port 9000 --database default --user default --password manager
#查询集群信息
select * from system.clusters;

create database if not exists smartbimpp;
show databases;

use smartbimpp
CREATE TABLE ontime_local (FlightDate Date,Year UInt16) ENGINE = MergeTree(FlightDate, (Year, FlightDate), 8192); 

CREATE TABLE ontime_all AS ontime_local ENGINE = Distributed(smartbi, smartbimpp, ontime_local, rand()); 

insert into ontime_all (FlightDate,Year)values('2001-10-12',2033);
insert into ontime_all (FlightDate,Year)values('2001-10-12',2002);
insert into ontime_all (FlightDate,Year)values('2001-10-12',2003);
insert into ontime_all (FlightDate,Year)values('2001-10-12',2004);
insert into ontime_all (FlightDate,Year)values('2001-10-12',2005);

select count(1) from ontime_all; #查看总行数
select count(1) from ontime_local; #每个节点的行数

#停止服务
systemctl stop clickhouse-server
#启动服务
systemctl start clickhouse-server
3重启服务
systemctl restart clickhouse-server
3开机启动
systemctl enable clickhouse-server