Building Disaster Recovery Plans with Azure Site Recovery ...
DCIM-B377 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 Manager Ryan Sokolowski, Senior Program Manager Session Objectives Overview of DR technologies for Cloud OS: Azure Site Recovery (formerly Hyper-V Recovery Manager), Hyper-V Replica, SQL Always On
Understand 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 apps Learn about PowerShell Desired State Configuration and using it Overview of DR Technologies Traditional Business continuity Solutions pl ex i
ty fit e n Be Co m Effor t Co st DR needs for a Modern Datacenter Minimal downtime
Minimal data loss Fast orchestrated Recovery Deterministic, automated re-configuration for app recovery Low TCO secondary site Microsofts Cloud OS DR Stack SQL Always ON App s IIS SQ L VM Replication with Hyper-V Replica Clustering/Storage
Replication Hyper-V Compute Storage Network s DR Orchestration with Azure Site Recovery + PowerShell DSC Microsofts Cloud OS DR Stack Replication Orchestration
Monitoring App Configuration Hyper-V Replica SQL Always On Azure Site Recovery PowerShell DSC ON-PREMISES 1
CONSISTENT PLATFORM MICROSOFT Azure SERVICE PROVIDER Demo: Hyper-V Replica SQL Availability Group Hyper-V Replica Overview In-Box Hyper-V VM Replication Near Sync support, low RPO of 30 secs Storage Agnostic Support for DR scenario (Planned, Unplanned, Test
Failover) Tertiary Replication Support New: Near Sync Replication to Azure (via Azure Site Recovery) SQL Always On Availability Groups Multi-database Failover across SQL Server Instances Multiple secondary copies (4/8) Sync (max 2) / Async support Available in SQL 2012 and SQL 2014 Supports Site-to-Site or Site-to-Azure IaaS VM No shared storage needed Fast Manual/Automatic Failover PowerShell Support Azure Site Recovery Overview At Scale Protection Configuration Automatically enable replication of virtual machines in VMM
Cross site Configuration with network and storage mapping Azure based Recovery Plans for DR orchestration Test Failover support for Recovery Plans Remote monitoring for DR protection PowerShell integration in Recovery Plans Azure Site Recovery Overview DR tr s e h n c Or SCVMM SMI-S Provider io
t a Azure Site Recovery DR P Or ch DR es t n rati o Microsoft Azure Hyper-V Replica / SQL
Always On Service Provider Private Cloud Compu te Storag e Primary Site Networ ks Secondary Site
Demo: Recovery Plan with SQL Always On Integration Ryan Sokolowski, Senior Program Manager SQL Always On & Hyper-V Replica Better Together SQL Always ON AG and Hyper-V Replica Side by Side Feature Physical/Virtual Type of apps Unit of failover Networking RPO RTO Replica State
SQL AlwaysOn AG Both Database only Hyper-V Replica Virtual only Application agnostic (Full VM) One or more databases One or more virtual machines Yes (Database client to Yes (IP injection, Network server) virtualization) Async or Sync Async only Seconds (Database Minutes (VM startup + SQL recovery time)
Server startup) Read Only Passive (Powered Off) SQL Always ON and Hyper-V Replica Side by Side Feature Secondary COST Storage agnostic Cross-domain Support Replication Compression Replication Encryption Secondary replicas Replication to Azure SQL AlwaysOn AG
Compute, Storage, License Yes No Hyper-V Replica Storage only Yes Yes Yes Yes Yes Yes
SQL Server 2012: 4 (Fan- Win 2012: 1 out) Win 2012 R2: 2 (chained) SQL Server 2014: 8 (Fanout) Yes (SQL Server 2012+) Yes, Announced at TechEd NA 2014! DR Orchestration for SQL Apps: Tier1, Site to Site DR at tr es h c Or SQL Backend
i on Azure Site Recovery Or ch DR es tr at io n SQL Availability Group App Front End Primary Site
Hyper-V Replica Secondary Site DR Orchestration for SQL Apps: Tier1, Site to Azure DR at tr es h c Or SQL Backend i on
Azure Site Recovery Or ch DR es tr at io n SQL Availability Group App Front End Primary Site IaaS VM
Hyper-V Replica Azure Storage Azure DR Guidance for Multi-Tier SQL Apps (Tier1) Workload Type SQL Tier App Tier SQL Tier DR App Tier DR
DR Recommendation Recommendatio Orchestration n Recommendatio n Tier 1 Workload/Busines s Critical Physical/ Clustered Physical SQL Always On Availability Groups Storage DR/Active PowerShell
App Tier on Scripts Secondary Tier 1 Workload/Busines s Critical Physical/ Clustered Virtual SQL Always On Availability Groups Hyper-V Replica Tier 1
Workload/Busines s Critical Virtual/ Clustered Virtual SQL Always On Availability Groups Hyper-V Replica Azure Site Recovery DR Orchestration for SQL Apps: Tier2, Site to Site DR at
tr es h c Or i on Azure Site Recovery Or ch DR es tr at io n
Local SQL AG SQL Backend Hyper-V Replica App Front End Primary Site Hyper-V Replica Secondary Site DR Orchestration for SQL Apps: Tier2, Site to Azure DR at tr
es h c Or i on Azure Site Recovery Or ch DR es tr at io n Local SQL AG
SQL Backend Hyper-V Replica App Front End Primary Site Azure Storage Hyper-V Replica Azure DR Guidance for Multi-Tier SQL Apps (Tier2)
Workload Type SQL Tier App Tier SQL Tier DR Recommendati on App Tier DR Recommendat ion DR Orchestration Recommendati
on Tier 2 Workload Virtual/ Clustered Virtualized Hyper-V Replica Hyper-V Replica Azure Site Recovery Tier 2 Workload Virtual/Standalone
Virtualized Hyper-V Replica Hyper-V Replica Failover Guidance Planned Failover/Failback Shutdown App Tier Failover Availability Group using SQL AlwaysOn PowerShell Scripts AG listener redirects to new primary Failover of App Tier via Hyper-V Replica Update App DNS via Script Test Failover Test Failover App Tier in an isolated network with a bridge to SQL network Test App via a client within private network
Use read-only SQL Secondary to perform Read Test Workload Specific Suggestions* SharePoint Config DB and Admin DB needs to be sync replicated Content DB can be async replicated Front-End and Application Tier can be Hyper-V Replica protected Dynamics, CRM Database can be protected using SQL Always On Availability Group Front-End and Application Tier can be Hyper-V Replica protected BIZTALK Server Does not work with SQL Always On AG due to multi-database transactions Create customized Azure Site Recovery Plan with BIZTALK Log Shipping *Detailed Recovery Plan guidance to be published
Application Recovery with PowerShell Desired State Configuration Hemant Mahawar, Senior Program Manager Windows PowerShell DR is the biggest configuration change for an Application Reconfiguration is tedious and error-prone Subnet, IP, firewall rules, DNS, permissions, share/resource access, Capacity availability Contributes to higher RTO Current solutions are expensive and do not scale in a cloud era Future beckons us with.. .. PowerShell Desired State
Configuration PowerShell Progression Why Desired State Configuration Life in the Cloud bigger scale and faster cadence Scale * Complexity >> Skills Change is Primary cause of outage Rapid change, at scale with, constant failures DSC scales, simplifies complexity and can auto-correct DSC Leverage Depend en
Resolut cy ion In te r o n r t Er & g g in dlin g g an o L H Rebo
Resili ot ency Re Au pea to ta m bl at e i Technology on Specific Traditional Scripts Configuration Intent DSC Engine Dependency Resolution
Logging & Error Handling Reboot Resiliency Repeatable Automation Resources Technology Specific DSC Decouples Intent WHAT : Structural Configuration Stays same irrespective of the environment WHERE : Environmental Configuration Changes as system goes from Dev Test Prod Recovery Make It So HOW : DSC Resources
Do the heavy lifting in an idempotent way PowerShell Desired State Configuration Configuration Management Platform for Windows Simplify configuration Enable continuous deployment Prevent configuration drift Recovery Configuration Requirements Deterministic, automated re-configuration of Application post failover Recovery configuration should be identical to primary Recovery side environment should be captured in a Recovery side Environment File
Demo: DSC with Azure Site Recovery Azure Site Recovery with DSC 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 low We are just getting started. As DSC adoption grows, ASR will be there to leverage it Session Objectives Overview of DR technologies for Cloud OS: Azure Site Recovery (formerly Hyper-V Recovery Manager), Hyper-V
Replica, SQL Always On Understand 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 apps Learn about PowerShell Desired State Configuration and using it for Application Recovery post failover Related content [email protected] 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 Find us Later At Business Azure Continuity/PowerShell Booth Track resources http://azure.microsoft.com/en-us/services/reco very-manager / http:// technet.microsoft.com/en-us/library/dn249912.as px For More Information Windows
Server System Center Azure Pack Windows Server 2012 R2 Microsoft Azure Microsoft Azure http://technet.microsoft.com/en-US/evalcenter/dn20 5286 System Center 2012 R2 http://technet.microsoft.com/en-US/evalcenter/dn20 5295
Azure Pack http://www.microsoft.com/en-us/server-cloud/produc ts/windows-azure-pack http://azure.microsoft.com/en-us/ Come Visit Us in the Microsoft Solutions Experience! Look for Datacenter and Infrastructure Management TechExpo Level 1 Hall CD Resources Learning Sessions on Demand http://channel9.msdn.com/Events/Tec hEd TechNet
Resources for IT Professionals http://microsoft.com/technet Microsoft Certification & Training Resources www.microsoft.com/learning msdn Resources for Developers http://microsoft.com/msdn Complete an evaluation and enter to win! Evaluate this session Scan this QR code
to evaluate this session. 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.
The Schedule 2 is the Summary of Administrative, Capital and Program Expenses. All of the information which appears in the pdf SA-111 version should appear on the SAMs system. ... If components have paid the BOCES during the aid year,...
By including Fair Trade in lesson plans, curricula, and school events, students understand the ways in which Fair Trade fits into their daily lives. Source Fair Trade Products . Offer Fair Trade products in cafeterias, vending machines, school stores or...
Pragmatics - George Yule - Chapter 1 3) In your opinion, why does the author use the metaphor of the "wastebasket" in the title of the third paragraph? Metaphor: when you use two nouns and compare or contrast them to...
Stichomythic Dialogue A poetic device originating in ancient classical tragedy, in which individual lines of verse dialogue are assigned to alternate speakers (i.e., back-and-forth repartee). These help to break up the long speeches and choral passages that make up most...
revise that friction is a force that acts in a direction to prevent (or tend to prevent) sliding motion. explain how an interaction pair of forces enables a wheel to make a vehicle move . explain how friction is caused...
Can also use implementation of ADT list Efficient to implement Might not be most time efficient as possible An Implementation That Uses the ADT List FIGURE 14-1 An implementation of the ADT queue that stores its entries in a list...