Re: Postgres Clustering Options - Mailing list pgsql-general

From David Kerr
Subject Re: Postgres Clustering Options
Date
Msg-id 20091112234744.GM99174@mr-paradox.net
Whole thread Raw
In response to Re: Postgres Clustering Options  (Mikko Partio <mpartio@gmail.com>)
Responses Re: Postgres Clustering Options  (Mikko Partio <mpartio@gmail.com>)
List pgsql-general
On Thu, Nov 12, 2009 at 07:50:06AM +0200, Mikko Partio wrote:
- On Wed, Nov 11, 2009 at 7:28 PM, David Kerr <dmk@mr-paradox.net> wrote:
- > basically point to using a replication based solution, which i don't think
- > would meet my
- > performance demands.
- >
- > Does anyone have expereince with this or a similar setup that they could
- > share with me?
- >
-
-
- We have done a setup like this with Red Hat Cluster Suite.
-
- We are quite happy with the setup in general, and it has been working well
- even in 'unexpected circumstances' (power outages etc). The only thing I'd
- change in this setup if I could is the cluster software: RHCS is not mature
- enough and it seems every release contains new critical bugs, and sometimes
- even mission-critical components such as quorum disk do not work after an
- upgrade.
-
- Regards
-
- Mikko

Hi Mikko,

In your enviornment, are the applications able to recover automatically after
a DB failover?

For exmaple, we're using Java/JDBC connections +Geronimo we're researching whether
or not JDBC/Geronimo would be able to retry in the case of losing a connection to
the DB vs failing and crashing the app.

Dave

pgsql-general by date:

Previous
From: Jonathan
Date:
Subject: Re: Full Text Search 101?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: [pgeu-general] pgday.eu