Re: add slave to existing master-master replication
Posted by:
Rick James
Date: March 31, 2012 10:52AM
> failure of datacenter1
Don't put both masters in the same datacenter. Put one in each of two datacenters.
Yes, datacenters do go down. Or someone accidentally pulls the plug on the one rack where all your servers are. Or...
> (i.e. datacenter1 M1---> datacenter2 S1 and datacenter1 M2----> datacenter2 S2)
Once you get past 1 slave per master, split your slaves across datacenters. When a Master dies, all the slaves all of _its_ slaves will fail to get updates until something has been fixed. By splitting the slaves across datacenters, only half the slaves in each colo will be "stale".
Do you have load-balancing set up so that writes and reads can go to either datacenter automagically?
Subject
Views
Written By
Posted
2724
March 28, 2012 03:33PM
1331
March 29, 2012 09:35PM
1096
March 30, 2012 05:35AM
Re: add slave to existing master-master replication
1025
March 31, 2012 10:52AM
1204
April 01, 2012 07:38PM
1457
April 09, 2012 07:58AM
945
April 10, 2012 10:30PM
887
April 13, 2012 08:06AM
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.