Re: Big 7.4 items

From: Darren Johnson <darren(at)up(dot)hrcoxmail(dot)com>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, shridhar_daithankar(at)persistent(dot)co(dot)in, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Big 7.4 items
Date: 2002-12-14 01:28:24
Message-ID: 3DFA8938.3020601@up.hrcoxmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
>
>>
>>Lets say we have systems A, B and C. Each one has some
>>changes and sends a writeset to the group communication
>>system (GSC). The total order dictates WS(A), WS(B), and
>>WS(C) and the writes sets are recieved in that order at
>>each system. Now C gets WS(A) no conflict, gets WS(B) no
>>conflict, and receives WS(C). Now C can commit WS(C) even
>>before the commit messages C(A) or C(B), because there is no
>>conflict.
>>
>
>And that is IMHO not synchronous. C does not have to wait for A and B to
>finish the same tasks. If now at this very moment two new transactions
>query system A and system C (assuming A has not yet committed WS(C)
>while C has), they will get different data back (thanks to non-blocking
>reads). I think this is pretty asynchronous.
>

So if we hold WS(C) until we receive commit messages for WS(A) and
WS(B), will that meet
your synchronous expectations, or do all the systems need to commit the
WS in the same order
and at the same exact time.

>
>
>It doesn't lead to inconsistencies, because the transaction on A cannot
>do something that is in conflict with the changes made by WS(C), since
>it's WS(A)2 will come back after WS(C) arrived at A and thus WS(C)
>arriving at A will cause WS(A)2 to rollback (WS used synonymous to Xact
>in this context).
>
Right

>
>Hope this doesn't add too much confusion :-)
>
No, however I guess I need to adjust my slides to include your
definition of synchronous
replication. ;-)

Darren

>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeroen T. Vermeulen 2002-12-14 01:33:06 Re: PQnotifies() in 7.3 broken?
Previous Message Christopher Kings-Lynne 2002-12-14 01:20:16 Re: Big 7.4 items