Building Disaster Recovery Plans with Azure Site Recovery, Hyper-V Replica, SQL Always - PowerPoint Presentation

393 views
Uploaded On 2018-11-26

Building Disaster Recovery Plans with Azure Site Recovery, Hyper-V Replica, SQL Always - PPT Presentation

Abhishek Agrawal Senior Lead Program Mgr Hemant Mahawar Senior Program Manager Ryan Sokolowski Senior Program Manager DCIMB377 Overview of DR technologies for Cloud OS Azure Site Recovery formerly HyperV Recovery Manager HyperV Replica SQL Always On ID: 733904

azure sql site recovery sql azure recovery site hyper replica microsoft configuration orchestration tier app powershell cloud server availability

Link:

Copy

Embed:

<iframe width="560" height="315" src="https://www.docslides.com/embed/733904" frameborder="0" allowfullscreen></iframe>

Download Presentation from below link

Download Presentation The PPT/PDF document "Building Disaster Recovery Plans with Az..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.

Presentation Transcript

Slide1
Slide2

Building Disaster Recovery Plans with Azure Site Recovery, Hyper-V Replica, SQL Always ON and Desired State Configuration

Abhishek Agrawal, Senior Lead Program Mgr.Hemant Mahawar, Senior Program ManagerRyan Sokolowski, Senior Program Manager

DCIM-B377Slide3

Overview of DR technologies for Cloud OS:

Azure Site Recovery (formerly Hyper-V Recovery Manager), Hyper-V Replica, SQL Always OnUnderstand how Hyper-V Replica & SQL Always On complement each other

Learn

how to create a Recovery Plan in Azure Site Recovery for multi-tiered SQL appsLearn about PowerShell Desired State Configuration and using it for Application Recovery post failover

Session ObjectivesSlide4

Overview of DR TechnologiesSlide5

Traditional Business continuity Solutions

Cost

Effort

Complexity

BenefitSlide6

Minimal downtimeMinimal data loss

Fast orchestrated RecoveryDeterministic, automated re-configuration for app recoveryLow TCO secondary site

DR needs for a Modern DatacenterSlide7

Hyper-V Compute

Storage

Networks

SQL

IIS

Apps

VM Replication with Hyper-V Replica

SQL Always ON

DR Orchestration

with

Azure Site Recovery

PowerShell DSC

Microsoft’s Cloud OS DR Stack

Clustering/Storage ReplicationSlide8

Microsoft’s Cloud OS DR Stack

Hyper-V Replica

SQL Always On

Azure Site Recovery

PowerShell

DSC

Replication

Orchestration

Monitoring

App Configuration

ON-PREMISES

SERVICE PROVIDER

MICROSOFT

Azure

CONSISTENT

PLATFORM

1Slide9

Demo:Hyper-V ReplicaSQL Availability GroupSlide10

Hyper-V Replica OverviewSlide11

SQL Always On Availability GroupsSlide12

Azure Site Recovery OverviewSlide13

DR Orchestration

Primary Site

Azure Site Recovery

Overview

Secondary Site

Hyper-V Replica /

SQL Always On

Azure Site Recovery

SCVMM

Compute

Storage

Networks

DRP

SMI-S Provider

Microsoft Azure

Service Provider

Private CloudSlide14

Demo:Recovery Plan with SQL Always On Integration

Ryan Sokolowski, Senior Program ManagerSlide15

SQL Always On & Hyper-V Replica Better TogetherSlide16

Feature

SQL

AlwaysOn AG

Hyper-V Replica

Physical/Virtual

Both

Virtual only

Type of apps

Database only

Application

agnostic (Full VM)

Unit of failover

One

more databases

One or more virtual machines

Networking

Yes (Database client to server)

Yes (IP injection, Network virtualization)RPOAsync or Sync Async only

RTOSeconds (Database recovery time)Minutes (VM startup + SQL Server startup)Replica State Read OnlyPassive (Powered Off)SQL Always ON AG and Hyper-V Replica Side by SideSlide17

Feature

SQL

AlwaysOn AG

Hyper-V Replica

Secondary

COST

Compute,

Storage,

License

Storage only

Storage agnostic

Yes

Cross-domain Support

Yes

Replication CompressionYesYesReplication EncryptionYesYes

Secondary replicasSQL Server 2012: 4 (Fan-out)SQL Server 2014: 8 (Fan-out)Win 2012: 1 Win 2012 R2: 2 (chained)Replication to AzureYes (SQL Server 2012+) Yes, Announced at TechEd NA 2014!SQL Always ON and Hyper-V Replica Side by SideSlide18

DR Orchestration

Orchestration

DR Orchestration for SQL Apps: Tier1, Site to Site

Hyper-V Replica

Azure Site Recovery

SQL Availability Group

App Front End

SQL Backend

Primary Site

Secondary SiteSlide19

DR Orchestration

Orchestration

DR Orchestration for SQL Apps: Tier1, Site to Azure

Hyper-V Replica

Azure Site Recovery

SQL Availability Group

App Front End

SQL Backend

Primary Site

Azure

Azure Storage

IaaS VMSlide20

DR Guidance for Multi-Tier SQL Apps (Tier1)

Workload Type

SQL Tier

App TierSQL Tier DR RecommendationApp Tier DR Recommendation

DR Orchestration

Recommendation

Tier 1 Workload/Business

Critical

Physical/Clustered

Physical

SQL Always On Availability GroupsStorage DR/Active App Tier on SecondaryPowerShell Scripts

Tier 1 Workload/Business Critical

Physical/Clustered

Virtual

SQL Always On Availability

Groups

Hyper-V Replica

Azure Site Recovery

Tier 1 Workload/Business CriticalVirtual/ClusteredVirtualSQL Always On Availability GroupsHyper-V ReplicaSlide21

DR Orchestration

Orchestration

DR Orchestration for SQL Apps: Tier2, Site to Site

Hyper-V Replica

Azure Site Recovery

Hyper-V Replica

App Front End

SQL Backend

Primary Site

Secondary Site

Local SQL AGSlide22

DR Orchestration

Orchestration

DR Orchestration for SQL Apps: Tier2, Site to Azure

Hyper-V Replica

Azure Site Recovery

Hyper-V Replica

App Front End

SQL Backend

Primary Site

Azure

Local SQL AG

Azure StorageSlide23

DR Guidance for Multi-Tier SQL Apps (Tier2)

Workload Type

SQL Tier

App TierSQL Tier DR RecommendationApp Tier DR Recommendation

DR Orchestration

Recommendation

Tier 2

Workload

Virtual/Clustered

Virtualized

Hyper-V ReplicaHyper-V Replica

Azure Site RecoveryTier 2 WorkloadVirtual/Stand-alone

Virtualized

Hyper-V Replica

Hyper-V ReplicaSlide24

Planned Failover/FailbackShutdown App Tier

Failover Availability Group using SQL AlwaysOn PowerShell ScriptsAG listener redirects to new primaryFailover of App Tier via Hyper-V ReplicaUpdate App DNS via Script

Test Failover

Test Failover App Tier in an isolated network with a bridge to SQL networkTest App via a client within private networkUse read-only SQL Secondary to perform Read TestFailover GuidanceSlide25

SharePointConfig DB and Admin DB needs to be sync replicated

Content DB can be async replicatedFront-End and Application Tier can be Hyper-V Replica protectedDynamics, CRMDatabase can be protected using SQL Always On Availability GroupFront-End and Application Tier can be Hyper-V Replica protected

BIZTALK Server

Does not work with SQL Always On AG due to multi-database transactionsCreate customized Azure Site Recovery Plan with BIZTALK Log Shipping*Detailed Recovery Plan guidance to be published shortlyWorkload Specific Suggestions*Slide26

Application Recovery with PowerShell Desired State Configuration

Hemant Mahawar, Senior Program Manager

Windows PowerShellSlide27

Reconfiguration is tedious and error-prone

Subnet, IP, firewall rules, DNS, permissions, share/resource access, Capacity availabilityContributes to higher RTOCurrent solutions are expensive and do not scale in a cloud era

DR is

the biggest configuration change for an ApplicationSlide28

Future beckons us with…..

….. PowerShell Desired State ConfigurationSlide29

PowerShell Progression …Slide30

Life in the Cloud

 bigger scale and faster cadence Scale * Complexity >> Skills Change is Primary cause of outage

Rapid change, at scale with,

constant failuresDSC scales, simplifies complexity and can auto-correctWhy Desired State ConfigurationSlide31

DSC Leverage

Traditional Scripts

Intent

Logging & Error Handling

Reboot Resiliency

Technology Specific

Dependency Resolution

Repeatable Automation

DSC Engine

Dependency Resolution

Logging & Error Handling

Reboot Resiliency

Repeatable Automation

Resources

Technology Specific

Configuration

IntentSlide32

Make It So

HOW

DSC Resources Do the heavy lifting in an idempotent way

Intent

WHAT

Structural Configuration

Stays same irrespective of the environment

WHERE : Environmental Configuration Changes as system goes from Dev  Test 

Prod  Recovery

DSC Decouples …Slide33

Configuration Management Platform for Windows

Simplify configuration Enable continuous deployment Prevent configuration

drift

PowerShell Desired State ConfigurationSlide34

Deterministic, automated re-configuration of Application post failover

Recovery configuration should be identical to primaryRecovery side environment should be captured in a Recovery side Environment File Recovery Configuration RequirementsSlide35

Demo:DSC with Azure Site RecoverySlide36

Deterministic, automated re-configuration of Application post failover

MOF file provides documented evidence of what change got applied Scales with Cloud deployments while keeping RTO lowWe are just getting started. As DSC adoption grows, ASR will be there to leverage it

Azure Site Recovery with DSCSlide37

Overview of DR technologies

for Cloud OS: Azure Site Recovery (formerly Hyper-V Recovery Manager), Hyper-V Replica, SQL Always OnUnderstand how Hyper-V

Replica

& SQL Always On complement each other.Learn how to create a Recovery Plan in Azure Site Recovery for multi-tiered SQL appsLearn about PowerShell Desired State Configuration and using it for Application Recovery post failover

Session ObjectivesSlide38

DCIM-B322 Implementing Enterprise-Scale Disaster Recovery with

Azure Site Recovery, Network Virtualization, and Microsoft System Center 2012 R2 DCIM-B324 PowerShell Desired State Configuration and DevOps in Microsoft Azure

DCIM-B319 Building a Backup Strategy for Your Private Cloud

DBI-B314 CAT: Microsoft SQL Server High Availability and Disaster Recovery in Microsoft Azure Related content

Find

Later

Business Continuity/PowerShell Booth

Abhiag@microsoft.comSlide39

http://azure.microsoft.com/en-us/services/recovery-manager

Track resources

http://

technet.microsoft.com/en-us/library/dn249912.aspx

Slide40

Come Visit Us in the Microsoft Solutions Experience!

Look for Datacenter and Infrastructure Management

TechExpo

Level 1 Hall CD

For More Information

Windows Server 2012 R2

http://technet.microsoft.com/en-US/evalcenter/dn205286

Windows Server

Microsoft Azure

http://azure.microsoft.com/en-us/

System Center

System Center 2012 R2

http://technet.microsoft.com/en-US/evalcenter/dn205295

Azure Pack

http://www.microsoft.com/en-us/server-cloud/products/windows-azure-packSlide41

Resources

Learning

Microsoft Certification & Training Resources

www.microsoft.com/learning

msdn

Resources for Developers

http://microsoft.com/msdn

TechNet

Resources for IT Professionals

http://microsoft.com/technet

Sessions on Demand

http://channel9.msdn.com/Events/TechEdSlide42

Complete an evaluation

and

enter to win!Slide43

Evaluate this session

Scan this

code

to evaluate

this

session.Slide44

2014

and

other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.

The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.