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.
Switching slave from master-slave to chain replication
Get MySQL 8 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
