From: Chris Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: performance of postgresql in replication using slony
Date: Thu, 26 Jul 2007 14:28:12 -0400
Message-ID: <60r6mv58ar.fsf@dba2.int.libertyrms.com> (raw)
References: <680184.79576.qm@web56612.mail.re3.yahoo.com>
<1185470505.10167.16.camel@dogma.ljc.laika.com>
pgsql@j-davis.com (Jeff Davis) writes:
> On Thu, 2007-07-26 at 01:44 -0700, angga erwina wrote:
>> Hi all,
>> whats the benefits of replication by using slony in
>> postgresql??
>> My office is separate in several difference place..its
>> about hundreds branch office in the difference
>> place..so any one can help me to replicate our dbase
>> by using slony?? and why slony??
>>
>
> This question should be asked on the slony1-general list, you'll get
> more responses there.
>
> The benefit of using slony is that you can read from many servers rather
> than just one.
Indeed.
It would be worth taking a peek at the documentation, notably the
introductory material, as that will give some idea as to whether
Slony-I is suitable at all for the desired purpose.
One thing that "tweaks" my antennae a bit is the mention of having
"hundreds branch office"; there are two things worth mentioning that
would be relevant to that:
- Slony-I is a single-master replication system, *not* a multimaster
system. If someone is expecting to do updates at branch offices, and
that this will propagate everywhere, that is likely not to work out
easily or well.
- If it *is* fair to assess that there will only be one "master",
Slony-I is intended to support a relatively limited number of nodes.
There are no absolute restrictions on numbers of subscribers, but
there are enough communications costs that grow in a polynomial
fashion that I would be quite disinclined to have more than a dozen
nodes in a cluster.
--
(reverse (concatenate 'string "ofni.sesabatadxunil" "@" "enworbbc"))
http://www3.sympatico.ca/cbbrowne/slony.html
HELP! I'm being attacked by a tenured professor!
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: performance of postgresql in replication using slony
In-Reply-To: <60r6mv58ar.fsf@dba2.int.libertyrms.com>
* 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