From gweber@cji.com Tue, 06 Feb 2001 11:53:18 -0800 From: "Gary Weber" Date: Tue, 06 Feb 2001 11:53:18 -0800 Subject: RE: OT RE: Async I/O on Windows - CacheFusion Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE CacheFusion is already available in 8i. They call it the first phase, or something along those lines. 8i version handles the redo blocks over the interconnect, whereas the 9i will also ship the actual data blocks. So, in theory, 9i OPS should perform MUCH better and scale easier, given the fast interconnect...   Gary Weber   -----Original Message-----From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Tony JohnsonSent: Tuesday, February 06, 2001 11:11 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE The whole idea behind 9i is CacheFusion which uses a high-speed interconnect to solve the pinging issues. At least that is the marketing line that will only be proved in time. Any database of any size should be using partititioning if you want it to perform and be able to manage it. ------------------------------------------------------------------------------Tony Johnson                                    Email  : tjohnson@griddata.comSenior Database Administrator                   Voice  : ( 480 ) 682 - 0849GridData                                        Cell   : ( 602 ) 363 - 7328                    7408 W. Detroit #100                            Fax    : ( 480 ) 961 - 8801Chandler, AZ 85226------------------------------------------------------------------------------Murphy's Data Constant:Data will be damaged in direct proportion to its value -----Original Message-----From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Mohan, RossSent: Tuesday, February 06, 2001 6:53 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE I understand the argument, Rodd and it raises three points/questions:   1) I can always back up a "state" ( part of a federation?) just like EMC/SRDF/BFD SAN does     for the Oracle solution, and at less cost, and   2) Do you believe you can simply "add nodes" to an OPS farm to improve performance? I have     personally never gone over a humble two nodes in OPS, and even then, locking issues must     be addressed. One way out of this is the geographically segregate and partition the data. But     this would be "federated."  In a pure play OPS scenario, I would imagine the system would     choke to death after the fourth or sixth node, without special tweaks like partitioning, either     by data or application.   3) Loss of a SS "state", just like loss of an oracle partition, does not "kill the operation of the system".     here, they are the same. ......   just a thought......            -----Original Message-----From: Holman, Rodney [mailto:rodney.holman@lodgenet.com]Sent: Tuesday, February 06, 2001 5:21 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE Ross, I was at the Open World conference session where Jeremy Burton made the comments about clustering, OPS, data segmentation, etc.  The data segmentation part was about MS SQLServer, and about how it creates significant work to add cluster nodes. C|net has their terms and comments a little scrambled. The Oracle 9i solution used OPS for the instances and an EMC/SRDF SAN for the data storage.  Each OPS cluster node had full access to every piece of data.  By doing this no node is a single point of failure (as Larry demonstrated and was chastised for by MS).  Also it creates greater capability for scalability.  Just configure and add a node and it improves performance (also part of Larry's demo).  As described with the MS federated database configuration you would need to resegment the data to add a node.  This would then destabilize the system even further by adding another single point of failure.  Failure of an OPS cluster node with the data on a SAN  with redundancy, such as the EMC/SRDF option, only decreases performance, it doesn't kill the operation of the system.   Rodd Holman -----Original Message-----From: Mohan, Ross [mailto:MohanR@STARS-SMI.com]Sent: Monday, February 05, 2001 5:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE Very Interesting!  It appears Oracle 9i, is, in fact, a Hybrid Federated Database! http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni A snippet: