Christopher Browne cbbrowne
Mon Jul 25 16:54:32 PDT 2005
Andy wrote:

> Well, everybody's in vacation (I hope so) or there is no solution for
> me???

The answer is a bit of both.

I've been away, and will be away next week; no doubt others have been on
the run.

I'm not certain that there will be an answer that is entirely suitable
for you...

>From the description you give, it sounds as though you would like to
have the replicas operate somewhat independently, that is, for each site
to use the "local" DB as 'master,' and (maybe sporadically) have the
databases connect to one another to feed one another updates.

- Slony-I was NOT intended as a multimaster replication system, and
there are no plans to take it there.

- Slony-II will be a multimaster replication system, but I'm not sure it
will be particularly suited to your purpose.  The operating model
requires that the nodes be pretty tightly coupled; they will not run
well disconnected.  Disconnection from the cluster requires that a node
fall into a "read only" mode until it can renegotiate connection(s) and
get resynchronized.

I could imagine someone taking some release of Slony-I and hacking on it
(rather heavily) to create a multimaster system; definitely nontrivial,
and definitely not something I'm starting on today...


More information about the Slony1-general mailing list