MySQL and MariaDB replication SQL thread stopped alert


The Replication SQL Thread Stopped alert notifies you when its configured condition is met on MySQL and MariaDB instances so you can investigate and respond.

Screenshot pending: Mini DBA MySQL and MariaDB Replication SQL Thread Stopped alert screenshot placeholder

Alert summary

  • Platform: MySQL and MariaDB
  • Alert category: Availability
  • Default enabled: true
  • Default evaluation frequency: Minute

What Mini DBA checks

Mini DBA describes this alert as: A MySQL replica SQL/applier thread is not running. The replica is not applying received changes, so it may be stale even if network IO is healthy. Mini DBA evaluates this alert once a minute so changes are detected quickly.

How this alert helps

This alert protects high availability and disaster recovery by warning when replicas, replication slots, or apply processes fall behind. Lag can turn a planned failover into data loss risk or leave reporting users looking at stale data.

When to enable it

Enable it where replication, read replicas, failover, or reporting copies are part of the service design. Disable it on standalone systems that do not use replication so the alert list stays focused.

Threshold guidance

This alert is based on a state or event rather than a numeric threshold. Tune its schedule, scope, severity, and notification route so that the response matches the importance of the instance.

Remediation for an active alert

Check the sender, receiver, apply process, network path, and oldest retained log position. Restart failed replication workers only after capturing the error, then address the root cause such as disk pressure, long transactions, schema drift, network latency, or insufficient replica capacity.

Investigation workflow

  1. Confirm the alert is still active and note the first seen time, affected instance, and severity.
  2. Review the primary, replica, transport path, apply process, retained log position, and oldest open transaction in Mini DBA before changing configuration or ending sessions.
  3. Compare the current value with the normal baseline for the same time of day or maintenance window.
  4. Record the cause, corrective action, and whether thresholds or routing should be adjusted after the incident.

Avoiding alert noise

For recovery and replication alerts, route notifications to the people who own recovery objectives. Higher thresholds can be reasonable for reporting replicas, but production failover paths normally need tighter settings and explicit escalation.

Related pages