Senior Sales Consultant Oracle Corporation
Oracle9i Real Application Clusters
Agenda?
? (interconnect) (clusterware)
Oracle9i Real Application Clusters computing is a breakthrough technology. The ability to dramatically scale an application without modification is an invaluable new proposition. Carl Olofson, IDC 2001
Real Application Clusters Architecture Network Low Latency Interconnect VIA or Proprietary No Single Point Of Failure Hub Switch Fabric Storage Area Network Drive and Exploit Industry Advances in Clustering
Oracle9i,
Out-of-the-Box Transparent Application Scalability Data Warehouse Parallel-enabled OLTP Full Cache Fusion Real Application Clusters
Full Cache Fusion Oracle9i Cache Fusion Interconnect Disk Disk I/O IPC Node A Database buffers Data Transfer Node B Database buffers Request Database
(Cache Fusion) Instance B instance A contention Global Cache Service (GCS) Request for Block Cache A Read Read Write Write Lock Status Block in Cache B Read Write Read Write
Cache Fusion 100 msec No Cache Fusion Cache Fusion 20 msec 1 msec.01 msec Block in Local Cache Block in Remote Cache Block on Disk
Pay and Scale Incrementally Single Server SRV 1 SRV 2 SRV 1 SRV 2 SRV 3 SRV 1 SRV 2 SRV 3 SRV 4 W o r k l o d 300% 200% 100% 3 6 9 12 15 18 21 24 Months
Lower TCO with Clusters $8.0 $7.0 $0.86 Cost in $M $6.0 $5.0 $4.0 $3.0 $0.58 $0.42 $3.61 $0.75 $4.67 Cost of Capital Consulting & Support Human Capital Costs Capital Expenditures $2.0 $1.0 $- $0.92 $0.93 Intel cluster Single server Linux TCO is 23.3% less than Single Server
Customer Success CERN save by standardizing on Linux and Real Application Clusters
World Record TPC-C on Windows 160000 120000 $18.46 tpmc $18.97 tpmc 80000 40000 0 Won t Say Oracle IBM DB2 MS SQL Server 8 node, 32 Processor Clustered Benchmark Source: Transaction Processing Council: HP ProLiant DL580R, 137,260.89 tpmc, $18.46/tpmC. Available 6/4/02 IBM eserver xseries 370 with 32 Intel Pentium III 900 MHz processors, 121,319.23 tpmc, $18.97/tpmC, available 5/31/01.
World Record TPC-C on Linux 160000 $17.21 tpmc 120000 80000 40000 Won t Say Can t Say 0 Oracle IBM DB2 MS SQL Server 8 node, 32 Processor Clustered Benchmark Source: Transaction Processing Council : As of 9/16/2002: HP ProLiant DL580R, with 32 Intel Pentium III 900 MHz processors, Oracle9i Database Release 2 with Real Application Clusters on Red Hat Linux Advanced Server, 138,362.025, $17.21/tpmC, available 03/05/03
E-Business Suite 11i Scalability 7,000 # Users 6,000 5,000 4,000 3,000 2,000 1,000 0 1,288 1 Node 2,296 4,368 5,433 6,496 2 Nodes 4 Nodes 5 Nodes 6 Nodes
SAP SD Standard Benchmark 12,000 10,000 12,000 # Users 8,000 6,000 4,000 2,000 3,640 6,580 0 1 Node 2 Nodes 4 Nodes SAP Standard 4.6 C Application Benchmark; Certification # 2002029, 2002030 & 2002031; June 3, 2002
Using Real Application Clusters, people are able to accomplish the kind of scaleability that they used to have to resort to high-end SMP systems for, using inexpensive commodity servers on Intel processors. Carl Olofson, IDC 2002
High Availability Failover : Concurrent processing Load balancing Fast time to recovery
Server Availability Challenge Server 1 Instance A Database A Server is a SINGLE point of failure
Clusters without RAC Server 1 Instance A Server 2 Database A Removes Server as SINGLE point of failure
Clusters with cold Failover Server 1 Server 2 Instance A Database A Restart single instance on Server 2
Real Application Clusters Server 1 Instance A Server 2 Instance A Database A SERVER failure - your database remains available Protect from SERVER failures
RAC vs Cold Failover? Failover Operation RAC Cold Reconfigure Group Membership Reconfigure Distributed Locks Failover Disk Volumes Restart Oracle Recover Oracle Warm Buffer Cache Total Failover Time 15 sec 5 sec 0 sec 0 sec 20 sec 0 sec < 60 sec 0 sec 0 sec Up to 20 min Up to 5 min 20 sec 10 + min > 35 min
Even Lower TCO with Clusters $14.0 $12.0 $1.31 Cost in $M $10.0 $8.0 $6.0 $4.0 $0.58 $0.42 $2.34 $1.65 $4.67 Cost of Capital Dow ntim e Costs Consulting & Support Human Capital Costs Capital Expenditures $2.0 $- $3.61 $0.92 $1.99 Intel cluster Single server Linux is 53.6% less than Single Server
Customer Success Vector SCM save costs & deliver 24 X 7 reliability with Oracle9i Real Application Clusters
Clustering Types Shared disk Runs real applications DB2 Shard Cache Fusion Oracle 9i RAC Shared nothing Only runs benchmarks Microsoft SQLServer DB2 UNIX & windows No SAP, Siebel, Peoplesoft A-Z A-F A-E G-L F-K M-R L-P S-Z Q-S T-Z
Shared Nothing Databases Maintenance problems Availability problems Performance problems Data A-E Data F-K Data L-S Data T-Z
: Shared Nothing Databases Shared Nothing Databases 1. 2. 3. 4. 5. 6. 7. 8. Need code change
Shared Cache Databases Availability AND scalability No code changes necessary Maintained like a single database Data A-Z
: Shared Cache Databases Shared Cache Databases 1. 2. Start instance No code change
What about the Competition? Clustered Feature Oracle9i IBM DB2 Microsoft SS2000 Sub-Minute System Failover Yes No No Transparent Application Failover Yes No No Automatic User Re-Connection Yes No No Support for ALL Applications Yes No No Multiple Platform Support Yes Limited No Availability AND Scalability Yes No No Single System Cluster Management Yes No Yes Add Nodes without Downtime Yes No No
Final Thought Those running Oracle, Dell, and Red Hat Linux have a price/performance advantage. Users can buy 4 four-way Dell servers running Oracle and Linux with exceptional performance for less than a 12 or 16-way proprietary SMP system at a hefty savings. Aberdeen Group, 2002
For More Information Product Information White Papers iseminars Customer References http://www.oracle.com/ip/rac_home.html