two phase commit

Поиск
Список
Период
Сортировка
Искать

two phase commit

От:
Matthew Hixson <hixson@poindextrose.org>
Дата:
 From what I can find with Google it looks like TPC might make it into 
Postgrs 7.5.  I was wondering if there were any commercial products or 
open source projects that can provide TPC on top of Postgres.  Or is 
this something that really needs to be handled by the database itself?
   -M@

Re: two phase commit

От:
David Garamond <lists@zara.6.isreserved.com>
Дата:
Matthew Hixson wrote:
>  From what I can find with Google it looks like TPC might make it into 
> Postgrs 7.5.  I was wondering if there were any commercial products or 
> open source projects that can provide TPC on top of Postgres.  Or is 
> this something that really needs to be handled by the database itself?

With the 2PC patch submitted, you can interface with it at the SQL level 
(i.e. you prepare, commit, cancel prepare, etc. by issuing ordinary SQL 
commands). This means it will be pretty trivial to make it work with 
other components like TX manager, etc. For example, I'm guessing it will 
be easy to add 2PC support to npgsql (.NET data provider).

PS: It's really nice to see Postgres coming along feature-wise. 2PC and 
nested transaction (aside from native Windows port, of course) are the 
main things Firebird has that Potsgres hasn't. After that, we can pretty 
much leave FB in the dust... :-)

-- 
dave
FAQ