1 / 38

Oracle Real Application Clusters 10 g : The Fourth Generation

Session id: 40131. Oracle Real Application Clusters 10 g : The Fourth Generation. Angelo Pruscino Oracle Corporation. Agenda. The Generations Key IT imperatives Roadmap to Enterprise Grids Where We Are Now Oracle9 i RAC HA and Scalability Low Cost Clusters Next Steps

nubia
Download Presentation

Oracle Real Application Clusters 10 g : The Fourth Generation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Session id: 40131 Oracle Real Application Clusters 10g: The Fourth Generation Angelo Pruscino Oracle Corporation

  2. Agenda • The Generations • Key IT imperatives • Roadmap to Enterprise Grids • Where We Are Now • Oracle9i RAC HA and Scalability • Low Cost Clusters • Next Steps • Oracle RAC 10g Manageability “RAC for Everyone”

  3. Be Adaptive Proactive Agile 4 Enterprise Grids Consolidate 3 Reach Your Customer Big SMP And Clusters 2 Know Your Customer Internet And e-Commerce 1 BI and CRM The Generations

  4. Key IT Imperatives • Highest Quality of Service • Maximum availability • Maximum scalability • Most Efficient Management • Do much more • Lowest Cost • With much less Enterprise Grids

  5. Adaptive Proactive Agile Roadmap Enterprise Grids RAC 10g For Everyone Most Efficient Management Now Oracle9i RAC HA & Scalability Low Cost Clusters Highest Quality Service Lowest Cost

  6. Storage Area Network Mirrored Disk Subsystem Oracle9i RAC HA & Scalability Centralized Management Console Users • Full Cache Fusion • Cache-to-cache data shipping • Shared cache eliminatesslow I/O • Enhanced IPC • Allows flexibleand transparent deployment • Scale-up/Scale-out Low Latency Interconnect VIA or Proprietary Cache Fusion High Speed Switch or Interconnect ClusteredDatabase Servers Shared Cache Hub or Switch Fabric

  7. Oracle9i RAC HA Failover Operation RAC ‘Cold’ Reconfigure Group Membership 15 sec 0 sec Reconfigure Distributed Locks 5 sec 0 sec Failover Disk Volumes 0 sec Up to 20 min Restart Oracle 0 sec Up to 5 min Recover Oracle 20 sec 20 sec Warm Buffer Cache 0 sec 5 + min Total Failover Time < 60 sec* > 30 min * Oracle RAC 10g failover time < 8 sec

  8. Oracle9i RAC SAP Scalability SD 3-Tier Parallel Benchmark Results Now Official 82% Scalability # Users Certified Running on HPQ AlphaServer Computers

  9. Oracle9i RAC E-Business Suite Scalability 84% Scalability Oracle11i E-Business Suite Benchmark 6,496 5,433 4,368* # Users 2,296* 1,288 Running on HP Computers *Audited

  10. Oracle9i RAC OLAP Scalability75x better than the nearest competitor World Record Performance 85,719 Analytic Queries Per Minute (AQM) 1,135 Can’t Say Source: DSS Lab, 2003

  11. Oracle9i RAC Momentum • 2,500+ NEW customers • 550+ documented production customers • 175+ production customer references • 16% of new DB customers are RAC customers • 20% of RAC deals are from repeat customers RAC IS PROVEN

  12. Component Large RISC SMP Server RISC SMP Cluster Intel/Linux Cluster # Servers 1 8 8 Processors/Server 32 @1.3Ghz 4 @1.2Ghz 4 @2Ghz Memory/Server 64Gb 8Gb 8Gb Operating System UNIX UNIX RedHat AS Total Cost $1,250,000 $431,960 $232,664 Source: hardware vendor price lists Low Cost Clusters

  13. SMP Electronic Arts ROI • Takes into account: • Hardware costs • Software costs • H&S maintenance • DBA costs • SysAdmin costs RAC IS PROVEN 1st Year Big SMP is 35%+ More Expensive 5 Years Big SMP is 46%+ More Expensive

  14. Next Steps: RAC 10g Manageability • Key part of much larger Oracle Database effort • Oracle9i -> reduced operational costs by half • The Oracle Database 10g -> reducing by another half • Advanced functionality that has been totally automated: • Rollback Segment Management – enables highly efficient support for mixed OLTP/DSS workloads (Oracle9i) • Backup & Recovery – provides mission critical protection from media failures and corruptions (Oracle9i) • Memory Buffer Management – key enabler of high performance and scalability (Oracle9i and Oracle Database10g) • Automatic Storage Management – automatically balances I/O across disks for maximum performance (Oracle Database 10g)

  15. Next Steps: RAC 10g For Everyone • Eliminate need for 3rd party components that add significantly to complexity and cost • Single system image management • Automation of workload management • Full integration with other key Oracle features • New and improved verification and diagnostic tools • Zero downtime patches • Performance improvements

  16. Applications RAC, Other Apps Services Framework Cluster Control/Recovery APIs Automatic Storage Management Messaging and LockingMembership Connectivity Event Services Management APIs Hardware/OS Kernel RAC for Everyone – Integrated Clusterware • Complete Oracle cluster software solution • Single-vendor support • Low Cost • No need to purchase additional software • Easy to install, manage • High quality and functionality across all platforms • Large number of nodes • Common event and management api’s • Multi-tier HA & minimal MTTR • Support for third-party clusterware

  17. RAC Enterprise Manager Integration • Service Consumer Page • Shows alerts for SLA violations • Cluster Page • Cluster Database Page • Performance Page

  18. RAC for Everyone – Server Provisioning • Provision software to many systems at once • Clone, store and distribute “known good” configurations • Automate patch and update management Enterprise Manager SoftwareInventory

  19. RAC for Everyone – Server Provisioning • Provision software to many systems at once • Clone, store and distribute “known good” configurations • Automate patch and update management Enterprise Manager SoftwareInventory

  20. Enterprise Grid – Workload Management • Hands-free allocation and re-allocation of servers to services based on rules • Automated routing of service requests to appropriate server with lowest load • On server failure, automated re-allocation of surviving servers to services • Works across all platforms

  21. Enterprise Grid – Workload Management Order Entry Spare Supply Chain Normal Server Allocation

  22. Enterprise Grid – Workload Management Order Entry Supply Chain End of Quarter

  23. Enterprise Grid – Workload Management Order Entry Spare Supply Chain Normal Server Allocation

  24. Enterprise Grid – Cluster Failure Order Entry Spare Supply Chain Server Fails

  25. Enterprise Grid – Cluster Failure Order Entry Supply Chain Reallocate Spare server to Order Entry

  26. Enterprise Grid – Cluster Failure Order Entry Spare Supply Chain Failed Server Restored

  27. Oracle 10g Clusterware iAS RAC ASM End-to-End Integration Load Balancing • Dynamic load balancing with Oracle Application Server 10g • Multiple SLA's satisfied on shared hardware • Self monitoring services • Automatic Workload Repository (AWR) measures end to end • Resource manager

  28. Oracle 10g Clusterware iAS RAC ASM End-to-End Integration Synchronized Recovery • End to end recovery without human intervention • < 8 second recovery time for database • Immediate recovery for mid-tiers • < 4 seconds from 15 minutes Self Correcting • Self verifying • Self diagnosing • Self correcting

  29. End-to-End Integration Disaster Recovery • Data Guard Broker central point of control • Automatic service re-provisioning • Seamlessly integrated • Maximum availability • iAS & customer integration • End-to-end min MTTR • Rolling Upgrade Oracle 10g Clusterware iAS Production RAC ASM Data Guard Broker Oracle 10g Clusterware iAS Standby RAC ASM

  30. Performance Enhancements • Dynamic file and lock affinity • Lower-overhead updates • Message aggregation • More efficient global cache • Fewer buffer copies • Less memory usage

  31. No Cost System Changes – Capacity on Demand • CPU • Add/remove CPUs on SMP online • Cluster Nodes • Add/remove cluster nodes online • No data movement needed • Memory • Grow and shrink shared memory and buffer cache online • Auto tuning of memory online • Disk • Add/remove disks online • Automatically rebalance • Move datafiles

  32. Oracle RAC 10g - Only Solution for Enterprise Grids • Mission Critical Quality of Service on Industry Standard, Low Cost Servers • Complete, Integrated Oracle Clusterware • Runs all Applications • Provides Capacity on Demand • RAC Made Easy for Everyone • Automatic Service Provisioning

  33. Next Steps…. • Recommended Oracle RAC sessions • Oracle RAC 10g Cluster: Diagnosis & Verification • Monday 4 pm, Room 104 • Oracle RAC 10g: Managing Your Cluster • Tuesday 11 am, Room 104 • Oracle RAC 10g: Running Mixed Workloads • Tuesday 4 pm, Room 104 • Oracle RAC 10g: Continuous Services for the Grid • Wednesday 11 am, Room 104 • Oracle RAC: Best Practices on Linux • Wednesday 1 pm, Room 104 • Oracle RAC: Customer Roundtable • Wednesday 4:30 pm, Room 104 • Real Application Cluster Guru Chat • Thursday 12 noon, Guru Lounge

  34. Next Steps…. • See RAC demos in Database DEMOgrounds • Manageability • High Availability • Scalability • Sims Online • Visit the RAC web sites for more information • http://otn.oracle.com/products/database/clustering • Also see online recordings of these presentations: • Oracle Database 10g: The Self-Managing Database • Richard Sarwal, Monday 1 pm, Moscone Rm 103 • Enterprise Manager: Making the Grid a Reality • Jay Rossiter, Monday 2:30 pm, Moscone Rm 103

  35. Q & Q U E S T I O N S A N S W E R S A

  36. Reminder – please complete the OracleWorld online session surveyThank you.

More Related