Re: Synchronous DB replication

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 14 Feb 2003 05:14:34 +1100
Message-ID: <pan.2003.02.13.18.14.34.197295@yahoo.com.au>

On Wed, 12 Feb 2003 22:41:59 +0000, Ralf Fernan wrote:

> Does using synchronous multimaster replication imply that every network
> link between N master sites has to be up, otherwise (if any of N-1 links
> is down) a transaction at a master site will fail? So in other words,
> such a system is actually less available than a non-replicated database?

It certainly does, which is why synchronous replication is very rarely implemented. Otherwise, a commit's not a commit until it's been applied to every master site. If one site's down, it's a rollback.

Regards
HJR Received on Thu Feb 13 2003 - 12:14:34 CST