Changeset 32404

Timestamp:

Sep 14, 2011, 10:20:29 AM (15 years ago)

Author:

Serge CHASTEL

Message:

Now displays seconds behind master for replication slaves

File:

• trunk/ippMonitor/raw/czartool_labels.php (modified) (3 diffs)

trunk/ippMonitor/raw/czartool_labels.php

@@ -200 +200 @@
       echo "<tr>";
       createTableColumnHeader("Database");
-      createTableColumnHeader("Status");
+      createTableColumnHeader("Status (sec behind master)");
       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);
@@ -903 +903 @@
         //die("MySQL DB connection error: Check the configuration for $replDatabaseName");
         //die("");
-        return;
+        return -1;
 
     }
@@ -910 +910 @@
         # 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>");
+        $sec_behind = $row[32];
+        $replStatus = ($errorStatusInMySql==0?"OK ($sec_behind)":"<font color=\"red\">PROBLEM</font>");
         echo "<tr><td>$replDatabaseName</td><td>$replStatus</td></tr>";
         if ($errorStatusInMySql!=0) {