I am considering how to configure our MySQL replication. Hope I can get any advices from community.
In fact, I am using MySQL 5.7, and have
- 01-Master
- 02-Slave
- 03-Slave
My Applications are using only 01-Master. They don't know 02-Slave, and 03-Slave.
Next, I want to promote 02-Slave to 02-Master. But want to keep 01-Master. So, I have:
- 01-Master
- 02-Master
- 03-Slave
Then I will set 01-Master for some Apps and 02-Master for other Apps.
But, I am not sure about how to position 03-Slave? Can I do that?
Please give me any advices.
Thanks a lot!
Best Answer
M1 <-> M2 -> S
is essentially the only configuration. Pros/cons...server_id
.