MysqlSlaveSqlThreadNotRunning

Level: Critical FIXME

Purpose: This alert will tell us that replication is not running on a replica DB

Scenario: MySQL Slave SQL thread has not been running on <server> for 5m .

Resolution: Check the replica for errors with a query.

Manual Action Steps:

  1. Log into the replica
  2. SHOW SLAVE STATUS;
  3. check the mysql error and fix it if possible
  4. STOP SLAVE;
  5. SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; This skips the problem query
  6. START SLAVE

Auto Clear: Will clear when the seconds behind master field goes under the threshold