G
G
grabbee2016-11-13 10:56:20
MySQL
grabbee, 2016-11-13 10:56:20

How to switch Mysql replication with two replicas?

I'm trying to set up a simple master slave replication in Mysql, with one master and two replicas from the master. Please help me understand - I switch one of the repics to the master, and I transfer the second replica by changemaster to it. Now it turns out that I need to make the old master a slave and connect it to the new master. But now some time has passed, and I need to return the original master back from the slave, and the former slave back to the slave. I can't figure it out:
* these masters have their own binlogs
* while the replica switched between two masters with different binlogs Is
it possible to implement such a switch in principle? How to do it right. So it seems to work, but it seems to me that I did something wrong ..

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question