MySQL Forums
Forum List  »  Replication

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
Re: Three Node Replication (US West, US East and Europe)
898
March 22, 2012 09:02PM


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.