Level: Critical
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 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.