RE: OT RE: Async I/O on Windows - CacheFusion

[Gary Weber]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tony Johnson
Sent: Tuesday, February 06, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L
Subject: 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  : [EMAIL PROTECTED]
Senior Database Administrator                   Voice  : ( 480 ) 682 - 0849
GridData                                        Cell   : ( 602 ) 363 - 7328                    
7408 W. Detroit #100                            Fax    : ( 480 ) 961 - 8801
Chandler, AZ 85226
------------------------------------------------------------------------------
Murphy's Data Constant:Data will be damaged in direct proportion to its value

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, Ross
Sent: Tuesday, February 06, 2001 6:53 AM
To: Multiple recipients of list ORACLE-L
Subject: 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:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 5:21 AM
To: Multiple recipients of list ORACLE-L
Subject: 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:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 5:09 PM
To: Multiple recipients of list ORACLE-L
Subject: 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: