1 / 20

RDS and Oracle 10g RAC Update

RDS and Oracle 10g RAC Update. Paul Tsien, Oracle. Agenda. Oracle Database10g RAC What is RDS (Reliable Datagram Sockets)? Open Source RDS for Linux Beta Customer Experience. Shared Database. Oracle Database 10g RAC.

kyros
Download Presentation

RDS and Oracle 10g RAC Update

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. RDS and Oracle 10g RAC Update Paul Tsien, Oracle

  2. Agenda • Oracle Database10g RAC • What is RDS (Reliable Datagram Sockets)? • Open Source RDS for Linux • Beta Customer Experience

  3. Shared Database Oracle Database 10g RAC • Oracle Database 10g Real Application Clusters (RAC) provides the ability to build an application platform from multiple systems that are clustered together • Allows applications to become • Highly scaleable • Highly available • Chosen to avoid a single node failure, causing application downtime • Eliminates a node as single point of failure Oracle Instance Oracle Instance Oracle Instance

  4. Users Cache Fusion Shared Cache Oracle Database 10g RAC • World’s best Scalability with Cache Fusion • Cache-to-cache data shipping • Scales off-the-shelf applications with no changes • World’s best Availability with Fast-Start Fault Recovery • Node failure is transparent to applications • Recovers from node failure in 17 seconds - workload independent • Pre-warmed cache speeds restart • Easily add and delete nodes The Ultimate Parallel Architecture

  5. Oracle Database 10g RAC • Existing Apps • Financials, MFG, HR and CRM • Collaboration Suite • In house developed • DSS • ISV Apps • Easy Migration • Improve Utilization Real Applications in a Real Grid! ERP CRM DW

  6. Oracle Database 10g RAC • RAC IPC • Thousands of processes • 200K+ associations (not connections) • 64 nodes • Oracle IPC Usage • New database functionality will significantly increase IPC utilization • Approach database I/O rates • Very large messages (8 MB +)

  7. What is RDS? • Vision • A low overhead, low latency, high bandwidth, ultra reliable, supportable, IPC protocol and transport system • Which matches Oracles existing IPC models for RAC communication • Optimized for transfers from 200 bytes to 8meg

  8. What is RDS? • Goal and Objective • Support for a reliable datagram IPC in OpenIB • Based on Socket API • Minimal code change / testing for Oracle • Failover inter HCA and intra HCA ports • Runs over IB, Ether, iWARP, etc • 2-6 month validation / certification for RAC

  9. What is RDS? • Reliable Datagram IPC • UDP – Oracle adds reliable delivery via user mode wire protocol engine • Two sockets per process, thousands of messages on wire • Slow sends times (windowing,acks,retrans) • Holds together but degenerates under CPU load • Well tested !

  10. What is RDS? • Available Options • uDAPL / itAPI – not supporting • IPOIB – high CPU overhead, same unreliable delivery (UDP) • SDP – connection oriented • We want to take our existing well tested UDP module, shutoff most of it to run over an O/S provided RD IPC

  11. What is RDS? • RD – Reliable Datagram IPC over IB • 50% less CPU than IPOIB, UDP • ½ Latency of UDP (no user-mode acks) • Within 5% of uDAPL thru-put using Oracle • Minimal code change – reduced our UDP module by 70% - removed windowing, acks, retransmissions, etc. • RDS driver ~ = 1k C lines (b-copy) • Decoupled from user-mode CPU loading • Passes all Oracle regression tests in < 2 wks !!!! • Supports fail-over across and within HCAs

  12. What is RDS? • RDS IPC over IB • Uses IB reliable connection (RC) • Node to Node level connection • User mode sockets share small pool of node to node RCs. • Formed either dynamically at send or at system startup

  13. Oracle Block Service Rate

  14. Service Response Time

  15. CPU Cost Per Block Served

  16. Open Source RDS for Linux • Open Source RDS • Oracle is building Open Source RDS for Linux http://oss.oracle.com/projects/rds/ • Oracle will support RDS on Linux • Oracle RDS will be pulled into OFED • Oracle RDS will support GigE, simple NICs and RDMA NICs (IB/iWARP)

  17. Open Source RDS for Linux • Status • Oracle is testing Open Source RDS on GigE • RDS on IB is in development • Beta testing with customers using SilverStorm RDS/IB stack • Very stable • Very good performance • RDS is supported by major tier one system vendors

  18. Open Source RDS for Linux

  19. Beta Customer Experience • Customer Requirements • Improve application performance (throughput, latency, etc.) • Maintain data availability • Lower TCO through commodity hardware without sacrificing performance or scalability • Want to implement Grid and Utility computing

  20. Beta Customer Experience • Results • RDS/IB shows significant real world application performance gains for certain workloads: DSS and mixed DSS/OLTP workloads • Throughput and latency • Customers are interested in unified fabric for cost and manageability reasons • Reservation/QoS is a concern • Joint customer Oracle World presentation on RDS (Session S281216, 10/23/2006 11AM)

More Related