Re: A Replication Idea - Mailing list pgsql-hackers

From Sean Chittenden
Subject Re: A Replication Idea
Date
Msg-id 20020220183919.A45785@ninja1.internal
Whole thread Raw
In response to A Replication Idea  (Orion Henry <orion@trustcommerce.com>)
List pgsql-hackers
>         It listens on port 5432.
>         It pools connections to both real databases.

Check out pgsql-replication.  They're doing something more complex,
but will get you the multi-master model that you're proposing.  It's
using a reliable multicast model based on the spread toolkit
(spread.org).



As for your idea, it sounds really good, but has two pit-falls that I
know of:

1) TCP latency could intorduce race conditions and data syncronization  problems.

2) transaction WAL log syncronization.

-sc

-- 
Sean Chittenden


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: SET NULL / SET NOT NULL
Next
From: Thomas Lockhart
Date:
Subject: Re: SET NULL / SET NOT NULL