Re: Data replication through disk replication

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Data replication through disk replication
Date: 2007-05-19 13:28:19
Message-ID: 20070519132819.GB13964@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 18, 2007 at 05:03:30PM -0700, Ben wrote:

> that all changes are replicated, it won't say an fsync is finished until
> it's finished on the remote host too, and it won't let you mount the block
> device on the slave system (at least with 0.7x).

How can it guarantee these things? The web pages say this:

If the primary node fails, heartbeat is switching the
secondary device into primary state and starts the
application there. (If you are using it with a non-journaling
FS this involves running fsck)

If the failed node comes up again, it is a new secondary node
and has to synchronise its content to the primary. This, of
course, will happen whithout interruption of service in the
background.

So what happens in those cases where the primary node gets in trouble
but isn't actually dead yet? I see a potential for a race condition
here that is really troubling to me. (Especially since it uses the
TCP/IP stack, which is notoriously subject to DoS on Linux.) I think
you really had better have something like STONITH running to use
this.

> In case you think it matters, IBM recommends DRBD for DB2.

IBM also sells HACMP. I refuse to comment on whether IBM's advice on
high availability products is worth taking seriously.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
The fact that technology doesn't work is no bar to success in the marketplace.
--Philip Greenspun

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2007-05-19 15:04:30 Re: Are foreign key's automatically set as indicies?
Previous Message ee e 2007-05-19 10:28:00 about the pgadmin3