From oracle-l-bounce@freelists.org Mon Jul 12 12:52:15 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6CHq0d15128 for ; Mon, 12 Jul 2004 12:52:10 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6CHpn615105 for ; Mon, 12 Jul 2004 12:52:00 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A103072D4FB; Mon, 12 Jul 2004 12:32:27 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24248-87; Mon, 12 Jul 2004 12:32:27 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DED9872D45E; Mon, 12 Jul 2004 12:32:26 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 12 Jul 2004 12:31:01 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 758D072DE06 for ; Mon, 12 Jul 2004 12:31:01 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24518-43 for ; Mon, 12 Jul 2004 12:31:01 -0500 (EST) Received: from asmtp-a063f33.pas.sa.earthlink.net (asmtp-a063f33.pas.sa.earthlink.net [207.217.120.149]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2CE1F72DA05 for ; Mon, 12 Jul 2004 12:31:01 -0500 (EST) Received: from user-vcaurjs.dsl.mindspring.com ([216.175.110.124] helo=TerrySutton) by asmtp-a063f33.pas.sa.earthlink.net with asmtp (Exim 4.34) id 1Bk51d-00059P-3P for oracle-l@freelists.org; Mon, 12 Jul 2004 10:55:37 -0700 Message-ID: <0c4a01c46839$6ef17900$6601a8c0@TerrySutton> From: "Terry Sutton" To: References: <5164A49467308C45AD50661F8CFDC34319200D14@s30342g004004.wdc.cingular.net> Subject: Re: Master to Master Replication and availability Date: Mon, 12 Jul 2004 10:52:26 -0700 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-ELNK-Trace: 5830af7b3b91928f1aa676d7e74259b7b3291a7d08dfec79a9ad4615ba92281e13c5fb9b9b4358c6350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 216.175.110.124 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4883 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: terrysutton@usa.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I have a client using Master to Master successfully to increase availability. But be advised that synchronous doesn't increase availability, it decreases it. If either database is down, you can't complete transactions on the DB that's still up. --Terry ----- Original Message ----- Hey guys, Just curious here.. But "who" out there is using some sense of master-to-master replication of an OLTP application using to provide their clients a level of availability? So for example, two databases which would reside in geographically diverse data centers with synchronous replication :-) I'm not a big fan of master-to-master synchronous replication (nor async replication) as I believe the complexity and operational overhead would far exceed providing a Stand By Database (Data Guard). But I'm looking for some feedback/experience from the folks on the mailing list. Thanks in advance!! Greg Loughmiller ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------