1 / 29

Oracle Database via Direct NFS Client

Oracle Database via Direct NFS Client. Ideal for your high performance database environment. Bryce Cracco Senior Product Manager – Storage Kevin Jernigan Senior Director Product Management – Database Rob Giltrap Senior Storage Sales Consultant.

riley-bruce
Download Presentation

Oracle Database via Direct NFS Client

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. Oracle Database via Direct NFS Client Ideal for your high performance database environment Bryce Cracco Senior Product Manager – Storage Kevin Jernigan Senior Director Product Management – Database Rob Giltrap Senior Storage Sales Consultant

  2. Oracle ZFS Storage Appliance has Delivered Record Performance and Efficiency with both NAS and SAN Protocols Oracle Database Direct NFS Client is the Most Intelligent and Most Convenient Storage Interface Fast. Simple. Efficient. Co-Engineered for Optimal Performance.

  3. Direct NFS/NAS is a Best Practice for Modern Database Storage • Easy to deploy and administer • Easy to expand and change as application needs change • Simple networking: Runs over standard Ethernet • Less expensive (CAPEX and OPEX) than FC SAN • Shared filesystem for Real Application Cluster environments • Fast: Industry-leading “SAN” results on Oracle ZFS Storage Appliance with Ethernet

  4. Oracle IT and Oracle Cloud usage Global IT Customer IT Product Development IT • Comprehensive Cloud Products and Services for Business and IT • Supporting over 25M users in more than 4,000 environments • ~ 3.2 billion database transactions per hour; ~ 5.5 million business transactions per day • Product development operations • Supporting 22K+ developers building over 3K products globally • 10K hosts executing 90K jobs per day • 235K compute hours per day • Global voice, network infrastructure and data center operations • IT risk and compliance • Supporting 100K+ internal users and 1.2M+ external users in 145 countries 200PBs of Oracle ZFS Storage Appliance accessed via NAS

  5. Legacy Perception of NAS is Not Accurate • Perception of slower performance for NAS vs. SAN/FC • Used to be true, but things have changed, let’s get back to that in a minute… • Client configuration complexity • Used to need to tune and configure Database host OS NFS client • Higher CPU utilization • Belief this could be significant in highly resource constrained systems • Note that this was a much bigger deal in the ‘90s • Enterprise storage systems “worked better” as block arrays than as filers • These assertions are based on antiquated storage architectures

  6. Standard NFS Architecture Standard NFS client LGWR I/O queue NAS Storage Database Linux NFS client RPC daemon DBWR I/O queue … … … … PQ slave I/O queue Just 1 TCP connection per mount RMAN I/O queue Each Oracle process can issue 100s of concurrent I/Os RPC I/O daemon limits number of concurrent I/Os

  7. Oracle Direct NFS Eliminates Database NAS Challenges • An advanced NFS client inside Oracle Database • Dramatic performance improvements versus host OS NFS clients • Improves high availability of Database NAS implementations • Vastly reduces NAS CPU utilization impact • Simplifies NFS client management uniformly across different host OS platforms SAN (FC) Performance with NAS Cost and Manageability

  8. Direct NFS Architecture Direct NFS client LGWR I/O queue NAS Storage Database DBWR I/O queue LGWR TCP connection … … … … PQ slave I/O queue DBWR TCP connection RMAN I/O queue PQ slave TCP connection RMAN TCP connection Direct NFS can issue 1000s of concurrent operations due to the parallel architecture Every Oracle process has its own TCP connection

  9. Direct NFS Scalability and High Availability • Direct NFS improves HA and optimizes server scalability • Supports up to 4 parallel network paths to storage • Displays linear scaling over both 1GbE and 10GbE paths • Automatically load balances across all network paths • No extra configuration necessary • Failover messages in the event of a path failure 3 5 1 Automatic load balancing across all paths 7 6 2 Path 3 goes down 7 3 8 4

  10. Overcoming Traditional Database NAS Challenges Evolution of Enterprise NAS Systems • Enterprise NAS System evolution • Some modern NAS systems offer remarkable performance • Oracle ZFS Storage Appliance smashing benchmark results, supplanting FC arrays • 200 PBs of Oracle ZFS Storage Appliance, all NAS, at Oracle IT’s own data centers

  11. Original NAS Architecture NAS Clients Front End NAS Gateway Back End FC Arrays Ethernet FC • Gateway is a “bump in the wire” • May as well go straight to FC

  12. Antiquated NAS Architecture NAS Clients Storage “Product” Front End NAS Gateway Back End FC Arrays Ethernet FC • Sold as singlesystem • But still really a gateway • Still a “bump in the wire”

  13. Modern NAS / Unified Architecture • No “bump in the wire” for NAS • Less distinction between File versus Block data paths • High performance for both Block and File workloads • Protocol choice becomes a matter of management preference

  14. Direct NFS vs. FC Performance Compared Oracle ZFS Storage Appliance performance result example The performance of FC with the management simplicity and economics of NFS

  15. Evolution of Direct NFS – Database Aware Storage Building Intelligence Into Database Storage • File protocols (NAS) allow the Database to access an actual filesystem on storage, not just a LUN or abstracted volume • Possible to use a NAS framework to embed information that the storage can understand • Requires intelligence engineered into both the Database and storage to work as one system • Integration is an Oracle-on-Oracle advantage • How can we leverage the unique architecture of Oracle ZFS Storage?

  16. Oracle ZFS Storage Appliance Performance Architecture Powerful Enterprise Hardware Hybrid Storage Pool WRITE FLASH LRU MRU SLC NANDSync I/O Only 10K SAS-2 7.2K SAS-2 2TBDRAM LFU MFU AdaptiveI/O Staging SAS-2(15K, 10K, 7K) 12TB READ FLASH 4 Write SSDs per Tray (max) 2TB DRAM Adaptive Throttle AlgorithmDetermines Pipe Size 80 CoresProcessingPower 2TB DRAM 10K SAS-2 READ FLASH 12.8TBRead Flash (Evicted) MLC NANDL2ARC 10.5TBWrite Flash • Highly dynamic, tunable system for optimized performance • Advanced caching and intent logging features accelerate system performance

  17. Oracle Intelligent Storage Protocol • Database and Storage Co-engineering • Intelligence is in the code within both the database and storage • Available ONLY with Oracle Database 12c and Oracle ZFS Storage Appliance OS 8 and above • Storage Awareness of Database Workload • Database sends cues about each IO to the storage • Over 70 database IO types are recognized • Cues grouped into 5 distinct categories by storage • Information used by storage to adaptively and automatically adjust for optimal efficiency

  18. Get the most out of Oracle Database 12c Oracle ZFS Storage Appliance with Direct NFS – Start testing it now! • Proven, enterprise ready solutions with single point of support • Advanced Hybrid Storage Pool architecture • Optimal performance while minimizing hardware costs • Advanced storage snapshot integration, including at PDB level • Native Infiniband support for superior throughput • Oracle Intelligent Storage Protocol • Automated storage tuning • Hybrid Columnar Compression for data warehousing and archiving • Uniquely available with Oracle storage • Pair with ADO and Heat Map features for automated tiering

  19. Get the most out of Oracle Database 12c Direct NFS with Remote Direct Memory Access (RDMA) • New in Oracle Database 12c; available with next release of Exadata software • Retains all Direct NFS benefits • Implements NFS RDMA protocol over Infiniband • RDMA zero copy transfers eliminate buffer copies resulting in memory bus savings • RDMA hardware offloading frees up main system CPUs from networking tasks • Drastically reduced CPU utilization and improved response times • Increased bandwidth utilization due to massively parallel IO operations • Use Case: RMAN backup to ZFS Storage Appliance • Direct NFS over RDMA saturates Infiniband QDR (40Gb/s) pipes • High performance backup solution for Exadata systems

  20. “Using Direct NFS for our Oracle Database 12c environmentwith the Oracle ZFS Storage Applianceaccelerated our database performancewhile simplifying storage management.” • Duanne O’Brien, CTO, Loyalty NZ

  21. Loyalty New Zealand – Who We Are • Specialist loyalty marketing and data analytics company • Flagship programme, Fly Buys, is one of the world’s most successful loyalty programmes • Partnered with New Zealand’s leading brands • 2.5 million active card holders • Data is collected from around 100 million transactions every year • Over 400 million points given to cardholders every year

  22. Our Data Warehouse Environment • 16 Years of Data • 2.5 Million Active Cardholders • 9TB and Growing 800GB per Year • 5,767 Million Rows SKU • 1,240 Million Rows Points Transactions

  23. Transition From Old to New • Oracle DB 11g R1 • Oracle Linux 5 • HP Servers • EMC SAN • ASM • Oracle DB 12C • Oracle Linux 6.5 • Oracle X4-2 Server • Oracle ZS3-2 Storage • Direct NFS

  24. The Results • Basic Compression 3:1 • Total Space Reduction 9.7TB to 3.3TB • Full 1GB/s Throughput Over 10GbE • Warehouse query runtime reduction by 6x

  25. Storage Performance

More Related