From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Proposal for a cascaded master-slave replication system |
Date: | 2003-11-11 22:01:06 |
Message-ID: | 3FB15C22.1080902@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Jan Wieck wrote:
> If you mean to configure the system to replicate rows to different
> destinations (slaves) based on arbitrary qualifications, no. I had
> thought about it, but it does not really fit into the "datacenter and
> failover" picture, so it is not required to meet the goals and adds
> unnecessary complexity.
>
> This sort of feature is much more important for a replication system
> designed for hundreds or thousands of sporadic, asynchronous
> multi-master systems, the typical "salesman on the street" kind of
> replication.
OK, thanks. This actually fits any kind of distributed application. We
have one that lives in our datacenters, but needs to replicate across
both fast LAN/MAN and slow WAN. It is multimaster in the sense that
individual data rows can be originated anywhere, but they are read-only
in nodes other than where they were originated. Anyway, I'm using a
hacked copy of dbmirror at the moment.
> First, it does not replicate single transactions. It replicates batches
> of them together. Since the transactions are already committed (and
> possibly some other depending on them too), there is no way - you loose Se.
OK, got it. Thanks.
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | John Gray | 2003-11-11 23:03:01 | Re: Changing xml in a database |
Previous Message | Richard Huxton | 2003-11-11 21:35:28 | Re: update slow |
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Karppinen | 2003-11-11 22:30:13 | Re: About the partial tarballs |
Previous Message | Christopher Browne | 2003-11-11 20:38:53 | Re: Proposal for a cascaded master-slave replication system |