| 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: | Whole Thread | Raw Message | 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
| 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 |