From: | richard excite <richard_excite(at)excite(dot)com> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | 2-phase commit |
Date: | 2000-08-23 07:08:00 |
Message-ID: | 14794238.967014480724.JavaMail.imail@dotty.excite.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Gilles DAROLD | 2000-08-23 08:01:50 | Re: Fw: Problem starting PostgreSQL |
Previous Message | richard excite | 2000-08-23 07:02:55 | VARCHAR with null |