MySQL 8 Cookbook

How to do it...

1. On Server C: Stop slave and note the Relay_Master_Log_File and Exec_Master_Log_Pos positions in the SHOW SLAVE STATUS\G command:

mysql> STOP SLAVE;Query OK, 0 rows affected (0.01 sec)mysql> SHOW SLAVE STATUS\G*************************** 1. row ***************************               Slave_IO_State:                   Master_Host: xx.xxx.xxx.xxx                  Master_User: binlog_user                  Master_Port: 3306                Connect_Retry: 60              Master_Log_File: server_A-bin.000023          Read_Master_Log_Pos: 2604               Relay_Log_File: server_C-relay-bin.000002                Relay_Log_Pos: 1228        Relay_Master_Log_File: server_A-bin.000023~          Exec_Master_Log_Pos: 2604              Relay_Log_Space: 1437              Until_Condition: None               Until_Log_File:                 Until_Log_Pos: 0~1 row in set (0.00 sec)

2. On Server B: Stop slave and note the Relay_Master_Log_File ...