MySQLReplicationLag critical
>>>
(
instance:mysql_slave_lag_seconds
> 30) and on(instance) (
predict_linear
(
instance:mysql_slave_lag_seconds
[5m], 60 * 2) > 0)
The alert fires when the MySQL slave’s replication lag (instance:mysql_slave_lag_seconds) is already above 30 seconds and a linear prediction of the lag over the next two minutes (based on the last 5 minutes) shows a positive slope, i.e., the lag is still increasing. In short, it alerts when the slave is lagging and the lag is not recovering.
Exporters Used
Related Alerts
MySQL High QPS
MySQL InnoDB Force Recovery is enabled
MySQL InnoDB history_len too long
MySQL InnoDB log waits
MySQL Slave IO thread not running
MySQL Slave SQL thread not running
MySQL Slave replication lag
MySQL down
MySQL high prepared statements utilization (> 80%)
MySQL high threads running
MySQL restarted
MySQL slow queries
MySQL too many connections (> 80%)
MySQL too many open files
MySQLDown
MySQLGaleraDonorFallingBehind
MySQLGaleraNotReady
MySQLGaleraOutOfSync
MySQLInnoDBLogWaits
MySQLReplicationLag
MySQLReplicationNotRunning