| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: 2-phase commit |
| Date: | 2003-09-10 06:03:08 |
| Message-ID: | 29978.1063173788@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-hackers |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> From our previous discussion of 2-phase commit, there was concern that
> the failure modes of 2-phase commit were not solvable. However, I think
> multi-master replication is going to have similar non-solvable failure
> modes, yet people still want multi-master replication.
No. The real problem with 2PC in my mind is that its failure modes
occur *after* you have promised commit to one or more parties. In
multi-master, if you fail you know it before you have told the client
his data is committed.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francois Suter | 2003-09-10 07:23:23 | French ML and web site |
| Previous Message | Bruce Momjian | 2003-09-10 00:38:41 | Re: 2-phase commit |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darko Prenosil | 2003-09-10 08:50:18 | Trouble with error message encoding |
| Previous Message | Tom Lane | 2003-09-10 06:01:09 | Re: Stats Collector Error 7.4beta1 and 7.4beta2 |