MySQL Forums
Forum List  »  Replication

Re: MySQL Master(Active) - Master(Active) Replication
Posted by: Aftab Khan
Date: September 27, 2012 02:01AM

Multi-master replication is supported by MySQL but it is advised not to write to all master hosts at the same time:

1. Conflict that can happen with self-generated keys, If node A and node B both insert an auto-incrementing key on the same table, conflicts arise immediately. However, this can be fixed with the help of pair settings on each master host to make them use different sequences of auto-increment values e.g. master1 will use 1, 3, 5, 7 and master2 would use 2, 4, 6, 8…


2. If two or more clients update a table with the same value of unique key on both master servers it is possible that one client overwrites others data. The same applies to any update of tables without unique key at all.


3. If the replication on any master host is not caught up, application could be acting on stale information.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Master(Active) - Master(Active) Replication
1669
September 27, 2012 02:01AM


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.