database replication

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

Responses

Browse pgsql-general by date

  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