Conflict resolution in Multimaster replication(Postgres-R)

From: M2Y <mailtoyahoo(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Conflict resolution in Multimaster replication(Postgres-R)
Date: 2008-09-03 23:02:14
Message-ID: 533a001e-69b5-4d56-a188-3cf20eb8cd9c@r15g2000prd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

My basic question is: in multimaster replication, if each site goes
ahead and does the modifications issued by the transaction and then
sends the writeset to others in the group, how the ACID properties be
maintained?

Details:
Suppose there are two sites in the group, lets say, A and B and are
managing a database D. Two transactions TA and TB started in sites A
and B respectively, at nearly same time, wanted to update same row of
a table in the database. As, no locking structures and other
concurrency handling structures are replicated each will go ahead and
do the modifications in their corresponding databases and sends the
writeset. Since, both writesets contain update to the same row, will
the two transactions be rolled back or anything other than this
happens?

A more general question is: for Transactional isolation level
4(serializable level), the information such as locking of rows be
transmitted across sites? If not, what is the mechanism to address
concurrency with serializibility.

Thanks,
Srinivas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-09-03 23:03:24 Re: [patch] GUC source file and line number]
Previous Message Tom Lane 2008-09-03 22:57:57 Re: [patch] GUC source file and line number]