From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Mike Mascari <mascarm(at)mascari(dot)com> |
Cc: | Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: 2-phase commit |
Date: | 2003-09-10 00:38:41 |
Message-ID: | 200309100038.h8A0cfb18205@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-hackers |
Mike Mascari wrote:
> Bruce Momjian wrote:
> > I haven't seen any comment on this email.
> >
> > 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.
> >
> > We have had several requests for 2-phase commit in the past month. I
> > think we should encourage the Japanese group to continue on their
> > 2-phase commit patch to be included in 7.5. Yes, it will have
> > non-solvable failure modes, but let's discuss them and find an
> > appropriate way to deal with the failures.
>
> FWIW, Oracle 8's manual for the recovery of a distributed tx where the
> coordinator never comes back on line is:
>
> https://www.ifi.uni-klu.ac.at/Public/Documentation/oracle/product/8.0.3/doc/server803/A54643_01/ch_intro.htm#7783
>
> "If a database must be recovered to a point in the past, Oracle's
> recovery facilities allow database administrators at other sites to
> return their databases to the earlier point in time also. This ensures
> that the global database remains consistent."
>
> So it seems, for Oracle 8 at least, PITR is the method of recovery for
> cohorts after unrecoverable coordinator failure.
Yep, I assume PITR would be the solution for most failure cases --- very
ugly of course.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-09-10 06:03:08 | Re: 2-phase commit |
Previous Message | Mike Mascari | 2003-09-10 00:06:58 | Re: 2-phase commit |
From | Date | Subject | |
---|---|---|---|
Next Message | Rada Chirkova | 2003-09-10 01:10:18 | Can I use PostgreSQL to develop a self-organizing database system? |
Previous Message | Andrew Dunstan | 2003-09-10 00:38:36 | Re: massive quotes? |