pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-admin@postgresql.org
Subject: Re: High Avaliable in the PostgreSQL.
Date: Thu, 31 May 2007 10:43:12 -0400
Message-ID: <20070531144312.GE19737@phlogiston.dyndns.org> (raw)
In-Reply-To: <1c66bda80705302230p7ed40acam8f39e3fea2a00ac6@mail.gmail.com>
References: <20070530164208.2657ee91@localhost>
	<1c66bda80705302230p7ed40acam8f39e3fea2a00ac6@mail.gmail.com>

On Thu, May 31, 2007 at 05:30:20PM +1200, adey wrote:
> HP was providing CA (Continuous Access) software that was claimed to provide
> WAN SAN replication by repeating IO in exactly the sequence it was generated
> on the master, to the slave. 

The CA stuff, or anything else built on FCIP, is pretty cool, but I'd
worry a little about latency.  Certainly your costs are going to be
high on transit, but if the data and uptime are worth it, you could
do it.  The big issue here is the same as in any other
failover-to-other-node case -- you have to be _super_ sure that the
failing master writer is dead and disconnected, and across a wide
area, this is going to be very tough to do.  I think you'd have to
spend a fair amount of time doing risk analysis of conflicting
commits happening in both sites (if the WAN link goes down because,
say, some genius decides to run a backhoe through the fiber going out
of your "primary" city, you could find your secondary site decides to
promote itself.  But the primary site might still have transactions
in flight.)

> system. I'm not sure this would be sufficient for 99.9% uptime though, as
> there would be some startup requirements on the slave.

Right, and the requirement was actually upped to 99.99%, which is
approximately 1 hour of allowable downtime a year.  That is a very
high bar.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Users never remark, "Wow, this software may be buggy and hard 
to use, but at least there is a lot of code underneath."
		--Damien Katz



view thread (8+ messages)

Message-ID: <20070531144312.GE19737@phlogiston.dyndns.org>
Permalink:  ../20070531144312.GE19737@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20070531144312.GE19737@phlogiston.dyndns.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ajs@crankycanuck.ca
  Subject: Re: High Avaliable in the PostgreSQL.
  In-Reply-To: <20070531144312.GE19737@phlogiston.dyndns.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox