Switching slave from master-slave to chain replication

If you have a master-slave replication set up, Servers B and C replicating from Server A: Server A --> (Server B, Server C) and you wish to make Server C a slave of Server B, you have to stop replication on both Server B and Server C. Then bring them to the same master log position using the START SLAVE UNTIL command. After that, you can get the master log coordinates from Server B and execute the CHANGE MASTER TO command on Server C.

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