Re: 2-phase commit - Mailing list pgsql-hackers

From dom@idealx.com
Subject Re: 2-phase commit
Date
Msg-id 20010124130025.A1176@seccotine.ird.idealx.com
Whole thread Raw
In response to Re: Re: AW: Re: MySQL and BerkleyDB (fwd)  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-hackers
 [ sorry to repost this, but I didn't receive my mail back... Anythingwrong with the mailserver ? ]
I am involved in a project of open-source, PostgreSQL-backed,
buzzword-compliant replication/high availability software that would
act as an SQL « one-to-many » gateway (but still in the design phase
--- this is *not* an announcement :-). Of course, the topic of 2-phase
commit is important to us ; we currently plan to record all write
commands issued during the transaction in an auxiliary table (some
sort of higher-level WAL). First commit phase would then consist in
closing this record and ensuring it can be  REDOne in the case of a
crash (UNDO would be done by just rolling back the current
transaction). But this is quite complicated and may require to
serialize all accesses (both read and write) to a given database so as
to guarantee that REDO will yield the very same result.
I understand it would certainly be better and more profitable for
the community if I could help implement 2-phase commit inside
PostgreSQL. But I am not much of a PostgreSQL hacker yet. What do you
think ?

-- 
<< Tout n'y est pas parfait, mais on y honore certainement les jardiniers >>
        Dominique Quatravaux <dom@kilimandjaro.dyndns.org>


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Re: MySQL and BerkleyDB (fwd)
Next
From: Bruce Momjian
Date:
Subject: Re: This script will crash the connection