From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Replication Ideas |
Date: | 2003-08-25 17:38:16 |
Message-ID: | 1061833095.11311.61.camel@haggis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-performance |
On Mon, 2003-08-25 at 12:06, Chris Travers wrote:
> Ron Johnson wrote:
>
> >This is vaguely similar to Two Phase Commit, which is a sine qua
> >non of distributed transactions, which is the s.q.n. of multi-master
> >replication.
> >
> >
> >
>
> I may be wrong, but if I recall correctly, one of the problems with a
> standard 2-phase commit is that if one server goes down, the other
> masters cannot commit their transactions. This would make a clustered
> database server have a downtime equivalent to the total downtime of all
> of its nodes. This is a real problem. Of course my understanding of
> Two Phase Commit may be incorrect, in which case, I would appreciate it
> if someone could point out where I am wrong.
Note that I didn't mean to imply that 2PC is sufficient to implement
M-M. The DBMS designer(s) must decide what to do (like queue up
changes) if 2PC fails.
--
-----------------------------------------------------------------
Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA
"Our computers and their computers are the same color. The
conversion should be no problem!"
Unknown
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Maguire | 2003-08-25 17:44:50 | table constraints and performance |
Previous Message | Patrick Hatcher | 2003-08-25 17:30:00 | Sales numbers off hold off using please. |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2003-08-25 18:24:41 | Re: Replication Ideas |
Previous Message | Chris Travers | 2003-08-25 17:06:22 | Re: Replication Ideas |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2003-08-25 18:24:41 | Re: Replication Ideas |
Previous Message | Chris Travers | 2003-08-25 17:06:22 | Re: Replication Ideas |