MySQL Forums
Forum List  »  Synchronization

MySql replication with Master-Master and master to slaves
Posted by: Nils Kariya
Date: March 05, 2013 12:40AM

I want to implement replication in MySQL.

My topology for replication are as below:

I have different branch and all branches are connected with replication to each other. This way replication I have done with my current system.

But now I want to replicate branch's database to different till connected with it.

For example: I have branches: Ho, B1, B2, B3.

Currently I have done replication is following flow: Ho->B1, B1-> B2, B2->B3, B3->Ho and its working fine.

But now I want to replicate My branch database to tills connected with it.
So for example: I have 3 Tills at Branch B1 than Brnach and Head Office should work as above scenarios but My Brnach B1 should replicate like

B1 - > Till 1, B1- > Till 2 , B1-> Till 3.

And same for other brnach having till than branch's main Database will replicate with Till database.

But HO and Branches repliaction should work as currently working scenarios as above.

Please let me how I can work with such a scenarios.

Thanks in Adavnce.

Options: ReplyQuote

Written By
MySql replication with Master-Master and master to slaves
March 05, 2013 12:40AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.