Re: Synchronous DB replication

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 13 Feb 2003 20:44:38 -0000
Message-ID: <3e4d47a3_2@mk-nntp-1.news.uk.worldonline.com>

"Ralf Fernan" <ralphfernan.nospam_at_yahoo.com> wrote in message news:X4A2a.33693$rq4.2550682_at_bgtnsc05-news.ops.worldnet.att.net...
> 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?
>
>

Yes, of course. Let's consider a single master site and a single DR site. If that's the business requirement, the master site can't continue. You have, in effect, told the master site "If you cannot save to the DR site, wait!" Because unless you do so, you cannot guarantee that your changes have been saved at the DR site.

You can't have it both ways.

Regards,
Paul Received on Thu Feb 13 2003 - 14:44:38 CST