Re: Geographic High-Availability/Replication

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Matthew wrote:
> 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.

No, but you are the only company that likely is trying to do it cross
continent ;) :).

You can not do multi master cross continent reliably. There are ways
using custom caches etc, to pull all session info into a geo-redundant
data store though.

Sincerely,

Joshua D. Drake

>
> Thanks,
> Matthew
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGzJ6HATb/zqfZUUQRAoSFAJ99sfzpgVjWYbtTKDIzC+EdChJRcQCgjTZQ
nKVW3xmmvQvjBltykxz8Gco=
=qv3s
-----END PGP SIGNATURE-----