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
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:
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!