HA, failover and load balancing / howto?

From: hanasaki <hanasaki(at)hanaden(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: HA, failover and load balancing / howto?
Date: 2007-08-04 04:42:35
Message-ID: 46B403BB.8080308@hanaden.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have some web applications and rich clients that need to
geographically localized copies (for network latency reasons) of a
database (East Coast, Central, West Coast and Japan) These will be
mostly read however there will be full CRUD activities going on. I
think this means that there will be a cluster in each region to deal
with load and single failures and when a whole region perhaps dies,
clients will fall back to another region.

ex:
4 servers for load East Coast
- db and webservers
4 servers for load Central USA Coast
- db and webservers
4 servers for load West Coast
- db and webservers

The web applications (Java, tomcat, ejb3, jboss4, php) If one one, or
more web or db servers die, the others in the region are still used (ie:
just 'degraded') If all the db servers die in a region, the web server
and applications will hit the db servers in another region)

How can all of this be setup and configured and how can failed db
servers be brought back online and updated to sync into the clusters?

Also looking at the pro/con of doing this in Postgres vs mysql

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rodrigo De León 2007-08-04 06:08:08 Re: Select question..... is there a way to do this?
Previous Message Karl Denninger 2007-08-04 04:17:53 Select question..... is there a way to do this?