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
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.
Slide1Slide2
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
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
or
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
Yes
Cross-domain Support
No
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
DR
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
DR
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
DR
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
DR
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
us
Later
At
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
Microsoft Azure
http://azure.microsoft.com/en-us/
System Center
System Center 2012 R2
http://technet.microsoft.com/en-US/evalcenter/dn205295
Azure Pack
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
QR
code
to evaluate
this
session.Slide44
©
2014
Microsoft Corporation. All rights reserved. Microsoft, Windows,
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.