MySQL Forums
Forum List  »  Replication

Re: Two master databases for two seperate apps
Posted by: Irfan Ali
Date: December 07, 2011 07:37AM

Great! you are writing to both masters at the same time ?
Do you know any automated tool for conflict resolution. I am aware of maatkit mk-table-checksum and mk-table-sync for conflict resolution.

If you have master A and master B in circular replication and the application makes a change to record X on both A and B before the replication for that change makes it to the other, there is an issue. Imagine that the application changes X to 1 on master A and X to 2 on master B. After replication catches up, A has X=2 and B has X=1. Whoops. Replication hasn't broken, you don't know it happened,

That is where maatlkit tools which i described earlier are helpful. But what about if duplicate entry errors on one of the master. Replication breaks.
I am looking for automated tool for that sort of scenario and others.

Also, do let me know what are issues you faced in bidirectional replication (Active-Active Master).

Options: ReplyQuote


Subject
Views
Written By
Posted
1989
December 05, 2011 02:36PM
Re: Two master databases for two seperate apps
833
December 07, 2011 07:37AM


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.