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

Federico Sevilla III jijo at free.net.ph
Fri Jul 16 06:10:35 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.


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.



More information about the drbd-user mailing list