Skip navigation links

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


Advanced Search

Re: Three Node Replication (US West, US East and Europe)
Posted by: Rick James ()
Date: March 22, 2012 09:02PM

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

No, do not. There are too many things that can go wrong.

Instead have a single master (probably US-East) for all to write to. The latency is on the order of 0.1s per SQL statement. Do reads from your 'local' server (Slave or Master).

Note that you need to split reads and writes -- writes go to the single writable master; reads go anywhere.

That said, there are ways:

* "Circular replication" -- N master-slave machines in a circle; replication going in one direction. ("Dual master" is N=2.) I do not advise doing this; if one machine dies, it will be a mess to repair.

* NDB Cluster -- This allows writes everywhere, but the conflict resolution is different. You establish "rules" for which record "wins" if there are duplicate keys (etc).

Options: ReplyQuote


Subject Views Written By Posted
Three Node Replication (US West, US East and Europe) 1552 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) 522 Rick James 03/23/2012 07:55PM
Re: Three Node Replication (US West, US East and Europe) 561 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.