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

Icinga alerts

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
    
This page was last reviewed on 17 April 2019. It needs to be reviewed again on 17 October 2019 by the page owner #govuk-2ndline .
This page was set to be reviewed before 17 October 2019 by the page owner #govuk-2ndline. This might mean the content is out of date.