Re: HA options - Mailing list pgsql-general

From Tim Uckun
Subject Re: HA options
Date
Msg-id CAGuHJrM1-LBjg9c6zaTwQF1fU969aRXd9Yj3kmfqGHaD7misrQ@mail.gmail.com
Whole thread Raw
In response to Re: HA options  (Alan Hodgson <ahodgson@reinvent.com>)
Responses Re: HA options  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
>
> I have a few clusters running on EC2 using DRBD to replicate between
> availability zones. It's not fast, but it works. If your write load is under
> 30MB/sec it's definitely an option. I run DRBD over SSH tunnels to get around
> the random IP address issue. I use heartbeat on top for resource
> management/failover (I know it's not ideal with the single communications
> path, but what can you do), and DDNS with really short TTLs.

If you have a howto or some documentation on how to get DRBD to work
with EC2 (or rackspace) I'd appreciate a link to it.

> I've also had success using the native replication to spin read-only slaves off
> those HA masters, using pgpool to load balance selects.

I think I am probably going to explore this option first.   I don't
know why automatic failover, failback, etc are not built in already. I
guess even connection pooling ought to be built in. Seems like
everybody would need that no?

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Re: Does Version 9.1 Streaming Replication Supports Multi-Master?
Next
From: Scott Marlowe
Date:
Subject: Re: Does Version 9.1 Streaming Replication Supports Multi-Master?