Geographic High-Availability/Replication

From: Matthew <mboehm(at)voilaip(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Geographic High-Availability/Replication
Date: 2007-08-22 20:27:55
Message-ID: 46CC9C4B.3020106@voilaip.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey all, new postgres user here. We are trying to setup/research an
HA/Replicated solution with Postrgresql between a datacenter in LA and a
d.c. in NY.

We have a private LAN link between the two D.C.'s with a max round-trip
of 150ms.

We will have a web server at each d.c. (among other servers) that will
write/read to/from the local LAN DB. On writes, that data should be
xmited to the other data center so that if, for whatever reason, my
website request was sent to LA instead of NY, all my session information
etc will still exist.

I was looking into PGCluster 1.7rc5 but their website states:

"...running one Cluster DB node in a different geographical location is
not what PGCluster was built for..."

Does anyone have an idea? We cannot possibly be the only company needing
to do this.

Thanks,
Matthew

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-08-22 20:37:27 Re: Geographic High-Availability/Replication
Previous Message Greg Smith 2007-08-22 20:18:26 Re: Postgres, fsync and RAID controller with 100M of internal cache & dedicated battery