1 / 42

Infrastructure of choice for Oracle Real Application Clusters

Infrastructure of choice for Oracle Real Application Clusters. Bob Ng, EMC Ravi Kumar, Dell Inc. Objectives of This Session. Oracle Real Application Cluster (Oracle RAC) on Linux EMC CLARiiON Storage platforms – value add for Oracle RAC environments.

yates
Download Presentation

Infrastructure of choice for Oracle Real Application Clusters

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. Infrastructure of choice for Oracle Real Application Clusters Bob Ng, EMC Ravi Kumar, Dell Inc

  2. Objectives of This Session • Oracle Real Application Cluster (Oracle RAC) on Linux • EMC CLARiiON Storage platforms – value add for Oracle RAC environments. • Dell | EMC - Oracle RAC joint configuration for Linux • Customer adoption and examples

  3. Linux Emphasis in Oracle Real Application Clusters • Drive down TCO for infrastructure running DB service • RAC technology emphasizes scaling out via clustering • RAC on Linux offers cost effective modular growth • Technical advantages of Linux for Oracle • Open source • Collaborate, contribute and influence • Strong alliance with OS delivery partners • Easier transition and adoption from UNIX to Linux

  4. EMC Support for Linux • EMC CLARiiON Application Solution team involvement • Working onsite at Oracle HQ with Linux team • EMC CLARiiON CX600 used in Oracle RAC Linux development • EMC Interoperability lab stepped up Linux qualifications • RH 2.1AS on many server platforms • EMC-qualified HBA drivers (e.g., QLOGIC, EMULEX) • PowerPath 3.0 under Red Hat 2.1AS • Oracle RAC as a special clustering technology • Oracle Cluster File System • Joint support service center with Oracle at Hopkinton

  5. Running Oracle RAC on EMC Clariion Storage Platforms • Boosted price performance of the Oracle RAC Linux solutions • Clariion hardware enhancements • New software features with the Clariion product line • ATA technology integration within Clariion system • Option to increase capacity at attractive cost level

  6. EMC Clariion Family at a Glance

  7. Investment Protection for Your Linux RAC Infrastructure Private Cluster Interconnect 2-Way FC direct Connect CX200

  8. CX600/CX400 Scaling Out to the Full RAC Configuration Cluster Private interconnect 4-way top end servers Switch

  9. EMC Clariion CX600 value to scaling Oracle RAC

  10. EMC Clariion CX600 value to scaling Oracle RAC

  11. EMC Clariion CX600 value to scaling Oracle RAC

  12. EMC Clariion CX600 value to scaling Oracle RAC

  13. EMC Clariion CX600 value to scaling Oracle RAC

  14. EMC Clariion CX600 value to scaling Oracle RAC

  15. EMC Clariion Software - Value to Oracle RAC / Linux • PowerPath • Enterprise level Multi-path I/O with load balancing • Snap View • “Instantaneous” stored data replication • Persistent snapshots (logical copies, reduced space requirement) • Business Continuance Volumes (Full replicas for performance critical work) • Enabling technology supporting a variety of rapid Oracle deployment options. Rapid cloning services jointly delivered by EMC/Oracle consulting (e.g. Oracle 11i Apps environment rapid cloning) • SAN Copy • Block storage copy between storage systems • Support for SAN Copy and MirrorView over IP

  16. CX600/CX400 EMC PowerPath Software with Oracle RAC Cluster Interconnect Brocade Switch SP-Aconnect SP-B connect

  17. Repurposing DB using split BCV Establish BCVs Repurposing BCV Gold backup BCV copy Backup RAC nodes Restore DB with fast reverse resynchronization EMC SnapView Software with Oracle RAC Linux servers Production DB Point-in-time BCV splits with Oracle in hot backup Production RAC nodes

  18. EMC SAN Copy Software with Oracle RAC PE6650 Production DB SV/BCV Second RAC nodes Production RAC nodes Target array Source array

  19. Standby DB files Standby logs (active/archive) Backup control files Standby control files Standby DB RAC nodes Using EMC SAN Copy to Setup an Oracle Standby DB PE6650 Production DB logs Production control files Production RAC nodes Standby site array Production site array

  20. EMC CLARiiON ATA technology • Integrated component of the CX product offering • Industry unique capability of co-existence with Fibre Channel disks within same storage system • Leverage all processing and caching features of the CX storage systems • Supported by all software that runs on the CX systems • Snap View, SAN Copy, MirrorView, etc. Session 36675, Wed, 9/10 ATA drives FC drives

  21. Linux Oracle RAC Supported Configuration • An Oracle concept initiated about three years ago • Emphasis on reduction in TCO • Rapid deployment • Reliability of deployment • Reliable support • Single-point acquisition, single-point support • Oracle/EMC/Dell collaboration on Dell Linux Oracle RAC Supported Configuration

  22. EMC Contribution and Support for Configuration • EMC CLARiiON Application Solution team involvement • Assist with component definition of configuration • Verify delivery • Provide backing support to Dell’s single-point-of-field support • Interoperability lab • Share product and qualification roadmap plan with Dell and Oracle • Prioritize effort to fit with joint delivery plans • Joint support service center with Oracle at Hopkinton • Fully leveraged to augment Oracle Unbreakable Linux support model

  23. Dell | EMC | Oracle Engineering Partnership History 2H 2002Over 22,000 Dell|Oracle installations in past year Oracle deploys 2,000 Dell servers in Oracle datacenters 1H 2002Dell Deploys Oracle 9i RAC for Order Management Dell | Oracle | Red Hat Launch Unbreakable Linux 2001Oracle begins migration to Linux on Dell within their datacenter Oracle pilots Dell in Oracle datacenter Dell announces Oracle9i RAC with EMC storage 2H 2003Dell SC 2.2 Dell SC 2.3 2000Oracle Linux development on Dell 1998First Dell | Oracle Products Launch Dell SC 2.0 Dell SC 2.1 1997Dell | Oracle Partnership Formed Dell SC 1.0 1999 1997 1998 2000 2001 1H 2002 2H 2002 1H 2003

  24. Dell | EMC | Oracle - Solutions History Q4 2003 Q3 2003 1H 2002 Q3 2002 Q2 2003 Q3 2003 Q4 2002 Q1 2003

  25. Dell | EMC | Oracle - Solutions History Q4 2003 Q3 2003 1H 2002 Q3 2002 Q2 2003 Q3 2003 Q4 2002 Q1 2003

  26. Dell | EMC | Oracle - Solutions History Q4 2003 Q3 2003 1H 2002 Q3 2002 Q2 2003 Q3 2003 Q4 2002 Q1 2003

  27. Dell | EMC | Oracle - Solutions History Q4 2003 Q3 2003 1H 2002 Q3 2002 Q2 2003 Q3 2003 Q4 2002 Q1 2003

  28. Dell | EMC | Oracle – Solutions Today Q4 2003 Q3 2003 1H 2002 Q3 2002 Q2 2003 Q3 2003 Q4 2002 Q1 2003

  29. Dell | EMC | Oracle - Solutions Today 1H 2004 Q4 2003 1H 2002 Q3 2002 Q2 2003 Q3 2003 Q4 2002 Q1 2003

  30. ? Dell | EMC | Oracle - Solutions Future 1H 2004 Q4 2003 1H 2002 Q3 2002 Q2 2003 Q3 2003 Q4 2002 Q1 2003

  31. CX600/CX400 A typical four node Dell Supported Configuration Dell PC5012 / PC5244 Cluster Interconnect PE6650 Brocade Switch

  32. Dell Linux Oracle RAC Supported Configuration • Emphasis on reduction in TCO • Rapid deployment • Reliability of deployment • Reliable support • Single-point acquisition, single-point support For more information: http://www.dell.com/oracle • A bundle that is ordered as a single SKU • Dell servers (2-4-8 nodes) • Dell Deployment Software Tools for Oracle • Dell | EMC CLARiiON storage and SAN switches • Installation service

  33. Dell Solution Components Oracle Test Focus Oracle Database Database OS/OCFS versions Red Hat AS Updates/Major Releases N-1 and/or OCFS N-1 Red Hat AS Updates/Major Release N and/or OCFS N Servers PE2650, 4600, 6600, 6650, 8450 PE2650, 4600, 6600, 6650 PERC 4/DC PERC 3/DC QLA2310 QLA2340 QLA2342 HBA / RAID Switch SW3200 SW3800 DA PV220S U160 PV220S U320 Storage FC4700-2 CX200 CX400 CX600 EMC Test Focus

  34. Dell Test Methodology: • Dell performs comprehensive tests on 9i RAC [Clusters of 2-8 nodes] and 9i DB [Single Node] products • Level 1 Testing [Functional Testing]: • Integration Testing [e.g. Oracle patches + OCFS + PowerPath] • Functional Testing [e.g. Install Wizard and Configuration Wizard] • Bounds / Coverage testing • Documentation testing • Level 2 Testing [Integration/Solution Testing]: • Performance, stress testing • Multiple HW Configurations [e.g. 2x2650, 4x6650, 8x8450, CX200,CX400, CX600 etc.,] • Destructive Testing while running stress test [e.g. PowerPath, Private interconnect] • Documentation testing

  35. Dell’s Oracle Solution Deliverables • Deployment CD-ROM kit • Contains all software / source / documentation to deploy Oracle product. • Installation Wizard • Installs Oracle and Red Hat 2.1 AS in a Turnkey fashion. • Live Install • Component of Installation Wizard, allows installation of Oracle on a pre-existing RH 2.1 AS system. • Configuration Wizard • Configuration framework for pre-Oracle OS/Oracle. • Deployment Guide, Howtos, white papers • Documentation bundle for the solution

  36. Oracle9iRAC: Lithonia LightingOracle 8i on W2K to Oracle 9iRAC on Linux • Applications • 4xPE2300’s • 9i Development Database • PE8450’s • 9iRAC Production Database • 4x PE6450 • 9iRAC Hot Spare • PE6450’s Dell|EMC SAN Switch Dell|EMC FC4700 + 3 Enclosures • Application Tier • Oracle 11i: HR, ERP(Financials), Payroll, Manufacturing* • 11.5.3 to 11.5.6 on W2K for 9i • Applications • 4xPE2300’s • Database Tier • Oracle8i on W2K • 8.1.7/W2K to 9i RAC/RH • Production Database • PE8450’s • Biz Issues: 1200 users load • Oracle/W2K had 4GB Mem Limit • 150 user capable: ea user = 4MB-6MB • Biz Solution: 1200 users + hi-availability • Oracle/Linux has 64GB Mem Limit • ~400 user capable on PE6450 • Oracle9i RAC RH cluster = ~1600 users • Convert PE8450 from Oracle8i/W2K to Oracle9i RH and use as development/test box Customer Requirement:

  37. FAA: Oracle 9iRAC on Linux • Deploying Oracle9iRAC solutions from Dell • Two node clusters running on PowerEdge 6450’s • Fiber Channel storage / SAN • Linux provides a solid platform and an easy transition from proprietary RISC architectures • Customer testimonial "The Oracle9i Real Application Clusters Certified Configuration for Dell will enable us to take advantage of a highly available, scalable solution that will truly simplify our database implementations, allowing us to operate more efficiently." Quote from John Kelly, database administrator and project manager with Kenrob & Associates, a technical contractor for the FAA command center

  38. Oracle9i RAC: Dell ITOracle 8i to Oracle 9iRAC on Linux • Enterprise Application • Sales ODS Software • Customers order from dell.com – ODS provide order status Production Database + Apps • Enterprise Database • Oracle8i • 9iRAC Production Database + Apps • 2x PE6450 • Biz Issues: TCO, Mission Critical and Scale • TCO: use Dell to reduce cost of Unix system • SPF, Single Point of Failure, w/ 1 system • Limited Scale-up for performance • Biz Solution: Lower TCO + hi-availability + scale • TCO = Dell hardware + Dell storage • High Availability = Oracle9iRAC • Scale-out = Oracle9iRAC Dell Storage Dell | EMC SAN Switch

  39. Summary • Dell | EMC | Oracle are committed to Linux • EMC and Dell Linux emphasis in sync with Oracle • EMC CLARiiON robustness, scaling, and performance • Key value addition to support Oracle RAC on Linux with meeting the Enterprise mission-critical challenges • Dell Linux Oracle Solutions Offerings: • Tremendous value as a new infrastructure acquisition for supporting Oracle database service • Pre-tested on a supportable hardware and software stack

  40. ORACLE Enterprise Linux Automated Storage Lower TCO Red Hat EMC2 Integrate and Deliver DELL Collaborating… The best choice for running your Oracle database on Linux

  41. Next Step • For more details on Dell’s Oracle Solutions: • http://dell.com/oracle • Session 40390 [Tue. 9/9 – Moscone 300 - 3:30 - 4:30PM] • Dell |Oracle Rapid deployment Techniques for Linux • Session 40379 [Mon. 9/8 – Moscone 301 - 11 - 12 PM] • Scaling-Out with Oracle Grid Computing on Dell Hardware • For more details on EMC storage solution for Oracle: • http://emc.com/oracle • Session 36675 [Wed. 9/10 – Moscone 304 - 8:30 - 9:30 AM] • Oracle 10G disk based backup and EMC ATA • Visit EMC (#1302) and Dell (#1726) booths to see demo of this system solution

  42. ? Questions ?

More Related