- 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)
- On Server B: Stop slave and note the Relay_Master_Log_File ...