Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 2005 9
Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005... 3 ORACLE REAL APPLICATION CLUSTERS... 4 SQLSERVER 2005... 5 SQLServer 2005... 5 SQLServer 2005... 7 Oracle Real Application Clusters... 8 SQLSERVER 2005... 10 SQLServer 2005... 10 SQLServer 2005... 10 Oracle Real Application Clusters... 11 SQLSERVER 2005... 12 SQLServer 2005... 12 SQLServer 2005... 12 Oracle Real Application Clusters... 12... 13 Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 2
Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 Microsoft 3 Federated Architecture Failover Clustering Architecture MS Cluster Server Microsoft SQL Server 2005 Database Mirroring Architecture Oracle Oracle Real Application Clusters10g Release 2 Oracle Real Application Clusters Oracle Federated Failover Clustering SQL Server Microsoft Database Mirroring SQLServer 2005 Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 3
ORACLE REAL APPLICATION CLUSTERS Microsoft SQLServer 2005 Real Application Clusters 1: Oracle Real Application Cluster Oracle RAC Unix Windows Linux 6 1 RAC 1 5 OLTP DSS Oracle Real Application Clusters CPU DSS Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 4
SQLSERVER 2005 SQL Server SQL Server SQL Server LAN 6 6 SQLServer 2: Microsoft SQLServer 2005 DBA UNION ALL Distributed SQL Microsoft DPV DPV Microsoft SQL Server Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 5
-- On Server1: CREATE TABLE Customers_33 (CustomerID INTEGER PRIMARY KEY CHECK (CustomerID BETWEEN 1 AND 32999),... -- Additional column definitions) -- On Server2: CREATE TABLE Customers_33 (CustomerID INTEGER PRIMARY KEY CHECK (CustomerID BETWEEN 33000 AND 65999),... -- Additional column definitions) -- On Server3: CREATE TABLE Customers_99 (CustomerID INTEGER PRIMARY KEY CHECK (CustomerID BETWEEN 66000 AND 99999),... -- Additional column definitions) http://msdn.microsoft.com/library/en-us/createdb/cm 8 des 06 17zr.asp DPV CREATE VIEW Customers AS SELECT * FROM CompanyDatabase.TableOwner.Customers_33 UNION ALL SELECT * FROM Server2.CompanyDatabase.TableOwner.Customers_66 UNION ALL SELECT * FROM Server3.CompanyDatabase.TableOwner.Customers_99 Microsoft TPC-C DPV TPC-C 9 7 Warehouse_ID DPV OLTP Peoplesoft 7,493 6,438 900 Oracle ebusiness (ERP)* 8,155 800 5,100 SAP 16,500 16,329 2,887 * Oracle E-Business Suite SQLServer Oracle E-Business Suite RA_Customers Customer_Number 1 Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 6
SAP PeopleSoft Oracle E-Business Suite PeopleSoft SAP SQLServer DPV 1 DPV OLTP SQLServer 2005 DBA DBA DBA SQLServer Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 7
DBA SQLServer OS SQLServer Microsoft SQLServer DPV DPV Microsoft DPV Microsoft TPC-C TPC-C TPC-C TCP -C -H Oracle Real Application Clusters Oracle Real Application Clusters RAC Oracle Real Application Clusters Oracle 1 RAC 1 Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 8
Oracle Real Application Clusters Oracle Real Application Clusters OS Oracle Real Application Clusters Oracle Real Application Clusters 1 RAC 1 RAC Fast Connection Failover RAC Linux HP http://www.tpc.org/tpcc/results/tpcc_result_detail.asp?id=103120803 Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 9
SQLSERVER 2005 SQL Server Microsoft Cluster Server MSCS Microsoft Microsoft MSCS SQLServer 3: Microsoft RAC 2 SQLServer 1 2 SQLServer 2005 SQLServer SQLServer SQLServer SQLServer 2005 1 1 SQLServer 2 1. 2 1 Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 10
2. 1 2 3. 1 IP 2 4. 1 2 5. 1 SQLServer 2 6. 2 SQLServer 7. SQLServer IP Oracle Real Application Clusters Oracle Real Application Clusters RAC MSCS MSCS Oracle Real Application Clusters 10g Release 2 100 1 RAC Fast Connection Failover Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 11
SQLSERVER 2005 SQL Server Mirror Oracle Data Guard 1 Microsoft 2005 SQLServer 2 SQLServer 2005 Microsoft 3 SQLServer 2 3 Witness Mirror 3 Witness SQLServer 2005 Data Guard Physical Standby Mirror Oracle Oracle Real Application Clusters Oracle Real Application Clusters Oracle Data Guard Oracle s High Availability Architecture 1 RAC Data Guard 1 Oracle s High Availability Architecture Web http://otn.oracle.co.jp/products/database/oracle10g/index.html Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 12
Microsoft TPC-C Oracle Real Application Clusters CPU 2 4 8 2 4 8 Microsoft SQLServer Oracle Real Application Clusters 1 100 Microsoft Oracle Data Guard Oracle Data Guard Oracle Real Application Clusters RAC RAC RAC Data Guard RAC lock-step Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 13
Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 2005 9 : Philip Newlan Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. : : +1.650.506.7000 : +1.650.506.7200 www.oracle.com Copyright 2005, Oracle. Oracle Oracle Corporation