From: Markus Schiltknecht <markus@bluegap.ch>
To: anorganic anorganic <anorganicphc@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Replication
Date: Thu, 04 Jan 2007 11:07:13 +0100
Message-ID: <459CD1D1.8010002@bluegap.ch> (raw)
In-Reply-To: <f616803e0701040140u18e27769r54ac39d79be29519@mail.gmail.com>
References: <f616803e0701040100p5958ee2dy56924ee326c23e0d@mail.gmail.com>
<459CC52A.4030208@bluegap.ch>
<f616803e0701040140u18e27769r54ac39d79be29519@mail.gmail.com>
Hi,
anorganic anorganic wrote:
>> did you check the manual about 'High Availability and Load
>> Balancing"?
>> http://www.postgresql.org/docs/8.2/static/high-availability.html
>
> yes but this was really short i think.
Interesting... where exactly is it to short for you? What else would you
expect?
> I need that: s1 and s2 must be multimaster replication asyn. but make
> replication in real time. Changes are immediately send to second server.
Slony can probably be used for such a setup, although it's primarily
designed for single master, async replication.
> OR: s1 is master s2 slave, s1 change some columns on s2, and s2 is
> master s1
> slave and s2 change another columns in one time.
I don't quite follow what you mean here. I assume you mean rows, not
columns. Then probably you mean something like what we call data
partitioning, where each server is a master for a certain subset of the
data.
> I read about slony but, it looks that's make changes not immediatly but in
> packages = not send one transaction but wait and send package. This
> could be a problem.
Hm. If that really is a problem, think again about sync vs. async. In
async replication, there is a delay by definition. But again, I'm not
sure what Slony can do to minimize that delay.
> I hope slony online system is right for me. And these question
> about slony i have more than one i think it could be rigth way. Somebody
> who run it could be great person for me :).
Probably ask on the slony mailing list. I'm not exactly a slony expert
either.
Regards
Markus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: markus@bluegap.ch, anorganicphc@gmail.com
Subject: Re: Replication
In-Reply-To: <459CD1D1.8010002@bluegap.ch>
References: <f616803e0701040100p5958ee2dy56924ee326c23e0d@mail.gmail.com> <459CC52A.4030208@bluegap.ch> <f616803e0701040140u18e27769r54ac39d79be29519@mail.gmail.com> <459CD1D1.8010002@bluegap.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox