Re: Pgpool questions - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: Pgpool questions
Date
Msg-id 20050425.234708.26274449.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Pgpool questions  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
> On Sun, 2005-04-24 at 00:53, Ron Mayer wrote:
> > Tatsuo Ishii wrote:
> > >>
> > >>Is there anyway to load balance selects to more than 2 servers? ex.  1 master with 2 slaves?  Run multiple
instances?
> > >
> > > It's on my TODO but will not be a trivial change.
> >
> > Could I set up 2 pairs of pgpool-balanced servers, and use a
> > third pgpool to load balance across the two pools?
> > Or is that just silly.
>
> I've actually thought of doing the same thing.  I can't see a reason why
> it wouldn't work.

Oh, cascading pgpool! Actually once I have tried it and it definitly
worked. The only concern is the overhead due to the cascading...
--
Tatsuo Ishii

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Pgpool questions
Next
From: "Brian Maguire"
Date:
Subject: Re: Pgpool questions