Oracle9i Real Application Clusters

Size: px

Start display at page:

Download "Oracle9i Real Application Clusters"

예원 도
6 years ago
Views:

2 Senior Sales Consultant Oracle Corporation

3 Oracle9i Real Application Clusters

4 Agenda?

5 ? (interconnect) (clusterware)

6 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

7 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

8 Oracle9i,

10 Out-of-the-Box Transparent Application Scalability Data Warehouse Parallel-enabled OLTP Full Cache Fusion Real Application Clusters

11 Full Cache Fusion Oracle9i Cache Fusion Interconnect Disk Disk I/O IPC Node A Database buffers Data Transfer Node B Database buffers Request Database

12 (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

13 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

14 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% Months

15 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

16 Customer Success CERN save by standardizing on Linux and Real Application Clusters

17 World Record TPC-C on Windows $18.46 tpmc $18.97 tpmc Won t Say Oracle IBM DB2 MS SQL Server 8 node, 32 Processor Clustered Benchmark Source: Transaction Processing Council: HP ProLiant DL580R, 137, tpmc, $18.46/tpmC. Available 6/4/02 IBM eserver xseries 370 with 32 Intel Pentium III 900 MHz processors, 121, tpmc, $18.97/tpmC, available 5/31/01.

18 World Record TPC-C on Linux $17.21 tpmc 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, , $17.21/tpmC, available 03/05/03

19 E-Business Suite 11i Scalability 7,000 # Users 6,000 5,000 4,000 3,000 2,000 1, ,288 1 Node 2,296 4,368 5,433 6,496 2 Nodes 4 Nodes 5 Nodes 6 Nodes

20 SAP SD Standard Benchmark 12,000 10,000 12,000 # Users 8,000 6,000 4,000 2,000 3,640 6, Node 2 Nodes 4 Nodes SAP Standard 4.6 C Application Benchmark; Certification # , & ; June 3, 2002

21 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

22 High Availability Failover : Concurrent processing Load balancing Fast time to recovery

23 Server Availability Challenge Server 1 Instance A Database A Server is a SINGLE point of failure

24 Clusters without RAC Server 1 Instance A Server 2 Database A Removes Server as SINGLE point of failure

25 Clusters with cold Failover Server 1 Server 2 Instance A Database A Restart single instance on Server 2

26 Real Application Clusters Server 1 Instance A Server 2 Instance A Database A SERVER failure - your database remains available Protect from SERVER failures

27 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

28 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

29 Customer Success Vector SCM save costs & deliver 24 X 7 reliability with Oracle9i Real Application Clusters

30 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

31 Shared Nothing Databases Maintenance problems Availability problems Performance problems Data A-E Data F-K Data L-S Data T-Z

32 : Shared Nothing Databases Shared Nothing Databases Need code change

33 Shared Cache Databases Availability AND scalability No code changes necessary Maintained like a single database Data A-Z

34 : Shared Cache Databases Shared Cache Databases Start instance No code change

35 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

36 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

37 For More Information Product Information White Papers iseminars Customer References

Backup Exec

Backup Exec (sjin.kim@veritas.com) www.veritas veritas.co..co.kr ? 24 X 7 X 365 Global Data Access.. 100% Storage Used Terabytes 9 8 7 6 5 4 3 2 1 0 2000 2001 2002 2003 IDC (TB) 93%. 199693,000 TB 2000831,000 TB.