MySQL Forums :: Replication :: MySQL Master(Active) - Master(Active) Replication


Advanced Search

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 4812 Prashant Gupta 09/24/2012 09:18AM
Re: MySQL Master(Active) - Master(Active) Replication 1553 domi nix 09/24/2012 06:32PM
Re: MySQL Master(Active) - Master(Active) Replication 1480 Prashant Gupta 09/24/2012 11:34PM
Re: MySQL Master(Active) - Master(Active) Replication 1576 Irfan Ali 09/26/2012 03:32PM
Re: MySQL Master(Active) - Master(Active) Replication 1259 Aftab Khan 09/27/2012 02:01AM
Re: MySQL Master(Active) - Master(Active) Replication 1110 Rick James 09/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.