MySQL Forums
Forum List  »  NDB clusters

Advanced Search
New Topic

Using replication to keep geographically dispersed clusters in sync
Posted by: Robin Whitehead
Date: December 06, 2005 06:36AM

Hi,

If I wanted to set up multiple MySQL clusters in geographically dispersed locations (i.e. the master database is in datacentre A and there is a mirror database in datacentre B), is it possible to use replication to keep these clusters in sync with each other? If so, what replication models (active/active, active/passive) would be available - if possible an active/active (similar to MS SQL 2000's "Merge Transactional") would be the prefered. How many mirror databases could be connected to a setup like this?

Any help would be most appreciated,
Many thanks,
Rob.



Edited 1 time(s). Last edit at 12/06/2005 06:47AM by Robin Whitehead.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Using replication to keep geographically dispersed clusters in sync
2671
Robin Whitehead
December 06, 2005 06:36AM
Re: Using replication to keep geographically dispersed clusters in sync
1547
Stewart Smith
December 06, 2005 07:29AM
Re: Using replication to keep geographically dispersed clusters in sync
1485
Robin Whitehead
December 06, 2005 10:17AM


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.