Re: PostgreSQL clustering (shared disk) - Mailing list pgsql-general

From Mikko Partio
Subject Re: PostgreSQL clustering (shared disk)
Date
Msg-id 2ca799770708170318r8929b54g377171c644936e43@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL clustering (shared disk)  (Hannes Dorbath <light@theendofthetunnel.de>)
List pgsql-general


On 8/17/07, Hannes Dorbath <light@theendofthetunnel.de> wrote:
On 17.08.2007 11:12, Mikko Partio wrote:
> Maybe I'm just better off using the more simple (crude?) method of drbd +
> heartbeat?

Crude? Use what you like to use, but you should keep one thing in mind:
If you don't know the software you are running in each and every detail,
how it behaves in each and every situation you can think of, it's a bad
idea to use it in a HA setup.

You don't want to be one of those admins that just configured something
in a few days, moved production stuff on it and fail to recover from a
split brain situation. Setting up a HA environment is something you do
in months, not days, at least if you want to do it right. There is so
much that can go wrong, and so much to learn. Keep it simple.


Exactly my thoughts, as I have some experience with drbd and I know it works. My point was that since I have access to a san environment, a shared storage would be a more "elegant" solution, but as you pointed out it's probably better to stick to the method that feels most comfortable.

Thanks for your thoughts.

Regards

MP 


pgsql-general by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: PostgreSQL clustering (shared disk)
Next
From: Alban Hertroys
Date:
Subject: Re: [RESEND] Transaction auto-abort causes grief with Spring Framework