Re: Master-Master Replication support
Posted by:
Rick James
Date: January 18, 2014 04:11PM
Oracle, Percona, SkySQL, and others probably support Master-Master replication. But many people discourage it unless you write to only one of the Masters at a time.
Galera, PXC, GenieDB, and other third party vendors provide multi-master solutions. These need less support because they take care of the messy details more thoroughly.
Essentially Master-Master is two servers, each configured to be both a Master and a Slave. Each is replicating from the other. (This is the case whether you write to both or not.)
If you intend to write to both, auto_increment_offset and auto_increment_increment need to be set to 1 (or 2) and 2, respectively. You are on your own when it comes to dealing with other cases of "duplicate keys", which can all to easily arise.
To discuss it further here, please describe your use case and why you want M-M. Likely answers are
* High availability
* Write scaling (which you don't get)
* Read scaling (simple slaves provide this)
* Failover
* Low latency (if masters are geographically separate)
* other?
Subject
Views
Written By
Posted
1565
January 16, 2014 07:41AM
Re: Master-Master Replication support
873
January 18, 2014 04:11PM
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.