1 / 40

DB.NEXT With XTREMIO Transform Database Infrastructure

DB.NEXT With XTREMIO Transform Database Infrastructure. Vinay Gaonkar, Director of Products Kevin Closson , Office Of CTO. Roadmap Information Disclaimer.

rashad-morin
Download Presentation

DB.NEXT With XTREMIO Transform Database Infrastructure

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. DB.NEXTWith XTREMIOTransform Database Infrastructure Vinay Gaonkar, Director of Products Kevin Closson, Office Of CTO

  2. Roadmap Information Disclaimer • EMC makes no representation and undertakes no obligations with regard to product planning information, anticipated product characteristics, performance specifications, or anticipated release dates (collectively, “Roadmap Information”). • Roadmap Information is provided by EMC as an accommodation to the recipient solely for purposes of discussion and without intending to be bound thereby. • Roadmap information is EMC Restricted Confidential and is provided under the terms, conditions and restrictions defined in the EMC Non-Disclosure Agreement in place with your organization.

  3. What Is The One Thing You Know About This Car?

  4. Did you say ELECTRIC?

  5. It’s A Better Car! • Only one moving part • No oil changes • 0-60 in 4.4 sec • Lowest center of gravity • Silent • More interior space • No emissions • Five star crash ratings • Tax Rebates • Access to carpool lanes

  6. Not all Flash arrays are equal

  7. Flash Is Just Media • Consistent performance • Simpler to configure • No tuning Flasharrays need to harvest the power • More reliable • More space efficient • More cost efficient—really! • Entirely New capabilities

  8. Traditional Database Infrastructure - Complex “Starving” Test & Dev “Underperforming” Production “Over provisioned” Reports Dev Instance 1 Finance Copy Analytics Dev Instance 2 Operations Copy Trends Dev Instance 3 Sales Copy 3 copies for 30 engineers, 10K IOPS 10TB for 2TB DB, 50K+ IOPS 10 + DB copies, 20K IOPS Test/Dev Copies Data Mart Copies 14+ full copies to manage 50TB+ of storage to support 2TB of application data HR APP ERP APP SALES/ MARKETING APP Application Silos to manage hotspots

  9. To Summarize, The Problems Are… Applications Infrastructure • Unhappy users • Starving Test/Dev • Under-performing Data Marts • Cost • Unsatisfied database owners • Over-provisioned and under-performing storage • Copies and copies • Cost Database Infrastructure is complex and expensive

  10. Transform Database Infrastructure With XtremIO Flash Arrays • Accelerate • and Scale Database IOs • Consolidate Instances & Silos • Increase Efficiency& Reduce cost

  11. XtremIO Flash Array • Consistent performance • 150K1IOPS per X-Brick • Predictable low latency • Data Management • Unique Content-aware Data Protection • Data Reduction • Space-efficient Snapshots/clones • Encryption • Simple to manage and scale • 3-step provisioning—no tuning • Scaleout architecture One X-Brick 20TB (14.94TB2), 150K1 IOPS 1 8K 100% random read 2 Usable capacity without data reduction

  12. XtremIOScaleout Array • Linear scaling • Add additional X-Bricks for capacity and performance • Capacity and performance scale linearly • Single system • Managed as one array • Data management and reduction • Naturally balanced • Uniform LUN layout • Load balanced IOs One Array Four X-Brick Array 80TB2, 600K IOPS1 Two X-Brick Array 40TB2, 300K IOPS1 Single X-Brick Array 20TB2, 150K IOPS1 18K 100% random read 2Raw capacities

  13. Accelerate And Scale Database IOs Increase business value of the applications • Run transactions, analytics and reports faster • Consistent low latency • Increase queries/users, Broaden analytics scope • Use wasted DB cycles • Stop chasing hotspots • Consistent performance for any IO profile

  14. Why Don’t Applications Perform? “Underperforming” Production • Application databases produce variety of IOs • Constant high load sustained & random/sequential I/O • Huge user concurrency leads to random workload • Datasets are growing and becoming more random • Keeping up with data hotspots has become primary function • Disk/RAID types, caching, tiering can go only so far 2TB DB, 10TB Storage Many DB cores 30% CPU utilization 10-20ms App response time

  15. Chasing Hotspots 1. Different RAID groups 4. Different volumes 2. Different controllers 3. Different drive types 5. Different sizes

  16. Do you have application performance issues?

  17. A Typical I/O-Bound Server. Wasted CPU Cycles 4 hours wasted by high-latency single block random reads

  18. Complex Database Infrastructure Transformed Database Infrastructure High Performance Production Free, Fast DEV/TEST Free, Fast ANALYTICS Production Parent Volume 10+ copies, 20K IOPS 10TB storage for 2TB, 50K IOPS 3 copies for 30 engineers, 5K IOPS 2 0 TB total Storage space TB total XtremIO space 3 3 0 5 1 0 0 Dev/Test Instances Dev/Test Instances Full Copies Full Copies 2TB of Flash Capacity EVERY ENGINEER GETS AN INSTANCE INSTANT CREATION SCALE-OUT IOPS IN ABUNDANCE

  19. CMA Customer Profile Medical Analytics using Oracle RAC “Using XtremIO we are able to engineer our Oracle RAC systems to be faster, more scalable, and handle more concurrent users, while at the same time requiring only 20% of the previous footprint in our data center” Challenge • Extreme performance (6 GB/s large block random workload) • High Oracle licensing costs • Storage OpEx • Complex setup/tuning Solution • XtremIO All-Flash Array Results • 75% reduction in storage configuration time • Reduced space/power/cooling footprint • Reduction in server size/processor count & Oracle licenses • ~1.9GB/s bandwidth per X-Brick at <1ms latency Application • Largest Medicaid analytics database (Oracle RAC) in US • High user concurrency • Fast response time needed BRIAN DOUGHERTY Chief Data Warehouse Architect

  20. XtremIO Configures In Minutes One Screen – Zero Planning, Zero Tuning 3 1 2 CREATEINITIATOR GROUPS MAPVOLUMES CREATEVOLUMES

  21. Results-AWR Report Avg. latency went down by more than 70% CPU utilization doubled

  22. Fewer Cores Need To Be Licensed On XtremIO 60% 40% 60% 40% 60% CPU Utilization 40% 40% 60% 40% 60% 80% 48 licensed cores 32 licensed core

  23. Virtualize To Save More Cores 32 licensed cores 64 licensed cores

  24. Consolidate Instances And Silos Smaller infrastructure footprint, Reduced complexity • Reduce number of DB instances • Consistent latency and IOPS density • Deploy unlimited Test & Dev copies • Space efficient zero-cost snapshots & Data Reduction • Eliminate production copies for data warehousing • Instantaneous zero cost snapshots & IOPS density • Virtualize with confidence to increase agility and availability • IOPS density addresses IO blender issues

  25. “Do you have ‘end of quarter’ Crunch times?”

  26. Over-provisioned & Complex Data Warehouse Reports Analytics Trends • Concurrent ETLsto accelerate Sales Operations Finance ETL ETL • Multiple full copies of production on separate storage arrays • Copy process is long Copy Copy Production Database You still have crunch times

  27. Space Efficient Snapshots 1 OLTP LUN and 6 snapshots 1 LUN and 6 snapshots 1 OLTP Database LUN* Logs/database on 1 LUN

  28. Zero Cost Data Mart Copies Anytime! Used Capacity/IOPS 2TB 50K IOPs Used Capacity/IOPS 2TB 75K IOPs Used Capacity/IOPS 2TB 100K IOPs Used Capacity/IOPS 2TB 125K IOPs Used Capacity/IOPS 2TB 150K IOPs Financial Statements Production Marketing Insights Sales Reports Ops Analytics Instantaneous zero-cost snapshots Production Database (2TB) One X-Brick 150K IOPS • Faster report time • Consolidated DW/reporting infrastructure

  29. Virtualize ETL & Reporting servers To Further Consolidate Ops Analytics Financial Stmts Marketing Insights Sales Reporting Production Instantaneous zero-cost snapshots Production Database (2TB)

  30. “How many copies of DB do you keep for test and development?” “Not as many as we like”

  31. Test& DevIs Complex, Restrictive and Expensive Group of engineers share the copies • Full copies of production on separate re-purposed storage • Copy process is long Copy Copy Dev 1 Dev 2 Test 1 Test 2 Production Database Delays & compromised quality

  32. “If cost and complexity were not an issue, how many copies of your DB would you keep?” “One for each of my engineers”

  33. Investment Management Customer Profile Oracle Performance, Test & Dev Flexibility Enterprise Platforms Strategy Team Leader USER QUERY TIMES (Improvement) “THE CRUNCH” (BUSINESS PROCESS TIME) “The performance, ease of use, and snapshots make XtremIO a compelling addition to your IT service portfolio!” Challenges • Query response times • Business processing times • Development/Test database scale & performance Solution • XtremIO All-Flash Array • Production on One X-Brick • Test/Dev on 2 X-Brick cluster Results • 30% business process time improvement • 15-40% user query time improvement • CPU wait time reduced, utilization increased • Snapshots/Deduplicationfor dev/test give “free” database copies Application • Oracle 11G • High user concurrency • Fast response time needed • Large dev/test environment

  34. Unlimited Test & Dev Copies Anytime! Production Dev and Testing Servers Multiple DB copies Instantaneous zero-cost snapshots Production Database (2TB) One X-Brick 150K IOPS • Fully virtualized, improved flexibility and faster application deployment • Test and Dev uses same storage class as production

  35. Increase Efficiency & Reduce Cost • Provision and scale at ease • No tuning. Deploy application faster • Add capacity and performance linearly • Reduce server and licensing cost • Increased CPU utilization • Smaller infrastructure footprint • Increase efficiency of database infrastructure • Simplified infrastructure • More agile and flexible

  36. XtremIO Array Scales Out Linearly With Consolidation And Database Growth 4X 2X 1X One X-Brick (6U) 150K IOPS* Two X-Bricks (13U) 300K IOPS* Four X-Bricks (23U) 600K IOPS* *8K Random read IOPS

  37. Entire Virtualized Database Consolidated On A X-Brick Cluster Data Warehouse Test & Dev Financial Stmts Marketing Insights Sales Reporting Ops Analytics Production Multiple copies Instantaneous zero-cost snapshots Production Database (2TB)

  38. Entire Virtualized Database Infrastructure On XtremIO ERP APP HR APP Sales APP Test & Dev Test & Dev Test & Dev Sales Reporting Ops Analytics Financial Stmts Marketing Insights Sales Reporting Ops Analytics Financial Stmts Marketing Insights Sales Reporting Ops Analytics Financial Stmts Marketing Insights Production Production Production Production Database (2TB) Production Database (2TB) Production Database (2TB) Instantaneous zero-cost snapshots One array, Four X-Bricks 600K IOPS

  39. Question the status quo Over-provisioning Inefficiencies of existing methods Be the visionary and forward thinker! XtremIO as the key enabler of huge productivity gains Massive consolidation benefits Significant performance gains Be The Cause For The Change!

More Related