Master-Master replication after reconnect data mismatch.
Posted by:
alan lee
Date: November 13, 2011 07:57PM
Hi all,
I am currently working on a transaction system and planning to implement the replication on 2 counters. The issue currently facing was if I disconnecting the network and I did UPDATE the value of the Same table and Same field, once I reconnected back, both server exchange the data with each other instead of compare for which 1 is the latest edited and take the latest.
Eg.
WHEN DISCONNECTED CHANGE 2 DB VALUE
________________ ________________
| DB_T1 | | DB_T2 |
|--------------| |--------------|
|upd_ind = 1 | |upd_ind = 9 |
|______________| |______________|
AFTER RECONNECTED
________________ ________________
| DB_T1 | | DB_T2 |
|--------------| |--------------|
|upd_ind = 9 | |upd_ind = 1 |
|______________| |______________|
In this case I assume that both DB read each other log when the network connected back that why their data exchanged. Is mysql got any way in control it?
Subject
Views
Written By
Posted
Master-Master replication after reconnect data mismatch.
1681
November 13, 2011 07:57PM
1204
November 14, 2011 11:08PM
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.