MySQL 8 Cookbook

How to do it...

1. On server B: Stop the slave and note down the master status:

mysql> STOP SLAVE;Query OK, 0 rows affected (0.04 sec)mysql> SHOW MASTER STATUS;+---------------------+----------+--------------+------------------+-------------------+| File                | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |+---------------------+----------+--------------+------------------+-------------------+| server_B-bin.000003 | 44627878 |              |                  |                   |+---------------------+----------+--------------+------------------+-------------------+1 row in set (0.00 sec)

2. On server C: Make sure that the slave delay is caught up.  Relay_Master_Log_File and Exec_Master_Log_Pos should be equal to the output of the master status on server B. Once the delay is ...