MySQL 8 Administrator???s Guide

Replication administration tasks

This section describes a few commonly required MySQL replication administrative tasks. Usually, once set up, MySQL replication doesn't require regular monitoring.

One of the most common tasks is to ensure that replication is taking place without errors between master and slave database servers. A SHOW SLAVE STATUS MySQL statement is used for this as follows:

mysql> SHOW SLAVE STATUS\G*************************** 1. row ***************************               Slave_IO_State: Waiting for master to send event                  Master_Host: master1                  Master_User: root                  Master_Port: 3306                Connect_Retry: 60              Master_Log_File: mysql-bin.000004          Read_Master_Log_Pos: 931               Relay_Log_File: slave1-relay-bin.000056                Relay_Log_Pos: 950 Relay_Master_Log_File: ...