On Tuesday, January 17, 2012 10:34:54 AM Tim Uckun wrote:
> http://www.drbd.org/ ??
> Built in hot standby and hand rolled scripts.
>
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.
I've also had success using the native replication to spin read-only slaves off
those HA masters, using pgpool to load balance selects.