From: | Marc Evans <Marc(at)SoftwareHackery(dot)Com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | database replication |
Date: | 2006-09-02 14:32:57 |
Message-ID: | 20060902102657.L22986@me.softwarehackery.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello -
I am curious as to people's opinion about best practices in deployment of
pgsql in a high-availablity (HA) situation. By HA I mean that data loss
must be as close to zero as possible, and that web servers using the DB
need to be deployed in multiple geographic locations world-wide, to
provide for network availability.
In my mind, this suggests a need for a multi-master configuration, such as
that which can be achieved with pgcluster. I see redundency both within a
POP, as well as cross-POP. I am however concerned about the latency
implied by POP locations (let's assume a POP in the EU, US and JP).
I am aware of bizgress, though am concerned that it doesn't really address
the wide-area replication issue. It does address the HA aspect within a
single POP quite nicely though.
How do you deal with this, commerical or OSS?
Thanks in advance for suggestions.
- Marc
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-09-02 14:51:04 | Re: Thought provoking piece on NetBSD |
Previous Message | Ron Johnson | 2006-09-02 14:16:54 | Re: Thought provoking piece on NetBSD |