Dynamics AX High Availability Disaster Recovery January 20
Dynamics AX High Availability & Disaster Recovery January 20, 2022
Agenda • Disaster Recovery Overview • SQL Server • • Editions Licensing Overview HA/DR Technologies HA/DR Features by Edition • AX Considerations • HA/DR Technologies – What you should know • Always. On • Features • Quorum Considerations • Hybrid Scenarios • HA/DR Architectures
Introduction & Objectives About Me About Stoneridge Objective 1 Objective 2 • Josh Lee– Senior Consultant • Focus on Performance, SQL and Stack technologies • Former AX Partner Technical Consultant and Premier Field Engineer for SQL • Microsoft Gold Partner focused on Dynamics AX in Upper Midwest • True product experts with deep experience at Microsoft and in partner channel • Understand High Availability Options for AX • Understand Disaster Recovery options with SQL Server
Disaster Recovery Overview January 20, 2022
What is your Disaster Recovery Plan?
Downtime Planned Unplanned
Recovery Objectives RTO RPO
Return on Investment Avoiding/Reducing Downtime Resource Utilization Automating Recovery
SQL Server Overview January 20, 2022
SQL Server Editions Enterprise Business Intelligence Standard
Licensing Per Core (2 to a pack) Server/CAL
Licensing Per Edition Per Core Enterprise Standard Server/CAL Business Intelligence Free Express
High Availability and Disaster Recovery Technologies WSFC (Always. On FCI) Always On AG Transactional/Snapshot Replication Database Mirroring Log Shipping *Hyper‐V
Features By Editions Enterprise BI Standard Max Cores OS Max 4 Sockets/16 Cores Max Memory OS Max 64/128 GB* Log Shipping Database Mirroring AO FCI ‐ Safety Only ‐ 2 nodes Availability Group Snapshots 2012 ‐ https: //msdn. microsoft. com/en‐us/library/cc 645993(v=sql. 110). aspx 2014 ‐ https: //msdn. microsoft. com/en‐us/library/cc 645993(v=sql. 120). aspx
Comparisons HA/DR Solution RPO RTO Automatic Failover Usable Secondarys AG ‐ synchronous commit 0 Seconds Yes 0‐ 2* AG ‐ asynchronous commit Seconds* Minutes No 0‐ 4* * Seconds ‐ Minutes Yes No 0 Seconds Yes, but. . DBM – high performance Seconds Minutes* No Yes, but. . Log Shipping Minutes – Hours* No Yes, but. . Backup, Copy, Restore Hours* Hours – Days* No Yes, but. . AO‐FCI DBM – high safety
Components of AX AX MR SSRS SSAS
What’s Supported? FCI Always. On Availability Groups (Sync/Async) Log Shipping DBM Transactional/Snapshot Replication
What You Should Know January 20, 2022
What You Should Know - DBM Async ‐ Enterprise Individual DBs Automatic Failover = Witness Placed on deprecated in 2012
What You Should Know - Transactional Requires PK You cannot drop/recreate PKs Terms/Concept s Non‐clustered indexes not default Distribution DB
What You Should Know – Log Shipping No automatic failover Reversal is tricky Data Loss Window
What You Should Know – Clustering Same domain Know your Quorum Shared Storage Enhanced WS 2012+
What You Should Know – AG WSFC AGL ROR Enterprise Only Keywords Logins/Jobs Group of DBs
What You Should Know - AX SSRS cannot be clustered* RS failover broken – not really Read‐only replicas can be used for processing cubes Patch
Patches that I know of. . • AX 2012 RTM – KB 2920058 • AX 2012 R 2 – KB 2956617 • AX 2012 R 2 ‐ KB 2869651 • All 2012 Versions – KB 2984666
Always. On January 20, 2022
Always. On FCI Always. On AG
Always. On - FCI Enhanced Multi‐subnet Support Enhanced Health Monitoring Flexible Failover Policy
Always. On - AG AGL Read Only Routing Groups DBs Flexible Storage
Quorum Considerations January 20, 2022
Quorum Node Majority Mode Majority with Witness No Majority
Dynamic Quorum Windows 2012 Adjusts Quorum Sequentially loss only
Dynamic Witness Windows 2012 R 2 ‐ Default ON Adjusts Witness Vote Even Number Vote Odd Number No Vote Windows 2012 R 2 Always Configure Witness Quorum
Node Weight (Votes) No vote by default Exclude secondary site nodes Include all primary replicas Include possible automatic failover owners Odd number of votes Re‐assess vote assignments post‐failover
Tie breaker for 50% node split Cluster Property (Lower. Quorum. Priority. Node. ID) Allows weight for cluster vote removal Mainly for DR configurations
What You Should Know – AG/FCI DR TTL – 20 m (default) DNS propagation delays Multi. Subnet. Failover=True Evaluate Quorum
Hybrid January 20, 2022
Hybrid cloud solutions Simplified cloud backup Cloud disaster recovery Manual or automatic At an instance level with point ‐in‐time restore Measures database usage patterns to set backup frequency Fast disaster recovery (low RTO) Easy to deploy and manage Windows Azure Secondary replica Asynchronous commit VPN tunnel (Windows Azure Virtual Network) On‐premises network Extend on‐premises apps Domain controller Cloud bursting Greater global reach Better isolation of internal assets Synchronous commit Primary replica Secondary replica
Hybrid DR for SQL Server Deploy 1 or more replicas on‐premise Determine region Low TCO
Architectures January 20, 2022
Database Mirroring Primary Secondary Database Mirroring (sync) Witness
Failover Clustering with Database Mirroring SQL Server FCI 2 SQL Server FCI 1 Database Mirroring (Async) Windows Server Failover Cluster 1 Windows Server Failover Cluster 2
Log Shipping Backup Share Primary Backup Secondarys Copy Restore
Log Shipping with Database Mirroring Primary Secondary Database Mirroring (sync) Witness Log Shipping
Transactional Replication Publisher Distributer (optional)* Subscriber
Failover Cluster Instance with Availability Group Windows Server Failover Cluster DR Site Primary Site Node 1 Node 3 Node 2 Availability Group Synchronous / Asynchronous Node 4
Availability Groups for HA and DR Windows Server Failover Cluster Primary Site DR Site Node 2 Node 1 Node 3 Availability Group Synchronous Asynchronous
Quorum Model and Node Votes Windows Server Failover Cluster Primary Site DR Site Node 2 Node 1 VOTE Node 3 Availability Group VOTE Synchronous Asynchronous VOTE NO VOTE
Hybrid – Typical Configuration Windows Azure On-Premises 49
Hybrid – Robust
Hybrid - Reverse Configuration On-Premises Windows Azure 51
- Slides: 52