Differences

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

--- resolution_area:watchdog_resolutions:res-w9805 [2021/06/29 17:09] – btobin
+++ resolution_area:watchdog_resolutions:res-w9805 [2021/07/05 14:22] (current) – 10.91.120.28
@@ Line 5: / Line 5: @@
 **Purpose:**
+Alerts when the command ''SHOW SLAVE STATUS;'' has seconds behind master greater than 5 minutes.
 **Scenario:**
+The replica database has fallen behind the master. This is usually caused by an error in replication or the replica server running slower than the master due to a long running query.
 **Resolution:**
+Following [[http://wiki.err/doku.php?id=watchdogs:mysqlslavereplicationfailure|this]] guide to resolve the issue.
 **Manual Action Steps:**
+Fix errors or stop long running queries.
 **Auto Clear:**
+When replica seconds behind drops below 5 minutes.

Internal Errigal Collaboration Wiki