[DRBD-user] Re: DRBD and Postgresql experience.

Jean-Guillaume LALANNE jeanguillaume.lalanne at capgemini.com
Fri Jul 16 11:05:17 CEST 2004

Note: "permalinks" may not be as permanent as we would like,
direct links of old sources may well be a few messages off.


Thanks a lot Federico for your quick feedback.
I think we gonna follow your way for Postgresql failover management.

Just the last question, which kind of load do you have onto your database ?

Cheers
Jean-Guillaume

-----Message d'origine-----
De : drbd-user-admin at linbit.com [mailto:drbd-user-admin at linbit.com]De la
part de Federico Sevilla III
Envoye : vendredi 16 juillet 2004 06:11
A : Jean-Guillaume LALANNE
Cc : DRBD Mailing List
Objet : [DRBD-user] Re: DRBD and Postgresql experience.


Hi Jean-Guillaume,
(cc DRBD mailing list)

On Thu, Jul 15, 2004 at 05:17:03PM +0200, Jean-Guillaume LALANNE wrote:
> I have seen your post on the DRBD mailing-list dated from the Friday,
> 7 May 2004.  And because I have seen that you have been successfull
> installing DRBD and POSTGRESQL in a production environment, I am
> contacting you if this solution is still acceptable?  Have you got
> problems since your post?  Do you have tried to install Heartbeat also
> for managing fail-over mechanism?
> 
> I am currently trying to find out an high availibility architecture
> for a Postgresql box and I am wondering if DRBD could be the
> replication solution I am looking for

We have a solution using Debian GNU/Linux, DRBD, Heartbeat, PostgreSQL
and Mon and continue to be happy with its performance in a production
environment (one of the biggest hypermarts in the Philippines). I
continue to recommend this solution to clients who need highly-available
PostgreSQL servers. My only qualm with this setup is that one of the two
nodes will always be idle, and that's a waste in my opinion.

What would be great is if PostgreSQL had an active/active clustering
solution that does load balancing and failover on its own. I don't see
any acceptable implementation of this at the moment, though, so
active/inactive using Heartbeat and DRBD is still the way to go.

 --> Jijo

-- 
Federico Sevilla III : jijo.free.net.ph : When we speak of free software
GNU/Linux Specialist : GnuPG 0x93B746BE : we refer to freedom, not price.
_______________________________________________
drbd-user mailing list
drbd-user at lists.linbit.com
http://lists.linbit.com/mailman/listinfo/drbd-user


Our name has changed.  Please update your address book to the following format: "recipient at capgemini.com".

This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient,  you are not authorized to read, print, retain, copy, disseminate,  distribute, or use this message or any part thereof. If you receive this  message in error, please notify the sender immediately and delete all  copies of this message.




More information about the drbd-user mailing list