Table of contents
This page describes what to do in case of an Icinga alert. For more information you could search the govuk-puppet repo for the source of the alert

MySQL: replication running

Checks whether Slave_IO_Running and Slave_SQL_Running both return Yes to indicate that replication is currently active. As described in the MySQL documentation:

Slave_IO_Running: Whether the I/O thread for reading the master’s binary log is running. Normally, you want this to be Yes unless you have not yet started replication or have explicitly stopped it with STOP SLAVE.

Slave_SQL_Running: Whether the SQL thread for executing events in the relay log is running. As with the I/O thread, this should normally be Yes.

To check the status of the slave,

  1. Log onto the server (e.g. mysql-backup-1.backend.integration)
  2. Open a MySQL shell:

    sudo -i mysql
    
  3. Run:

    mysql> SHOW SLAVE STATUS \G
    

More about Icinga alerts

This page was last reviewed . It needs to be reviewed again by the page owner #2ndline.