Re: Question: Clustering & Load Balancing

From: Michal Taborsky - Internet Mall <michal(dot)taborsky(at)mall(dot)cz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Question: Clustering & Load Balancing
Date: 2006-12-20 15:50:03
Message-ID: 45895BAB.9040203@mall.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

CARMODA napsal(a):
> has anyone here had any good/bad experiences clustering & load balancing
> a PostgreSQL server on Redhat (ES)?

We have recently successfully rolled-out a solution consisting of two
PostgreSQL database backends replicated by Slony. The backends are
accessed from a bunch of application servers (Apache) via pgpool. We
have some shell scripts around it to handle monitoring, failover and
switch-over. It is built on CentOS4 (ie. RedHat ES4). It's pretty solid.

--
Michal Táborský
chief systems architect
Internet Mall, a.s.
<http://www.MALL.cz>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Sebastián Baioni 2006-12-22 14:32:09 Backup/Restore too slow
Previous Message Tom Lane 2006-12-20 15:36:38 Re: GROUP BY vs DISTINCT