The BRS Story

Transcript The BRS Story

EMC Backup for Data Center Ready SAP HANA

October 2013

Enterprise Information – Big Data

Partner Information “Public” Information Structured Information In Relational Databases Unstructured Information Telemetry, Location-Based Information etc.

Big Data Transforms Business

Every Industry Will Feel Impact Of Real Time, Big Data Analytics Financial Telecom Retail Energy Insurance Government Healthcare Cyber Security Advertising Gaming © Copyright 2012 EMC Corporation. All rights reserved.

Big Data: A Backup Challenge

 Value: unique and discrete and must be protected  Velocity: needs to be protected quickly  Volume: requires deduplication to protect efficiently  Variety: protect structured and unstructured files

Big Data Backup requires a system that is fast, cost effective and reliable

Deduplicate SAP Landscape Backups

CRM ERP Backup Primary Data Center Prod Prod QA1 QA2 BW Backup QA1 Test Pre-prod Break-fix Test Prod Prod Test QA1 Pre-prod QA2 Backup ERP SCM Backup Break-fix Data Domain WAN Backup CRM Data Domain Backup SCM Disaster Recovery Site Test Backup BW QA1 Pre-prod Backup Pre-prod QA2 QA2 Break-fix Break-fix © Copyright 2012 EMC Corporation. All rights reserved.

Why is HANA Important?

 HANA addresses #1 tech priority of CIO’s: – Real time analytics & business intelligence (Source:Gartner)  HANA transforms SAP BW data decision making – 100-1,000x query/reporting performance improvement  HANA creates opportunities for IT re platforming – By 2015, all SAP applications will run on HANA – SAP infrastructure is a $5B market for Cisco & EMC  BRS has a huge stake with SAP – SAP has standardized on EMC NetWorker as their Backup product of choice © Copyright 2012 EMC Corporation. All rights reserved.

SAP High-Performance Analytical Appliance Real-Time Data Access

CRM BI ERP HANA HANA BW HANA IN MEMORY DATABASE Cisco UCS Scale-Out EMC VNX

SAP HANA Infrastructure • • • SAP HANA TM For SAP Data Analytics Flexible, Multi-Purpose, In Memory Appliance An Integrated Stack= SAP In-Memory Software + Cisco UCS Blades + EMC Storage Infrastructure (VNX) Real-Time Analysis on Big Data Files for Real-Time Decision Making © Copyright 2012 EMC Corporation. All rights reserved.

SAP HANA Deployment Models

SAP BW on HANA

SAP BW HANA

HANA as a “Side-Car”

new Apps SAP ERP HANA RDBMS

SAP Suite on HANA

SAP ERP 1 … SAP ERP n SAP BW non SAP HANA

Driving HANA Data Center Requirements

Do We Still Need Disks with SAP HANA?

Well, Think About …  What Happens to In-Memory Data in Case of Power Loss?

 Do You Still do Database “Commit“ if all Your Data is In Memory?

 How Can You Move the In-Memory Data to a Standby Node?

 Does your mission-critical environment need: – Data Protection ?

– Disaster Tolerance?

– Infrastructure Repair/Upgrade?

SAP HANA Backup Customer Requirements

 Enterprise Readiness for SAP HANA – HA, Data Protection and Disaster Recovery  Works with all SAP HANA configurations – Single node, scale-out, all vendor hardware configurations  DBA control via SAP HANA Studio  Single step backup and recovery to Data Domain  Scheduled backups via Centralized backup tool © Copyright 2012 EMC Corporation. All rights reserved.

SAP HANA Persistence Layer

HANA Node Cisco UCS Blade SAP In-Memory DB Data FS Log FS Data Volume Log Volume • • • • Savepoints (Data Filesystem) – In-memory data written to disk in regular intervals (5 mins default) Log Filesystem – – – Capturing all DB transactions since last savepoint Restore DB from last savepoint onwards High IOPS requirement SAP HANA Single Node – Use server internal disks (SSD‘s) SAP HANA scale-out (multi node) – Filesystems reside on external storage © Copyright 2012 EMC Corporation. All rights reserved.

SAP HANA Persistence

Transaction logs Save points Memory

time

DATA LOGS Persistence Storage C B A Power Failure

Recovery Options A.

Until the latest point in time (Latest backup + log entries) B.

HANA Backup Methodology

Backup System DD990 Cisco & EMC HANA Appliance Cisco HANA Rack UCS Blades & Network EMC HANA Rack NetWorker or Studio

Backup FS

Backup Copies

Sunday Monday

HANA 1 HANA 2 HANA 3 HANA 4

D L D L D L D L

4 -16 nodes 1 -3 VNX5300

Saturday

• • • • • Scheduled HANA backups into shared backup filesystem Always Full Backup Creates Copies on external DD990 for fast Restore Use File system backup for integration with HANA studio or NetWorker Benefits – De Duped Backup capacity customizable based on customer requirements – Change of backup has no impact on certified HANA configuration © Copyright 2012 EMC Corporation. All rights reserved.

SAP HANA Backup Components

 4 backup components: – Data Backup (online) ▪ File Write Process specified by Configuration Parameters – – – Log Backup (automatic) ▪ Series of service-specific log segment files ▪ Automatically written until disk is full Configuration Backup (manually) ▪ Standardized per node Backup Catalog ▪ XML Files supported by HANA Studio and DBA Cockpit © Copyright 2012 EMC Corporation. All rights reserved.

HANA “FILE” backup options

Log Volumes Data Volumes Configuration, backup catalog, kernel, log files Config settings in global.ini

HANA Studio External SAP system DBAcockpit Linux/SQL script Automatic Ad-hoc scheduled flexible

SAP note 1651055

NFS PBBA (Purpose Build Backup Appliance) Execution source frequency

Protection Storage Architecture

SAP HANA Backup and DR

SAP HANA Studio to Data Domain via NFS  Simplified DBA Administration using SAP HANA Studio  Single Step Backup and Restore  Fast, secure, network-efficient replication for DR  Optionally use EMC NetWorker with other Backup Target

Local Data Center Disaster Recovery Site

SAP HANA Studio NFS WAN

SAP HANA Persistence and Backups

Save points Transaction logs Memory

time

DATA LOGS Persistence Storage DATA LOGS Backup Storage Data backups

Log backups Power Failure

Why Data Domain for SAP HANA?

• • • • High-speed, Scalable Systems – – Throughput Of Up To 31 TB Per Hour Reduce Storage with inline deduplication Reliable Recovery – Data Invulnerability Architecture Network-efficient Replication – Send Only Deduplicated Data Across The Network Seamless Integration – – Works with all SAP HANA configurations Optimized and SAP Certified Integration with SAP HANA Studio in 1H’2014 and Backint for NetWorker in 2H’2014 © Copyright 2012 EMC Corporation. All rights reserved.

Data Integrity: Data Invulnerability Architecture

End-to-end data verification Checksum Deduplication, write to disk Verify Self-healing file system Cleaning Expired data Defrag Verify Other RAID 6 NVRAM Snapshots Generate Checksum Verify Data File System Deduplication Local Compression RAID End-to-end data verification Verify the file system metadata integrity Verify user data integrity Verify stripe integrity © Copyright 2012 EMC Corporation. All rights reserved.

Data Domain Systems

Data Domain Software Options

• • • DD Boost DD Encryption DD Extended Retention • • • DD Replicator DD Retention Lock DD Virtual Tape Library • DD Management Center Midsize Enterprise Small Enter./RO BO Large Enterprise Speed (DD Boost) Speed (other) Logical capacity Usable capacity DD160 1.1 TB/hr 667 GB/hr 40–195 TB Up to 3.98 TB DD620 2.4 TB/hr 1.1 TB/hr 83–415 TB Up to 8.3 TB

NEW

DD2500 13.4 TB/hr 5.3 TB/hr 1.3–6.6 PB Up to 133 TB

NEW NEW NEW

DD4200 DD4500 DD7200 DD990 22.0 TB/hr 22.0 TB/hr 26.0 TB/hr 31.0 TB/hr 10.2 TB/hr 10.2 TB/hr 11.9 TB/hr 15.0 TB/hr 1.8-9.4 PB 5.6-28.4 PB 1 Up to 189 TB Up to 569 TB 1 2.8-14.2 PB 11.4-57.0 PB 1 Up to 285 TB Up to 1.1 PB 1 4.2-21.4 PB 17.1-85.6

Integrating HANA in SAP Landscape Backups

Primary Data Center ERP CRM HANA Prod Backup Backup Test QA1 Pre-prod QA2 BW Break-fix Prod QA1 QA2 SCM Test Pre-prod Break-fix Prod Backup Test QA1 QA2 Pre-prod Break-fix Prod Backup QA1 QA2 Test Pre-prod Break-fix Disaster Recovery Site Backup ERP Data Domain WAN Backup CRM Data Domain Backup SCM Backup BW © Copyright 2012 EMC Corporation. All rights reserved.

SAP HANA Data Protection Best Practices

 Only Full Backups are supported today  Restores – Full restore of your last backup ▪ changes and logs after the backup are lost – Full restore up to your latest possible consistent point in time ▪ your backup and all available logs after the backup are used to recover the system – Point-in-time restore ▪ your backup and a subset of logs that were created after the backup are used to restore your system © Copyright 2012 EMC Corporation. All rights reserved.

EMC Backup for SAP HANA

 Data Center Ready Backup and Recovery  Fast, Efficient, Scalable Disaster Recovery  Data Invulnerability Architecture provides end to end protection  Operational Simplicity - Lower administrative and operational costs © Copyright 2012 EMC Corporation. All rights reserved.

Thank You

SAP HANA In-Memory Computing

• • • • • Takes data from SAP or third party supported sources Processes the data in-memory Delivers the results from memory Provides control over rapidly expanding Data Volumes Fulfils the need for real-time decisions – “Need for Speed” © Copyright 2012 EMC Corporation. All rights reserved.

SAP HANA external storage

Multi-Protocol – Multi-Purpose Non-shared, 30GB shared, 100GB shared, 2TB shared, 600GB storage devices per SAP HANA node FC NFS MPFS MPFS Cisco blade B440M2 SAP HANA System/Boot Device HANA Install FS HANA DATA FS HANA LOG FS Persistence Layer © Copyright 2012 EMC Corporation. All rights reserved.