Deploying NetApp Storage Solutions in a Database Environment

(1)

Tag line, tag line

Deploying NetApp

Storage Solutions in a

Database Environment

Neil Gerren - Database CSE

[email protected]

Mike Anich

Manager, Systems Engineering – Ohio Valley

[email protected]

(2)

Tag line, tag line

Deploying NetApp

Storage Solutions in a

Database Environment

Neil Gerren - Database CSE

[email protected]

(3)

Unparalleled Innovation

1993

NAS appliance and Snapshots

Near-line storage appliance

2001

Multiprotocol appliance

1996

2002

Unified SAN/NAS appliance

2003

iSCSI storage system

2004

RAID-DP

™

disk resiliency

2005

Thin provisioning and cloning

2006

Scalable grid storage

2007

Oracle DNFS Integration

2008

(4)

NetApp has a Single Architecture, and

Enables Seamless Scaling

•

Seamless Scalability

•

No Data Migration

•

Investment Protection

FAS2020

FAS6040

FAS3140

FAS3020

FAS2050

FAS3050

FAS3170

FAS6080

(5)

NAS, CIFS

(File)

Departmental

iSCSI

Enterprise

SAN

(Block)

Fibre Channel

Enterprise

Dedicated Ethernet

SAN

NAS

Departmental

NetApp

Fabric Attached Storage

Corporate LAN

NetApp allows you to implement innovative

multi-protocol solutions

(6)

Database environment with NetApp Data

ONTAP® 7G

(7)

NetApp FAS HP EVA EMC CLARiiON EMC Symmetrix

Acquisition & Ongoing Vendor Costs Internal Operational Costs Business Cost of Downtime

Source: Mercer Database Storage Total Cost Comparison Interviews, December 2005 - January 2006.

T o ta l C o s t In d e x (N or m a li z e d to N e tA pp FC S A N = 1 0 0 )

Lowest TCO for Databases on FC SANs

+108%

+243%

▶

Modular arrays – 55% to 71% more than NetApp

▶

Frame arrays – over 250% more than NetApp

(8)

The Case for RAID-DP

0% 0% 5% 5% 10% 10% 15% 15% 20% 20% Up to 5% Up to 2.6% Up to 17.9% FC ATA FC ATA FC ATA

17.9%

1.7%

2.6%

.2%

5%

3%

ATA

Less than 1 in a billion

*

Media/Bit Error + 2nd Failure Likelihood –

Double Parity

(during reconstruction of a 16-drive RAID-DP set)

Protected with

RAID-DP

.0000000001%

*

Typical Disk Drive Replacement Rate

(per year)

*

Disk Drive Spec Media/Bit Error

Likelihood

(full capacity transfer 300GB FC / 320GB SATA)

*

Media/bit Error Likelihood – Single Parity (during reconstruction of an 8-drive RAID 4/5 set)

Industry Statistics: Drive Replacements

& Media Errors Increase with Drive Capacities

*

Source: Seagate / Maxtor / Hitachi & IBM

(9)

WAFL, Snapshot, and FlexClone:

The Foundation

NetApp’s Unique

DNA

:

Snapshot

™

Technology:

– Near instantaneous, point-in-time

“copy” of file system (vol) or LUN

– Read-only

SnapRestore

®

:

– Near instantaneous “rollback” of

vol or LUN to prior Snapshot copy

FlexClone

®

:

– Near instantaneous,

WRITABLE

“copy” of vol or LUN

– Same space-sharing

characteristics

A B C D Active Filesys or LUN

Inodes,

block maps

Disk blocks

Snapshot™ D’ Y FlexClone® Summary Snapshot = A + B + C + D Active = A + B + C + D’ FlexClone = Snapshot + Y Incremental storage = 22 blocks

(10)

Oracle and Network Appliance

®

12 years of innovation driving down infrastructure costs

AND increasing enterprise IT productivity

NetApp helps establish OSCP

1999

Oracle certifies NetApp

1997

First filer for Oracle DB sold

1995

NetApp runs on Oracle NetApp and Oracle Consulting Blueprints

2001

3000+ Oracle on NetApp customers Linux competency center

2003

2000

Oracle B2B Exchange selects NetApp NetApp is Certified Solution Partner

2004

Enterprise Grid Alliance

Oracle builds next Apps on NetApp storage

2002

Oracle NetApp Joint Escalation Team Joint Center of Excellence (CoE) and professional services

2005

ONTAP 7G FlexVol & FlexClone deployed HARD: SnapValidator EM Grid Control Integration

2006

OCS SnapLock Integration SnapManager for Oracle 5000+ joint customers

2007

Oracle Enterprise Linux 4 Support SMB Bundle Solution DNFS in 11g

(11)

NetApp Snapshots vs Tape

Significant time savings

Stay online

Reduce system and

storage overhead

Consolidated backups

Backup more often

Time in hours

Time to Backup Time to Recover

To Tape (60GB/hr best case) From Tape Logs

300GB

Database

0 1 2 3 4 5 6 7 8 Snapshot Logs SnapRestore

(12)

Database Performance

and

Uptime

VeriTest Report: Snapshot Performance

0% 20% 40% 60% 80% 100% 120% 0 130 260 390 520 650 780 910 1040 1170 1300 1430 1560 1690 1820 1950 2080 2210 2340 2470 2600 2730 2860 2990 3120 3250 3380 3510

Elapsed Time in Seconds

CX500 R & W FAS3020 R & W

Copy on first write solutions 60% slower!

VeriTest: Network Appliance FAS3020 and EMC CX500: Comparison of Usability and Performance http://www.veritest.com/clients/reports/netapp/2005_NetApp_Competitive_Analysis.pdf

(13)

“It used to take 36 hours to make a working copy of our

largest Oracle database. With FlexClone, it takes less

than an hour, a more than 97 percent reduction.”

FlexClone Enables Multiple Test and Dev

Environments

Physical copies consume space and

take time to create

Test 1

…

QA Test 2

Dev 1 Dev 2

Production _Mirror Production

Test 1 Test 2

QA

Dev 1 Dev 2 Mirror

FlexClone copies are near-instant,

stores changed blocks only

(14)

Disaster Recovery: SnapMirror

Fast data replication

and failover

Significant reduction in

storage required

More efficient

network utilization

Sync or async replication

Access to mirrored data

Volume or qtree replication

Secondary can become

primary in case of disaster

at primary site

Easy to install and manage

over existing IP infrastructure

(WAN)

SnapMirror

Production

Site

Remote Disaster

Recovery Site

(15)

NetApp Data Protection Software

A

v

a

ila

b

ilit

y

C

o

s

t

Cost

Asynchronous Backup Asynchronous Mirroring High Availability Synchronous Mirroring Rapid Recovery Daily

Backup _Snapshots_Snapshots

Asynchronous SnapMirror, SnapVault, SnapManager Asynchronous SnapMirror, SnapVault, SnapManager Clusters and MetroCluster Clusters and MetroCluster Synchronous SnapMirror Synchronous SnapMirror

Advanced Backup, Disk Staging, VTL Advanced Backup, Disk Staging, VTL

Low Level SLA Medium Level SLA High Level SLA

SnapRestore SnapRestore

(16)

SnapManager for Oracle Overview

Database Server

Oracle 9i,10g,11g

NetApp Storage Systems

NFS, FCP or iSCSI protocols

SnapManager

RAC, ASM, RMAN

SnapDrive

– Communicates w/Storage

System

– Generates Snapshots

SnapManager

– Communicates w/Oracle

“Quiesce”s Datafiles

Integrated with RMAN

Both Minimize Scripting

(17)

SnapManager for Oracle Overview

Administrator productivity

Storage flexibility

Efficiency

Response time

Go from this…

…to THIS

Application Admins Server Admins Storage Admins Virtualized Storage Resources Storage Application Admins Server Admins Storage Admins Policy-based Storage Management Storage

(18)

Shared vision

Enterprise Grid Computing Virtualization

Executive alignment

Across all functions

Remove barriers top to bottom

Technology

Integration

Oracle and NetApp Alliance Framework

NetApp

Oracle

Partnership

Core

Executive

Alignment

Services &

Support

Sales &

Marketing

Seamless Integration

SMO with ASM, RMAN NetApp and RAC

Initiatives

Unbreakable Linux

SnapValidator support for HARD

Joint Development

SnapLock, ManageONTAP and ILM Grid Control, DNFS and 11g

Joint best practices

Oracle on NFS, FCP, iSCSI NetApp and RAC, ASM

Services and Support

ONJET support

Migration, Capacity, HA, DR

Joint sales engagements

Oracle ETCs, Austin Data Center

Joint branding and marketing

BizApps campaign, Oracle OpenWorld, advertising

5000+ joint customers

(19)

NetApp ILM for Oracle - Integrated View

Compliance &

Performance

Tiers

Unified Storage Architecture

(20)

NetApp ILM for Oracle – Compliance

SnapLock

Default Retention

Date

(21)

Oracle as a Customer – Highlights

99% of Oracle application development

is on NetApp (2400TB)

99% of Oracle OnDemand “Production Applications

and DB” (2100 TB)

100% Oracle University (120TB)

100% Oracle Demos DB & Applications (500TB)

50% Database Development (300TB)

65% of Oracle internal production (2420 TB)

NetApp has reduced storage management overhead

activities in half!

(22)

Oracle Austin Data Center

Compute grid: 23,000+ servers

– Largest Dell/Linux installation on earth – Scaling at over 100 servers/week

Storage grid: 10,000+ PB of

NetApp storage

– Largest NetApp installation anywhere – Scaling at over 60TBs of

storage/month

Over 500 mission-critical customers'

apps hosted on the premises

Primary data center for 70,000+

Oracle employees

2 acres of data center raised

floor space

Virtualization is the next phase

(23)

(24)

24

BEA Systems

Business Challenge

– Replace a complex and problematic storage network and disaster recovery system with a simpler and more reliable solution

IT Challenge

– Free up skilled staff to focus on other tasks

Solution

– Implement a new NAS primary storage and disk-to-disk backup solution for the

company’s mission-critical Oracle databases, with emphasis on simplicity, reliability and scalability

– DB Backups, DR, Cloning, Vaulting

Benefits

– Eliminated the need for a full-time storage administrator

– Reduced physical servers needed by over 90%

– Slashed time devoted to tape backups from six hours to ten minutes per day

Industry

Information Technology

Solution

Disaster Recovery

Protocols

NFS, NAS, Windows/UNIX,

and IP SAN

(25)

Activision Reduces Application Test &

Development from Days to Hours

Challenge

– Needed several copies of production data for testing and development

– Cloning process was unreliable, took days to complete and required substantial amounts of storage

Solution

– Leverage NetApp SnapMirror to mirror data to test environment

– Used FlexClone to create several copies of Oracle eBusiness suite instances

– Used Snapshots to perform daily backups

Benefits

– Improved Oracle application time to market

Reduced test and development process from 3 days to less than 4 hours

– Substantial storage savings

SnapMirror and FlexClone stores changed blocks

– Improved flexibility with FlexClone

Create clones from multiple sources (production, mirror, Snapshots)

– Reduced risk with frequent Snapshots

Test patches, easy to roll back to previous known good copy

Industry

Publisher of interactive

entertainment software

Solution

Business Applications:

Oracle eBusiness Suite,

Oracle Database

Hardware Platform

Solaris, SUN UltraSparc

NetApp FAS on NFS, 24TB

(26)

Blackboard Shortens Time-to-Market

with FlexClone

Challenges

– Lengthy data replication times

impacted product

development schedules

– Restores required taking

databases offline

Solution

– FlexClone enabled rapid

duplication of Oracle

production data

– FlexVol eased storage provisioning

and improved utilization

Benefits

– Improved developer productivity

– Lower storage costs by a third

– Reduced development time up to

75%, from 8 months to 2 months

A leading provider of education

enterprise software applications

and services

“With FlexClone, we can meet

our aggressive release

schedules with ease.”

(27)

Simplied

Simplifed

Simplied

NetApp Simplifies Database Management

Database Backup And Recovery

Data Security

Database Disaster Recovery Planning

Performance Tuning

Database Maintenance

•Application Development And Testing

•Patches, Schema changes

Data Model Definition And Creation

Capacity Analysis And Planning

SnapRestore

SnapVault

FlexVol

SnapValidator

Decru Datafort

SnapMirror

FlexVol

FlexClone

Clone Split

FlexVol

Operations

Development

NetApp

Solutions

Results

(28)

Q U E S T I O N S

A N S W E R S

(29)

NetApp FlexShare: Quality of Service

With priority service volumes are given higher

Priority Lower Latency,

Better througput Without priority

all volumes achieve similar

throughput/latency

Disruptive!

Non-

Real-Time!