Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 20463 invoked from network); 4 Apr 2007 08:43:15 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 4 Apr 2007 08:43:14 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2C2A8698A1B; Wed, 4 Apr 2007 09:41:42 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16757-09; Wed, 4 Apr 2007 09:41:42 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 94AFE698A82; Wed, 4 Apr 2007 09:41:41 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 04 Apr 2007 09:03:57 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B43CD6983D3 for ; Wed, 4 Apr 2007 09:03:57 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11776-04 for ; Wed, 4 Apr 2007 09:03:57 -0400 (EDT) Received: from sccrmhc15.comcast.net (sccrmhc15.comcast.net [63.240.77.85]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E767E698442 for ; Wed, 4 Apr 2007 09:03:54 -0400 (EDT) Received: from smailcenter57.comcast.net ([204.127.205.157]) by comcast.net (sccrmhc15) with SMTP id <20070404130523015008ktdde>; Wed, 4 Apr 2007 13:05:23 +0000 Received: from [65.217.55.12] by smailcenter57.comcast.net; Wed, 04 Apr 2007 13:05:23 +0000 From: ryan_gaffuri@comcast.net To: mzito@gridapp.com, Cc: "Matthew Zito" Subject: RE: Active/Active Site A/Site B using SRDF Date: Wed, 04 Apr 2007 13:05:23 +0000 Message-Id: <040420071305.25679.4613A293000139430000644F2205886014079D9A00000E09A1020E979D@comcast.net> X-Authenticated-Sender: cnlhbl9nYWZmdXJpQGNvbWNhc3QubmV0 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="NextPart_Webmail_9m3u9jl4l_25679_1175691923_0" X-archive-position: 47428 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: ryan_gaffuri@comcast.net Precedence: normal Reply-to: ryan_gaffuri@comcast.net List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net --NextPart_Webmail_9m3u9jl4l_25679_1175691923_0 Content-Type: text/plain Content-Transfer-Encoding: 8bit I think the original plan is to actually have two sets of database files on two sites. I dont see how that can possible work with oracle unless there is some kind of two way mirroring you can do with a SAN across a fibre, but I doubt it. -------------- Original message -------------- From: "Matthew Zito" EMC SRDF does not support active/active with neither synchronous nor asynchronous configurations. When you have an SRDF environment your R1s (near side) are writeable while your R2s (the far side) are not. If you want to do active/active sites, you can do a RAC stretch cluster using either long distance Fibre channel (bleh) or iSCSI (much better), or you can do things at an application level. Matt From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of ryan_gaffuri@comcast.net Sent: Tuesday, April 03, 2007 12:39 PM To: oracle-l@freelists.org Subject: Active/Active Site A/Site B using SRDF The SAN/Systems Administrators claim its possibly to have a Site A/Site B setup(at two locations). Use SRDF asynchronously to populate and keep both sites active. 1. I don't think its possible to actually write to sides(2 different databases) and still maintain transaction control? So at a minimum you write to just one site and then populate the secondary site. 2. If both sites are active and the population of the second site is asynchronous that implies that the second site will be slightly behind so if users query both sites then one user may get an inaccurate picture of the database. 3. Is it possible to have active/active with a synchronous SRDF? I would think that would affect performance. Since you can't end the transaction until both sides are applied. 4. I would think the better solution is to havea primary and failover with the load balancer having an exception handler so when Site A goes down, failover to site B. 5. If you want to use both sites to query, then you are better off identifying performance intensive queries such as reports and use the secondary site as a reporting database(unless Site A goes down, then site B handles everything) Even with all this you still have a single point of failure at your load balance since its the entry point or is there a way to multiplex this? This is long... not sure how to summarize this. --NextPart_Webmail_9m3u9jl4l_25679_1175691923_0 Content-Type: text/html Content-Transfer-Encoding: 8bit
 
I think the original plan is to actually have two sets of database files on two sites. I dont see how that can possible work with oracle unless there is some kind of two way mirroring you can do with a SAN across a fibre, but I doubt it.
 
 
-------------- Original message --------------
From: "Matthew Zito" <mzito@gridapp.com>
 
EMC SRDF does not support active/active with neither synchronous nor asynchronous configurations.  When you have an SRDF environment your R1s (near side) are writeable while your R2s (the far side) are not. 
 
If you want to do active/active sites, you can do a RAC stretch cluster using either long distance Fibre channel (bleh) or iSCSI (much better), or you can do things at an application level. 
 
Matt

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of ryan_gaffuri@comcast.net
Sent: Tuesday, April 03, 2007 12:39 PM
To: oracle-l@freelists.org
Subject: Active/Active Site A/Site B using SRDF

 
The SAN/Systems Administrators claim its possibly to have a Site A/Site B setup(at two locations). Use SRDF asynchronously to populate and keep both sites active.
 
1. I don't think its possible to actually write to sides(2 different databases) and still maintain transaction control? So at a minimum you write to just one site and then populate the secondary site.
2. If both sites are active and the population of the second site is asynchronous that implies that the second site will be slightly behind so if users query both sites then one user may get an inaccurate picture of the database.
3. Is it possible to have active/active with a synchronous SRDF? I would think that would affect performance. Since you can't end the transaction until both sides are applied.
4. I would think the better solution is to havea  primary and failover with the load balancer having an exception handler so when Site A goes down, failover to site B.
5. If you want to use both sites to query, then you are better off identifying performance intensive queries such as reports and use the secondary site as a reporting database(unless Site A goes down, then site B handles everything)
 
Even with all this you still have a single point of failure at your load balance since its the entry point or is there a way to multiplex this?
 
This is long... not sure how to summarize this.
--NextPart_Webmail_9m3u9jl4l_25679_1175691923_0-- -- http://www.freelists.org/webpage/oracle-l