From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "Aidan Van Dyk" <aidan(at)highrise(dot)ca> |
Cc: | "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. |
Date: | 2011-03-07 15:13:46 |
Message-ID: | 4D74A1CA020000250003B569@gw.wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
> Synchronous replication - guarantees "zero data loss" by the
> means of atomic write operation, i.e. write either completes on
> both sides or not at all.
So far, so good.
> Write is not considered complete until acknowledgement by both
> local and remote storage.
OK, *if* we want to live up to this definition, we don't seem to
have that part covered. Of course, since the connection is broken
during the hypothetical crash, it seems hard to acknowledge it on
recovery, and short of 2PC I don't see how we roll it back. About
the best we could do is somehow have explicit logging of the
disposition of unacknowledged commit requests upon recovery, and
consider logging of success to be "acknowledgement". Is this
logging provided by other databases with "synchronous replication"
features?
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2011-03-07 15:46:52 | Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. |
Previous Message | Aidan Van Dyk | 2011-03-07 15:04:22 | Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. |
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2011-03-07 15:46:52 | Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. |
Previous Message | Aidan Van Dyk | 2011-03-07 15:04:22 | Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. |