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).
Subject
Views
Written By
Posted
1989
December 05, 2011 02:36PM
783
December 06, 2011 05:10PM
Re: Two master databases for two seperate apps
834
December 07, 2011 07:37AM
870
December 07, 2011 08:33AM
839
December 07, 2011 11:15PM
786
December 09, 2011 12:25PM
781
December 10, 2011 02:37PM
836
December 11, 2011 02:13PM
771
December 12, 2011 01:21AM
791
December 16, 2011 05:49AM
692
December 17, 2011 12:56PM
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.