Transcript XtremIO Transforming Database Infrastructure

DB.NEXT
With XTREMIO
Transform Database
Infrastructure
Vinay Gaonkar, Director of Products
Kevin Closson, Office Of CTO
© Copyright 2014 EMC Corporation. All rights reserved.
1
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.
© Copyright 2014 EMC Corporation. All rights reserved.
2
What Is The One Thing You Know
About This Car?
© Copyright 2014 EMC Corporation. All rights reserved.
3
Did you say
ELECTRIC?
© Copyright 2014 EMC Corporation. All rights reserved.
4
It’s A Better Car!
• Only one moving part
• More interior space
• No oil changes
• No emissions
• 0-60 in 4.4 sec
• Five star crash ratings
• Lowest center of gravity
• Tax Rebates
• Silent
• Access to carpool lanes
© Copyright 2014 EMC Corporation. All rights reserved.
5
Not all Flash
arrays are
equal
© Copyright 2014 EMC Corporation. All rights reserved.
6
Flash Is Just Media
Flash arrays need to harvest the power
• Consistent performance • More reliable
• Simpler to configure
• More space efficient
• No tuning
• More cost efficient—really!
• Entirely New capabilities
© Copyright 2014 EMC Corporation. All rights reserved.
7
Traditional Database Infrastructure - Complex
“Underperforming”
“Starving”
Test Production
& Dev
“Over provisioned”
Reports
Finance Copy
Dev Instance 1
Analytics
Operations Copy
Dev Instance 2
Trends
Sales Copy
Dev Instance 3
3 copies2TB
for DB,
30 engineers,
10TB
50K+
IOPS
10 +for
DB copies,
20K IOPS
10K IOPS
Test/Dev
Copies 50TB+ of storage to support
Data2TB
Martof
Copies
14+ full copies
to manage
application data
HR
APP
ERP
APP
SALES/ MARKETING
APP
Application Silos to manage hotspots
© Copyright 2014 EMC Corporation. All rights reserved.
8
To Summarize, The Problems Are…
Applications
Infrastructure
• Unhappy users
• Unsatisfied database owners
• Starving Test/Dev
• Over-provisioned and underperforming storage
• Under-performing Data
Marts
• Cost
• Copies and copies
• Cost
Database Infrastructure is complex and expensive
© Copyright 2014 EMC Corporation. All rights reserved.
9
Transform Database Infrastructure With
XtremIO Flash Arrays
Accelerate
and Scale
Database IOs
© Copyright 2014 EMC Corporation. All rights reserved.
Consolidate
Instances &
Silos
Increase
Efficiency&
Reduce cost
10
XtremIO Flash Array
•
•
One X-Brick
20TB (14.94TB2),
150K1 IOPS
1
2
8K 100% random read
Usable capacity without data reduction
© Copyright 2014 EMC Corporation. All rights reserved.
•
Consistent performance
•
150K1 IOPS 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
11
XtremIO Scaleout Array
One 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
Four
X-Brick
Array
Two X-Brick
Single
X-BrickArray
Array
2
80TB
40TB
300K
20TB , 600K
150K IOPS1
© Copyright 2014 EMC Corporation. All rights reserved.
– Uniform LUN layout
– Load balanced IOs
1 8K 100% random read
2 Raw capacities
12
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
© Copyright 2014 EMC Corporation. All rights reserved.
13
Why Don’t Applications Perform?
•
“Underperforming” Production
•
2TB DB, 10TB Storage Many DB cores 30%
CPU utilization 10-20ms App response time
© Copyright 2014 EMC Corporation. All rights reserved.
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
14
Chasing Hotspots
Table 7 Volume Layout
Table 6 Aggregate Layout
Controller
Aggregate Option
Name
/RG Size
# of Disks/
Usable Size
Purpose
1. Different
RAID-DP, 3
DOT and root volume
RG-16
no's/350GB
RAID groups
FAS3170_A_1
aggr0
FAS3170_A_1
AGGR_OR RAID-DP, 42 no's/13TB Data files, Redo logs,
A_1_A_1 RG-21
control files, Database and
Cluster Ware Binary
FAS3170_A_2
aggr0
FAS3170_A_2
AGGR_OR RAID-DP, 42 no's/13TB Data files, Redo logs,
A_2_A_1 RG-21
control files, FRA
FAS3170_B_1
RAID-DP, 3
RG-16
no's/350GB
2. Different
controllers
aggr0
RAID-DP, 3
RG-16
DOT and root volume
3. Different
types
DOT anddrive
root volume
no's/350GB
FAS3170_B_1
AGGR_OR RAID-DP, 42 no's/13TB Data files, Redo logs,
A_1_B_1 RG-21
control files
FAS3170_B_2
aggr0
FAS3170_B_2
AGGR_OR RAID-DP, 42 no's/13TB Data files, Redo logs,
A_2_B_1 RG-21
control files, Archive Log
RAID-DP, 3
RG-16
no's/350GB
DOT and root volume
Controlle
r
Volume
name
Aggregate
Name
Size
Purpose
FASORA_HOM AGGR_OR 100G Database Binary
3170_A_ E
A_1_A_1 B
1
FASCRS_HOM AGGR_OR 100G Cluster ware
3170_A_ E
A_1_A_1 B
Binary
1
FASOCR_CSS
3170_A_
1
AGGR_OR
A_1_A_1
4. Different
50GBvolumes
OCR & Voting
Disks
FASVOL_DATA AGGR_OR 12TB Datafiles, control
3170_A_ _1_A_1
A_1_A_1
file
1
5. Different
sizes
FASVOL_LOG_ AGGR_OR 200G Redo log Files
3170_A_ 2_A_1
A_2_A_1 B
2
FASVOL_FRA_ AGGR_OR 2TB
3170_A_ 2_A_1
A_2_A_1
2
FRA
FASVOL_DATA AGGR_OR 12TB Datafiles, Control
3170_B_ _1_B_1
A_1_B_1
file
1
© Copyright 2014 EMC Corporation. All rights reserved.
FASVOL_DATA AGGR_OR 10TB Datafiles, Control
3170_B_ _2_B_1
A_2_B_1
File
15
Do you have
application
performance
issues?
© Copyright 2014 EMC Corporation. All rights reserved.
16
A Typical I/O-Bound Server.
Wasted CPU Cycles
4 hours wasted by
high-latency single block
random reads
© Copyright 2014 EMC Corporation. All rights reserved.
92% DB
Time
wasted!
17
Complex
Database
Infrastructure
Transformed
Database
Infrastructure
Free, Fast DEV/TEST
High Performance Production
Free, Fast ANALYTICS
Production
Parent Volume
3 EVERY
copies forENGINEER
30 engineers,
5K
IOPS
GETS AN INSTANCE
33 0
Dev/Test
Dev/Test
Instances
Instances
10TB
for 2TB,
50K IOPS
2TBstorage
of Flash
Capacity
50
2
TB total
Storage
XtremIOspace
space
10+ copies,
20K IOPS
INSTANT
CREATION
10
Full Copies
SCALE-OUT IOPS IN ABUNDANCE
© Copyright 2014 EMC Corporation. All rights reserved.
18
CMA Customer Profile
Medical Analytics using Oracle RAC
Challenge




Extreme performance (6 GB/s large block random workload)
High Oracle licensing costs
Storage OpEx
Complex setup/tuning
Solution
 XtremIO All-Flash Array
BRIAN DOUGHERTY
Chief Data Warehouse Architect
“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”
© Copyright 2014 EMC Corporation. All rights reserved.
Application
 Largest Medicaid analytics
database (Oracle RAC) in US
 High user concurrency
 Fast response time needed
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
19
XtremIO Configures In Minutes
One Screen – Zero Planning, Zero Tuning
1
CREATE
VOLUMES
© Copyright 2014 EMC Corporation. All rights reserved.
3
MAP
VOLUMES
2
CREATE
INITIATOR
GROUPS
20
Results-AWR Report
© Copyright 2014 EMC Corporation. All rights reserved.
•
Avg. latency went down
by more than 70%
•
CPU utilization doubled
21
Fewer Cores Need To Be Licensed On
XtremIO
40%
60%
40%
60%
60%
CPU Utilization
40%
60%
60%
40%
40%
80%
48 licensed core
32
cores
© Copyright 2014 EMC Corporation. All rights reserved.
22
Virtualize To Save More Cores
64 licensed cores
32
© Copyright 2014 EMC Corporation. All rights reserved.
23
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
© Copyright 2014 EMC Corporation. All rights reserved.
24
“Do you have
‘end of quarter’
Crunch times?”
© Copyright 2014 EMC Corporation. All rights reserved.
25
Over-provisioned & Complex Data
Warehouse
Reports
Analytics
Sales
• Multiple full copies
of production on
separate storage
arrays
Trends
Operations
Finance
ETL
ETL
Copy
Copy
• Concurrent ETLs
to accelerate
• Copy process is long
Production
Database
You still have crunch times
© Copyright 2014 EMC Corporation. All rights reserved.
26
Space Efficient Snapshots
1 OLTP Database LUN*
1 OLTP LUN and 6 snapshots
Logs/database on 1 LUN
1 LUN and 6 snapshots
© Copyright 2014 EMC Corporation. All rights reserved.
27
Zero Cost Data Mart Copies Anytime!
Used Capacity/IOPS
2TB
2TB150K
100K
125K
50K IOPs
75K
IOPs
Financial Statements
Production
Sales Reports
Ops Analytics
Marketing Insights
Instantaneous zero-cost snapshots
Production Database (2TB)
One X-Brick
150K IOPS
• Faster report time
• Consolidated DW/reporting infrastructure
© Copyright 2014 EMC Corporation. All rights reserved.
28
Virtualize ETL & Reporting servers To
Further Consolidate
Sales
Reporting
Ops
Analytics
Financial
Stmts
Marketing
Insights
Production
Instantaneous zero-cost snapshots
Production Database (2TB)
© Copyright 2014 EMC Corporation. All rights reserved.
29
“How many copies
of DB do you keep
for test and
development?”
“Not as many
as we like”
© Copyright 2014 EMC Corporation. All rights reserved.
30
Test & Dev Is Complex, Restrictive and
Expensive
Group of
engineers
share the
copies
• Full copies of
production on
separate repurposed storage
• Copy process
is long
Copy
Dev 1
Copy
Dev 2
Test 1
Test 2
Production
Database
Delays & compromised quality
© Copyright 2014 EMC Corporation. All rights reserved.
31
“If cost and
complexity were not
an issue, how many
copies of your DB
would you keep?”
“One for each of
my engineers”
© Copyright 2014 EMC Corporation. All rights reserved.
32
Investment Management Customer Profile
Oracle Performance, Test & Dev Flexibility
Enterprise Platforms Strategy Team Leader
Challenges
“The performance, ease of use,
and snapshots make XtremIO a
compelling addition to your IT
service portfolio!”
USER QUERY TIMES
“THE CRUNCH”
(BUSINESS PROCESS TIME)
100
100
80
60
40
80
80
40
70
40
20
Time (minutes)
Previous Array
0
© Copyright 2014 EMC Corporation. All rights reserved.
Time (seconds)
Previous Array
Solution
 XtremIO All-Flash Array
 Production on One X-Brick
 Test/Dev on 2 X-Brick cluster
Results
100
60
20
0
(Improvement)
120
 Query response times
 Business processing times
 Development/Test database scale & performance




Application




Oracle 11G
High user concurrency
Fast response time needed
Large dev/test environment
30% business process time improvement
15-40% user query time improvement
CPU wait time reduced, utilization increased
Snapshots/Deduplication for dev/test give “free” database
copies
XtremIO
33
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
© Copyright 2014 EMC Corporation. All rights reserved.
34
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
© Copyright 2014 EMC Corporation. All rights reserved.
35
XtremIO Array Scales Out Linearly With
Consolidation And Database Growth
Linear
Scaling
Consistent
Low latency
2X
1X
One X-Brick (6U)
150K IOPS*
*8K
© Copyright 2014 EMC Corporation. All rights reserved.
4X
Two X-Bricks (13U)
300K IOPS*
Four X-Bricks (23U)
600K IOPS*
Random read IOPS
36
Entire Virtualized Database Consolidated
On A X-Brick Cluster
Data Warehouse
Sales
Reporting
Ops
Analytics
Financial
Stmts
Marketing
Insights
Test & Dev
Production
Multiple
copies
Instantaneous zero-cost snapshots
Production Database (2TB)
© Copyright 2014 EMC Corporation. All rights reserved.
37
Entire Virtualized Database Infrastructure
On XtremIO
Sales Reporting
Ops Analytics
Test & Dev
Production
ERP APP
Financial Stmts
Marketing
Insights
Sales Reporting
Ops Analytics
Test & Dev
Production
HR APP
Financial Stmts
Production Database (2TB)
Marketing
Insights
Sales Reporting
Test & Dev
Sales Production
APP
Ops Analytics
Financial Stmts
Production Database (2TB)
Marketing
Insights
Production Database (2TB)
Instantaneous zero-cost snapshots
One array, Four X-Bricks
600K IOPS
© Copyright 2014 EMC Corporation. All rights reserved.
38
Be The Cause For The Change!
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
© Copyright 2014 EMC Corporation. All rights reserved.
39