-
Hi,
In Master-Master replication, I am setting up a delay time after which all the changes to Master1 will be purged and applied to Master2. Is there a way by which we can update both Masters in one transaction ? If there is, is that approach recommended ?
Thanks
-
if one of masters is not available, what should happen then?
-
First of all, why would you want to do that if you are replicating and what type of transaction would it be?
Secondly, if you require to do this, there are some conflict resolution methods you can use to set priorities etc.
-
Is your replication ACTIVE-ACTIVE or ACTIVE-PASSIVE?
-
The replication we have is active-active. The transaction I was referring could be any insert, update or delete.
We want to keep both the masters in sync as we will be using them to implement TAF, so if one database dies the user must not have access to stale data if the other picks up before the changes were updated.. I guess I must do more research on conflict resolution methods.
Where can I find good documentation on conflict resolution methods ?
Thanks for your answers
-
I have a pdf that I can send you if you provide an email address.
Also look in the Help documentation for Oracle Advanced Replication. They have conflict resolution in detail.
-
Thanks
my email address is : chikkodi@hotmail.com
-
Oops, it seems you need very much really. Am I right:
status0: table T has 1 record with colum C=0
server1: update T set C=1
server1: dies
server2: user continues on server2, but here coms problem:
T has 1 record with column C=0, while application assumes it is C=1 and continues with that assumtion, for example, commits?
If so, you need synchronous replication, but such, that DB is not stalled if one of servers is not available. Synchronous replication is simple: just Db triggers. What is not simple, how to queue changes on server2 while server 1 is not available?
Probably you really have to rely on queue provided by multimaster replication and JUST use conflict resolution to discard changes done by synchronous replication (Db triggers). In general it seems very complicated... Standby DB is better alternative then.
-
I tried to send the .pdf file but hotmail exceeded the size.
I think if you look at the online help for conflict resolution, it will be helpful to you. Good Luck!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|