2-phase commit - Mailing list pgsql-general

From richard excite
Subject 2-phase commit
Date
Msg-id 14794238.967014480724.JavaMail.imail@dotty.excite.com
Whole thread Raw
List pgsql-general
Hello,

Is there any open source implementation of 2-phase commit out there using
Postgres ?
The basic logic says :

MASTER                                SLAVE
------                                -----
begin atomic action
send request 1-n
send "prepare to commit message"
                                     if action_can_be_performed
                                          lock data
                                          store initial state on disk
                                          store request on disk
                                          send "ok" message
                                     else
                                          send "failure" message
if all slaves said "ok"
     send "commit" message
else
     send "rollback" message
Wait for acknowledgements
                                     if master said commit
                                          do work
                                          unlock data

                                     Send "acknowledgement" message


How can I check "action_can_be_performed" (i.e. what conditions
 satisfy an "ok" vote ?)

thanks for your time.
-richard





_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html


pgsql-general by date:

Previous
From: "Mike Mascari"
Date:
Subject: Re: Stupid database use the index!
Next
From: sasha@mysql.com
Date:
Subject: Re: Great Bridge re-runs benchmark with MySQL "tuned"