Changeset 29654

Timestamp:

Nov 3, 2010, 1:39:43 PM (16 years ago)

Author:

Serge CHASTEL

Message:

MySQL Replication status can now be seen through czartool/DB Connection parameters are in site.php.in

Location:

trunk/ippMonitor/raw

Files:

• czartool_labels.php (modified) (2 diffs)
• site.php.in (modified) (1 diff)

trunk/ippMonitor/raw/czartool_labels.php

@@ -156 +156 @@
 echo "</td>\n";
 echo "<td>\n";
-echo "<b>Information about replication will be here soon</b>";
+# This is awful
+echo "<table border=\"1\"><tr><td colspan=\"2\"><b>Databases Replication Status</b></td></tr>";
+echo "<tr><td>Database</td><td>Replication Status</td></tr>";
+showReplicationsStatus($REPL_HOST_GPC1, $REPL_USER_GPC1, $REPL_PASSWORD_GPC1, $REPL_DBNAME_GPC1);
+showReplicationsStatus($REPL_HOST_NEBULOUS, $REPL_USER_NEBULOUS, $REPL_PASSWORD_NEBULOUS, $REPL_DBNAME_NEBULOUS);
+echo "</table>";
 echo "</td>\n";
 echo "</tr>\n";
 
 echo "</table>\n";
-
 
 menu_end();
@@ -679 +683 @@
 
     }
-
-}
-
+}
+
+###########################################################################
+#
+# Shows the status of the various replication mysql servers
+#
+###########################################################################
+function showReplicationsStatus($replHost, $replUser, $replPassword, $replDatabaseName) {
+  #print "<br>$replHost, $replUser, $replPassword, $replDatabaseName<br/>";
+  $dbRepl = DB::connect("mysql://$replUser:$replPassword@$replHost");
+  if (PEAR::isError($dbRepl)) {
+    die("MySQL DB connection error: Check the configuration for $replDatabaseName");
+  }
+  $res = $dbRepl->query('SHOW SLAVE STATUS');
+  while ($res->fetchInto($row)) {
+    # Have a look for Last_Errno in http://dev.mysql.com/doc/refman/5.0/en/show-slave-status.html
+    $errorStatusInMySql = $row[18];
+    $replStatus = ($errorStatusInMySql==0?"OK":"<font color=\"red\">PROBLEM</font>");
+    echo "<tr><td>$replDatabaseName</td><td>$replStatus</td></tr>";
+    if ($errorStatusInMySql!=0) {
+      echo "<tr><td colspan=\"2\">Connect to $replDatabaseName replication host, execute 'SHOW SLAVE STATUS', and fix the problem.<br/>";
+      echo "Information <a href=\"http://dev.mysql.com/doc/refman/5.0/en/show-slave-status.html\">here</a></td></tr>";
+    }
+  }
+  $dbRepl->disconnect();
+}
 
 ?>

trunk/ippMonitor/raw/site.php.in

@@ -21 +21 @@
 $DELETION_USER  = "apache";
 $DELETION_DELAY = 15;
+
+$REPL_HOST_GPC1 = "ipp0012.IfA.Hawaii.Edu";
+$REPL_USER_GPC1 = "ipp";
+$REPL_PASSWORD_GPC1 = "ipp";
+$REPL_DBNAME_GPC1 = "gpc1";
+
+$REPL_HOST_NEBULOUS = "ipp0222.IfA.Hawaii.Edu";
+$REPL_USER_NEBULOUS = "ippMonitor";
+$REPL_PASSWORD_NEBULOUS = "ippMonitor";
+$REPL_DBNAME_NEBULOUS = "Nebulous";
+
 ?>