部署startRocks集群

export JAVA_HOME=/usr/java/jdk-17
export CLASSPATH=.:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar
export STARTROCKS_HOME=/opt/starRocks
export STARTROCKS_HOME_BE=$STARTROCKS_HOME/be
export STARTROCKS_HOME_FE=$STARTROCKS_HOME/fe
export MYSQL_HOME=/opt/mysql
export PATH=$PATH:$JAVA_HOME/bin:$STARTROCKS_HOME_BE/bin:$STARTROCKS_HOME_FE/bin:$MYSQL_HOME/bin

source /etc/profile
---------------------------------------------------------------------------------------------------------
rm -rf /opt/starRocks/fe/log/*
rm -rf /opt/starRocks/be/log/*
/opt/starRocks/fe/bin/start_fe.sh --daemon
cat /opt/starRocks/fe/log/fe.log | grep thrift
201上执行
---------------------------------------------------------------------------------------------------------

/opt/starRocks/be/bin/start_be.sh --daemon
cat /opt/starRocks/be/log/be.INFO | grep heartbeat
201、202、203上执行
---------------------------------------------------------------------------------------------------------
/opt/starRocks/be/bin/start_cn.sh --daemon
cat /opt/starRocks/be/log/cn.INFO | grep heartbeat
201、202、203上执行
---------------------------------------------------------------------------------------------------------
cat /opt/starRocks/fe/log/fe.log | grep thrift
cat /opt/starRocks/be/log/be.INFO | grep heartbeat
cat /opt/starRocks/be/log/cn.INFO | grep heartbeat
---------------------------------------------------------------------------------------------------------

rm -rf /opt/starRocks/fe/log/*
rm -rf /opt/starRocks/be/log/*
rm -rf /opt/starRocks/fe/meta/*
rm -rf /opt/starRocks/fe/temp_dir/*
rm -rf /opt/starRocks/be/storage/*
rm -rf /opt/starRocks/be/cn-storage/*
rm -rf /opt/starRocks/be/datacache/*
rm -rf /opt/starRocks/fe/meta/*

1、先启动一个fe leader（201）
2、启动所有be、cn
3、注册所有be
4、注册fe实现高可用

mysql -h 10.10.10.203 -P9030 -uroot

SHOW PROC '/frontends'\G

ALTER SYSTEM ADD BACKEND "10.10.10.202:9050", "10.10.10.203:9050";

ALTER SYSTEM ADD BACKEND "10.10.10.201:9050", "10.10.10.202:9050", "10.10.10.203:9050";
SHOW PROC '/backends'\G

ALTER SYSTEM DROP BACKEND "10.10.10.201:9050", "10.10.10.202:9050", "10.10.10.203:9050";

ALTER SYSTEM DROP BACKEND "10.10.10.203:9050";
ALTER SYSTEM ADD BACKEND "10.10.10.203:9050";

ALTER SYSTEM ADD COMPUTE NODE "10.10.10.201:9051", "10.10.10.202:9051", "10.10.10.203:9051";
SHOW PROC '/compute_nodes'\G

ALTER SYSTEM ADD COMPUTE NODE "10.10.10.201:9051", "10.10.10.202:9051", "10.10.10.203:9051";

ALTER SYSTEM DROP COMPUTE NODE "10.10.10.203:9051";

ALTER SYSTEM ADD COMPUTE NODE "10.10.10.203:9051";

ALTER SYSTEM DROP COMPUTE NODE "10.10.10.201:9051", "10.10.10.202:9051", "10.10.10.203:9051";

ALTER SYSTEM DROP LEADER "10.10.10.202:9010";

SHOW PROC '/compute_nodes'\G

ALTER SYSTEM ADD FOLLOWER "10.10.10.202:9010";
ALTER SYSTEM ADD FOLLOWER "10.10.10.203:9010";

ALTER SYSTEM DROP FOLLOWER "10.10.10.203:9010";

/opt/starRocks/fe/bin/start_fe.sh --helper 10.10.10.202:9010 --daemon

向集群中添加新的 Follower FE 节点时，您必须在首次启动新 FE 节点时为其分配一个 helper 节点（本质上是一个现有的 Follower FE 节点）以同步所有 FE 元数据信息

/opt/starRocks/fe/bin/start_fe.sh --helper 10.10.10.202:9010 --daemon

SHOW PROC '/frontends'\G

systemctl stop firewalld && systemctl disable firewalld && systemctl status firewalld

http://10.10.10.201:8030/

http://10.10.10.202:8030/ha

默认用户名root，密码是空的

---------------------------------------------------------------------------------------------------------
您可以通过在相应实例上运行以下命令来停止 StarRocks 集群。

停止 FE 节点。搭建成了集群模式，三个节点都要执行下面的命令

/opt/starRocks/fe/bin/stop_fe.sh --daemon

停止 BE 节点。

/opt/starRocks/be/bin/stop_be.sh --daemon

停止 CN 节点。

/opt/starRocks/be/bin/stop_cn.sh --daemon

/opt/starRocks/fe/bin/start_fe.sh --daemon

/opt/starRocks/be/bin/start_be.sh --daemon

/opt/starRocks/be/bin/start_cn.sh --daemon

---------------------------------------------------------------------------------------------------------
202上部署flink、201上部署mysql

mysql重启命令
/etc/init.d/mysql restart

SHOW VARIABLES LIKE 'log_bin'; 

mysql -h 10.10.10.203 -P 9030 -u root < starrocks-create.all.sql

/opt/flink-1.18.0/bin/stop-cluster.sh && /opt/flink-1.18.0/bin/start-cluster.sh

/opt/flink-1.18.0/bin/sql-client.sh -f /opt/flink-1.18.0/smt/result/flink-create.all.sql

查询运行的flink job任务信息
/opt/flink-1.18.0/bin/flink list -running