- 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)
- 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 ...