LQDeployConfig/kubernetes/mysql-master-slave/V1/check_master_slave_replica_status.sh

# 检查详细的复制状态
SLAVE_POD=$(kubectl get pod -l role=slave -o jsonpath='{.items[0].metadata.name}')
MASTER_POD=$(kubectl get pod -l role=master -o jsonpath='{.items[0].metadata.name}')

echo "=== 检查复制状态 ==="
kubectl exec $SLAVE_POD -- mysql -uroot -proot123 -e "SHOW REPLICA STATUS\G" | grep -E "Replica_IO_Running|Replica_SQL_Running|Seconds_Behind_Source|Source_Host|Source_User|Last_IO_Error|Last_SQL_Error"

# 获取具体的运行状态
IO_RUNNING=$(kubectl exec $SLAVE_POD -- mysql -uroot -proot123 -e "SHOW REPLICA STATUS\G" | grep "Replica_IO_Running:" | awk '{print $2}')
SQL_RUNNING=$(kubectl exec $SLAVE_POD -- mysql -uroot -proot123 -e "SHOW REPLICA STATUS\G" | grep "Replica_SQL_Running:" | awk '{print $2}')

echo -e "\nIO线程状态: $IO_RUNNING"
echo "SQL线程状态: $SQL_RUNNING"

if [ "$IO_RUNNING" = "Yes" ] && [ "$SQL_RUNNING" = "Yes" ]; then
    echo "✅ 复制运行正常！"
else
    echo "❌ 复制异常"
fi