Skip navigation links

MySQL Forums :: Replication :: Three Node Replication (US West, US East and Europe)


Advanced Search

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) 1550 Tom Anders 03/22/2012 01:44AM
Re: Three Node Replication (US West, US East and Europe) 571 Rick James 03/22/2012 09:02PM
Re: Three Node Replication (US West, US East and Europe) 535 Tom Anders 03/22/2012 11:22PM
Re: Three Node Replication (US West, US East and Europe) 521 Rick James 03/23/2012 07:55PM
Re: Three Node Replication (US West, US East and Europe) 560 Tom Anders 03/25/2012 12: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.