MySQL Forums
Forum List  »  Replication

MySQL Master(Active) - Master(Active) Replication
Posted by: Prashant Gupta
Date: September 24, 2012 09:18AM

Hello,

I am intending to use Master-Master (Active-Active) architecture of MySQL in my project.
In my project I have two sites active and disaster site. On the active site, we do use 2 MySQL DB server - one is Master Active other is Master Passive which replicates data to Disaster site. Master Active also replicates to Master passive. All the three app servers write only on master active.

Now, I am planning to use Master Passive as Master active. Now, active site will have two master active and one app server will write on one master active and other two app servers will write on 2nd master active.

It would be great if you can enlighten the pros and cons of using this archirtecture. What issues may arise and what are the remedies for them ?

FYI.. Session stickiness is also used from web servers to app servers.

Thanks,
Prashant Gupta



Edited 1 time(s). Last edit at 09/24/2012 09:20AM by Prashant Gupta.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Master(Active) - Master(Active) Replication
6219
September 24, 2012 09:18AM


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.