Peter Childs wrote:
>
> On Wed, 3 Dec 2003, Alvaro Herrera wrote:
>
>> On Wed, Dec 03, 2003 at 08:41:40PM +0700, Chris Travers wrote:
>>
>> > It strikes me that, for many sorts of databases, multimaster synchronous
>> > replication is not the best solution for the reasons that Scott, Jan, et.
>> > al. have raised. I am wondering how commercial RDBMS's get arround this
>> > problem?
>>
>> Say, have you looked at the approach taken by postgres-r? It's supposed
>> to solve these problems, and unless I've missed something they are in
>> need of some manpower to port it to recent releases.
>>
>> I don't know the URL. It's on gborg somewhere though.
>>
>
> http://gborg.postgresql.org/project/pgreplication/projdisplay.php
>
> The way I under stand the fix is to have a two stage commit...
> This is from previous threads mind you.
You must have misunderstood something there. The whole idea of
Postgres-R is how to "avoid" the need for 2-phase commit in a
synchronous replication system.
Jan
>
> So its
>
> Client -> Server <Commit Transaction>
> Server -> Other Servers <Pre Commit>
> Other Servers -> Server <Ready to Commit>
> <Server Waits for all other servers to respond>
> Server -> Other Servers <Commit>
> Server -> Client <Commit Success or Not>
>
> Each query that makes a change needs to tell all other servers and
> get a responce.
>
> Oh yes and you need point in time backup to bring new servers up
> to date and crashed ones too.
>
> I really need point in time backup at the very least and would
> love to see all these features. These features are growing to beyond
> urgent now.... Less talk more action.
>
> Peter Childs
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #