From: | "Abdul Hayee Bhatti" <hayee(dot)bhatti(at)gmail(dot)com> |
---|---|
To: | "Alan Hodgson" <ahodgson(at)simkin(dot)ca>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Some Slony questions |
Date: | 2006-05-31 10:08:50 |
Message-ID: | e2f9348d0605310308y6c7b5314u6ce40119286adf85@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> 4. I'd like to have our updates go to the master and selects go to
> the clients. Is that possible?
You can use pgpool to achieve this (http://pgpool.projects.postgresql.org/)
Hayee
On 5/31/06, Alan Hodgson <ahodgson(at)simkin(dot)ca> wrote:
>
> On Tuesday 30 May 2006 21:13, Brendan Duddridge <brendan(at)clickspace(dot)com>
> wrote:
> > Hi,
> >
> > I apologize if this is the wrong list to post these questions.
> >
>
> There is a Slony list, but I'm sure there's some overlap
>
> > 1. Does Slony replicate table statistics to the slaves?
>
> No.
>
> > 2. Do you still have to vacuum analyze the slaves?
>
> Yes. All a subscriber basically is, is an otherwise normal PostgreSQL
> database that a Slony process happens to write data into.
>
> > 3. Are selects replicated or just inserts, updates, and deletes?
>
> Replication actions are scheduled on a row-level basis, via trigger, for
> each row inserted, updated, or deleted. Those actions are executed in an
> intelligent manner on the subscribers. Additional events, such as DDL
> modification scripts, can also be scheduled.
>
> However, to answer the question, just inserts, updates, and deletes.
>
> > 4. I'd like to have our updates go to the master and selects go to
> > the clients. Is that possible?
>
> Yep ... while keeping in mind that it is an asynchronous replication
> system,
> and the subscribers will not generally be in perfect sync with the master.
> You will need separate database connections since the setup doesn't appear
> as a single cluster or anything like that.
>
> > 5. What happens if an update tries to go to the slave? Does it
> > automatically get routed to the master?
>
> Tables on the subscribers are modified to prevent write ops. The
> subscriber
> table otherwise has no knowledge of the master. Operations are therefore
> not re-routable.
>
> I would strongly suggest setting up a test replication setup to learn
> exactly how Slony works before deciding on a particular architecture.
>
> --
> "When a politician says he wants you to serve a cause greater than your
> own self-interest, the cause he has is mind is his own reelection."
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2006-05-31 11:28:22 | Re: What is PostgreSQL 8.0 ?? |
Previous Message | Alan Hodgson | 2006-05-31 05:00:04 | Re: Some Slony questions |