| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | smarlowe(at)g2switchworks(dot)com |
| Cc: | rm_pg(at)cheapcomplexdevices(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Pgpool questions |
| Date: | 2005-04-25 14:47:08 |
| Message-ID: | 20050425.234708.26274449.t-ishii@sra.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Maguire | 2005-04-25 14:51:17 | Re: Pgpool questions |
| Previous Message | Scott Marlowe | 2005-04-25 14:38:56 | Re: Pgpool questions |