MySQL Forums
Forum List  »  Replication

Three Node Replication (US West, US East and Europe)
Posted by: Tom Anders
Date: March 22, 2012 01:44AM

Hello! I'm been searching and reading until nearly blind. Your help is appreciated!

We are currently running MySQL in both Master-Slave and Master-Master mode between two continents (North America and Europe). All is well.

We now want to expand another node in the US, so we will have two nodes in the US (East and West Coast) and one in Europe.

We want to be able to read-write at each node using the same application that is running on all three nodes.

I assume this is "three node" Master-Master-Master replication?

However, I cannot find any recommended configuration architectures for more than two Masters? The MySQL presentations say that a "ring" is not recommended, and since a slave can only have one Master, a "hub-spoke" Master-Master seems out of the question.

What are our options?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Three Node Replication (US West, US East and Europe)
3423
March 22, 2012 01:44AM


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.