Differences

This shows you the differences between two versions of the page.

--- mysql-circular-replication-automated-handling [2008/10/24 21:18]
pegasus created
+++ mysql-circular-replication-automated-handling [2012/07/31 12:46] (current)
greebo old revision restored
@@ Line 1: / Line 1: @@
-Circular multimaster replication is poorly documented in the mysql circles. So putting together a script like this requires a lot of info hunting and testing. Still, I can't guarantee it won't eat your data ;)
+Circular multimaster replication is poorly documented in the mysql circles. So putting together a script like this requires a lot of info hunting and testing. Right now it survives sql-bench with random node shutdowns, but I can't guarantee it won't eat your data ;)
 Feel free to improve with logging etc.
@@ Line 19: / Line 19: @@
 MYSQLPARAMS=""
-#who should my master by
+#who should my master be
 case "`hostname`" in
@@ Line 124: / Line 124: @@
                         if [ $? -ne 0 ]
                         then
-                                #looks like we're offline. no master candidate is accessible
+                                #looks like we are offline. no master candidate is accessible
                                 echo panic
                         else
@@ Line 148: / Line 148: @@
         then
                 echo but $MYMASTER is not yet back
+                #also check the current master
+                check_current_master
+                if [ $? -ne 0 ]
+                then
+                        #uhh now what
+                        [ "`echo $MASTERLIST | cut -f1 -d:`" = "`get_master_host`" ] && REMAINING="`echo $MASTERLIST | cut -f2 -d:`" || REMAINING="`echo $MASTERLIST | cut -f1 -d:`"
+                        echo $REMAINING is still there
+                        change_master_to $REMAINING
+                fi
         else
                 change_master_to $MYMASTER