Changes between Version 18 and Version 19 of keepalived

Timestamp:

09/20/22 00:00:42 (2 years ago)

Author:

krit

Comment:

--

keepalived

@@ -111 +111 @@
 }}}
 For standby site (backup site ip 10.7.168.58) config can be found [attachment:keepalived_backup.tar here]
+
+------------------------------------------
+== keepalived Backup site check DB Group Replicate ==
+
+{{{
+#!sh
+
+#!/usr/bin/bash
+logfile=/tmp/keepalived.log
+echo "Time: $(date). keepalive log -------" >> $logfile 
+
+IP_MASTER="192.168.81.12"
+STR_CHECK="ONLINE"
+
+#/usr/bin/unison > /dev/null 2>&1
+/bin/ping -c 2 -W 1 192.168.81.12 > /dev/null 2>&1
+status=$?
+echo 'ping ' $status
+if [ $status -eq 0 ]
+then
+   all_result=`/usr/bin/docker exec -i nodedb1 mysql -uroot -pmypass -e 'SELECT * FROM performance_schema.replication_group_members;'`
+   online=$(echo $all_result | grep "$IP_MASTER" | awk '{ print $12}' )
+   if [[ "$online" == *"$STR_CHECK"* ]]
+   then
+       echo "Master node OK" >> $logfile
+       exit 1 # All good. DB master reachable
+   else
+       echo "Master node Fail" >> $logfile
+       exit 0 # Failover trigger
+   fi
+else
+   echo "Master node Fail" >> $logfile
+   exit 0 # Failover trigger
+fi
+}}}