I have P2P replication going from say DB1 to DB2 and we are now just bought a couple more servers say DB3 and DB4. Our goal is to retire DB1 and add one more node in our replication. So we are thinking of setting up our replication so that it'll
first - DB1 to DB2 to DB3 to DB4
Second - when all replications are setup. We'll drop DB1.
The plan seems techincally possible, but I don't know it'll works.
Have anyone done anything like this before? if yes, could you share with us if there is any problem you have encountered.
Thanks a lot in advance.
Philly Database developer
View Complete Post