From: Jamie Tufnell <diesql@googlemail.com>
To: pgsql-admin@postgresql.org
Subject: Best option for expanding beyond 1 pg server in this situation
Date: Wed, 26 Nov 2008 14:48:01 +1100
Message-ID: <b0a4f3350811251948u21b90730p604d93a4b97c71c2@mail.gmail.com> (raw)
Hi,
We have been wanting to HA our pgsql server for some time now. We're
actually reaching the limits of our current server now, so there is a
pressing need to do something to ease the load too.
There are several individual solutions to both of these problems. I
was hoping I could get some advice from someone more experienced
though, about what the simplest most effective way of moving forward
would be? Hopefully I can squash both HA and LB with the same
solution.
So far I've narrowed it down to
Slony-I master/slave replication with failover
or
pgpool-II with heartbeat for failover. The pgpool-II configuration
matrix (http://pgpool.projects.postgresql.org/) isn't terribly clear
(there's no legend) but it leads me to believe failover and load
balancing are mutually exclusive options. Is that so?
About our environment: PostgreSQL 8.3. Over 90% reads. Low data
turnover on all tables involved in most of those reads. High data
turnover on a select few tables. Overall database size is quite small
(1GB).
Any advice/help much appreciated.
Jamie
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-admin@postgresql.org
Cc: diesql@googlemail.com
Subject: Re: Best option for expanding beyond 1 pg server in this situation
In-Reply-To: <b0a4f3350811251948u21b90730p604d93a4b97c71c2@mail.gmail.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