| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Craig Bryden <postgresql(at)bryden(dot)co(dot)za> |
| Cc: | pgsql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Clustering Database Servers |
| Date: | 2005-05-09 19:42:01 |
| Message-ID: | 1115667720.3868.138.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2005-05-09 at 13:41, Craig Bryden wrote:
> Hi
>
> In MS SQL there is a concept of Clustering database servers. This allows for
> load balancing.
> Does PostgreSQL have a similar concept?
This really kinda depends on what you are tring to load balance. I/O,
parallel users, CPU intensive apps, etc...
Using pgpool and / or slony you can get the same basic effect.
Note that no clustering solution can improve both read and write speed
at the same time while ensuring referential integrity.
There are a few other methods for doing this, take a look through the
pgsql mailing list archives and google for other possible solutions.
As there is no single problem requiring clustering, there is no single
clustering solution that will answer all these problems.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wolfgang Keller | 2005-05-09 19:47:46 | Re: Adventures in Quest for GUI RAD |
| Previous Message | Tom Lane | 2005-05-09 19:38:47 | Re: Trigger that spawns forked process |