pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Question: Clustering & Load Balancing
2+ messages / 2 participants
[nested] [flat]

* Question: Clustering & Load Balancing
@ 2006-12-20 11:25 CARMODA <carmoda@gmail.com>
  2006-12-20 15:50 ` Re: Question: Clustering & Load Balancing Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>
  0 siblings, 1 reply; 2+ messages in thread

From: CARMODA @ 2006-12-20 11:25 UTC (permalink / raw)
  To: pgsql-performance

Hi,

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

i have two identical servers with plenty of memory plus a nice disc 
array. the solution should have both redundancy and performance. BTW: 
it's a back end to a web based application in a high traffic situation.

i thought it might be sensible to use a redhat cluster rather than 
introduce another ingredient like PGCluster given we 'can' use a RH cluster.

any suggestions invited and appreciated.






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Question: Clustering & Load Balancing
  2006-12-20 11:25 Question: Clustering & Load Balancing CARMODA <carmoda@gmail.com>
@ 2006-12-20 15:50 ` Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>
  0 siblings, 0 replies; 2+ messages in thread

From: Michal Taborsky - Internet Mall @ 2006-12-20 15:50 UTC (permalink / raw)
  To: 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;




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-12-20 15:50 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-20 11:25 Question: Clustering & Load Balancing CARMODA <carmoda@gmail.com>
2006-12-20 15:50 ` Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>

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