MySQL Master(Active) - Master(Active) Replication
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.
Subject
Views
Written By
Posted
MySQL Master(Active) - Master(Active) Replication
6219
September 24, 2012 09:18AM
1859
September 24, 2012 06:32PM
1780
September 24, 2012 11:34PM
1890
September 26, 2012 03:32PM
1672
September 27, 2012 02:01AM
1465
September 27, 2012 07:59AM
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.