Consolidate Database & Analytics Workloads on a Scal

Consolidate Database & Analytics Workloads on a Scale-Out All Flash-Array

Andy Fenselau

August 5, 2014

XtremIO

#1 All-Flash Array in the Market

>$100,000,000 <6 months >70PB sold

Redefine Your Data Center With XtremIO The Journey to The Private Cloud Part 2: Storage At Last! Phase One: Performance Phase Two: Phase Three:

Application acceleration Application Services Applications services Data Center Agility

Converged Infrastructure Agile Infrastructure: Pooled storage

Agile Intelligence: Real-time Analytics

Agile Innovation: Real-time Development

Architecture Matters

INTEGRATION Vblock VSPEX Replication/ App Mobility VMware DATA SERVICES Thin Provisioning Inline De-Duplication Flash + Inline data services + Scale-out + App Optimization Multi-path Failover Portfolio Integration Space-Efficient Encryption Storage-as-a-Service Snapshots Inline Compression Flash-specific Data Protection

80+% Capacity Utilization

Active/Active Controllers ARCHITECTURE Enterprise Grade Flash Purpose-built for Flash Scale-Out Design RDMA Backplane

Content-Based Metadata

What Customers Are Saying

“When you’re doing a 100,000 IOPS why wouldn’t I put everything on this? You get a boat-load of business value for OLTP. I’m having a hard time saying ‘why not?’ … I am looking for StarTrek technology. If we are going to get to that level, we can’t be twittling around in the details. We need things that just work. Between virtualization and the XtremIO we have boxes we just plug in. We don’t worry about that moving disk drives and creating LUNS. I think that is what’s going to allow us to get to the next level…We have to find a way to move everything over to it.” - Stew Gibson, CIO, USI Holdings

Database & Analytics Workloads

1 2 3 4

Breakthrough Consolidation: Dev/Test Lowest TCO:

Low-Latency Consistent Storage No Complex Setup

No Tuning Performance SAP Landscapes BI/Analytics Servers & Licensing OPEX

Case Study: Oracle ConsolidationXtremIO Snapshots’ Performance, Flexibility to Oracle 11gChallenges Daily Crunch business processing times struggling to update by opening hours Query response times Challenge for Development/Test scale, performance Monthly reporting time too slow, rigid

Solution XtremIO All-Flash Array Production on One X-Brick Test/Dev on 2 X-Brick cluster

Applications Oracle 11G, virtualized Linux, Windows High user concurrency Large dev/test environment

Results 60% business process time improvement for dai

ly“Crunch” 15-40% user query time improvement Monthly batch reporting time cut 50% 30% Oracle license savings as CPU wait time reduced, utilization increased DBAs“blown away”: DB seq read 34ms -> 0.3ms, cpu time improved 10%->96% 30% faster dev cycles- Snapshots/Deduplication give“free” performance database copies to all Additional consolidation for virtual servers& virtual desktops on same XtremIO Planning complete block storage consolidation for new datacenter@ 54% lower cost and 70% smaller footprint

100 80 60 40 20 0

(BUSINESS PROCESS TIME)

“THE CRUNCH”

USER QUERY TIMES(Improvement)120 100 100 70

80 40

80 60 40 20

Time (minutes) Previous Array

0

Time (seconds) Previous Array XtremIO

© Copyright 2014 EMC Corporation. All rights reserved.

Baillie Gifford’s Traditional Environment Brute Force

Copy Brute Force

Copy

28 DATABASE COPIES ARRAYS/POOLS USE CASE

FOR FLASH

Game-Changing Consolidation, Agility FREE, FAST DEV/TEST FREE, FAST ANALYTICS SCALE-OUT IOPS IN ABUNDANCE XTREMIO FLASH FOR ENTIRE DEV INST 1 DEV INST 1 DEV INST 1 DEV INST 1 DEV INST 1 DEV INST 1 DEV INST 1 DEV INST 1 DEV INST 1 DEV INST 1 FIN COPY FIN COPY REPORTS

MORE BUSINESS OPS COPY OPS COPY ANALYTICS DEV INST 2 DEV INST 2 DEV INST 2 DEV INST 2 DEV INST 2 DEV INST 2 DEV INST 2 DEV INST 2 DEV INST 2 DEV INST 2

DEV INST 3 DEV INST 3

DEV INST 3 DEV INST 3 DEV INST 3 DEV INST 3 DEV INST 3 DEV INST 3 DEV INST 3 DEV INST 3 SALES COPY SALES COPY TRENDS

TEST/DEV COPIES HIGH PERFORMANCE PRODUCTION DATAMART COPIES FASTER APPLICATION DEVELOPMENT TIMES 27: Data Reduction XTREMIO CLUSTER BRUTE FORCE COPIES

Development/Test on XtremIO On Demand copies

Same performance improvements as in production

Inherent QoS—on other instances even under heavy load

30% faster database app development & QA time

1 Production + 25 copies = no capacity increase over production alone! 2 39 TB of DB instances consume only 1.45 TB in flash

Sandy Bryce, Enterprise Platforms Team Lead Just to give you an example of the performance gains we’ve seen, during the testing phase we achieved a 30% reduction in run time for a key business process. That was already amazing—but then, when we put the EMC XtremIO All-Flash Array into production, that number skyrocketed to 60%.”

“A single copy of the database takes up 1.6TB. Twenty, thirty, forty copies of the database—they still take up only 1.6TB of physical flash, and the performance is on par with production. The inherent data reduction capabilities of XtremIO enable a small Flash footprint to serve a large development environment; it’s almost like providing free databases for our developers. This completely solves our dev/test challenge.” “From a development point of view, it’s flexibility in terms of being able to provision multiple copies without increasing the physical footprint, and reducing the time to do those extra copies from hours or days to minutes. We are also able to give our development platform the same performance that we give production, with no cross-platform impact.” We have always been able to add capacity and add more disks, …… 此处隐藏：4289字，全部文档内容请下载后查看。喜欢就下载吧 ……