# 1. 配置监控脚本
#!/bin/bash
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: http://www.fgedu.net.cn
# gg_ha_monitor.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: http://www.fgedu.net.cn

# 配置
PRIMARY_GG_HOME=”/oracle/goldengate”
STANDBY_GG_HOME=”/oracle/goldengate”
PRIMARY_HOST=”fgedu-primary.net.cn”
STANDBY_HOST=”fgedu-standby.net.cn”
LOG_FILE=”/oracle/goldengate/ha/gg_ha_monitor_$(date +%Y%m%d).log”
ALERT_FILE=”/oracle/goldengate/ha/gg_ha_alert_$(date +%Y%m%d).log”

# 记录日志
log_message() {
echo “$(date +”%Y-%m-%d %H:%M:%S”): $1″ >> $LOG_FILE
}

# 记录告警
alert_message() {
echo “$(date +”%Y-%m-%d %H:%M:%S”): $1″ >> $ALERT_FILE
# 发送告警邮件
echo “$1” | mail -s “GoldenGate HA Alert” admin@fgedu.net.cn
}

# 检查主实例状态
check_primary() {
log_message “检查主GoldenGate实例状态…”
PRIMARY_STATUS=$(ssh $PRIMARY_HOST “$PRIMARY_GG_HOME/ggsci << EOF info all EOF" ) log_message "主实例状态: $PRIMARY_STATUS" if echo "$PRIMARY_STATUS" | grep -E "MANAGER.*RUNNING" > /dev/null; then
log_message “主GoldenGate实例正常”
return 0
else
log_message “主GoldenGate实例异常”
alert_message “主GoldenGate实例异常: $PRIMARY_STATUS”
return 1
fi
}

# 检查备用实例状态
check_standby() {
log_message “检查备用GoldenGate实例状态…”
STANDBY_STATUS=$(ssh $STANDBY_HOST “$STANDBY_GG_HOME/ggsci << EOF info all EOF" ) log_message "备用实例状态: $STANDBY_STATUS" if echo "$STANDBY_STATUS" | grep -E "MANAGER.*RUNNING" > /dev/null; then
log_message “备用GoldenGate实例正常”
return 0
else
log_message “备用GoldenGate实例异常”
alert_message “备用GoldenGate实例异常: $STANDBY_STATUS”
return 1
fi
}

# 主函数
main() {
log_message “开始GoldenGate高可用性监控”
check_primary
check_standby
log_message “GoldenGate高可用性监控完成”
}

# 执行主函数
main

Part04-生产案例与实战讲解

4.1 主备架构实战