Azure Arc Enabled SQL Managed Instance High Availability

Published Mar 02 2021 06:00 AM 2,321 Views
Microsoft

With Azure Arc, you can run Azure data services anywhere: on-premises, multi-cloud, and edge environments. Azure Arc enabled data services simplify data management with features such as automated provisioning, elastic scaling, and unified management from Azure. Today, we are happy to continue down this journey and announce the preview of Always On Availability Groups for Azure Arc enabled Managed Instance for improved high availability. 

 

Business continuity is a key requirement for many applications. On top of the high availability capabilities of Kubernetes which provides built-in health monitoring, failure detection, and automated redeployment mechanisms to maintain service health, Azure SQL managed instances can now be deployed with additional replicas for increased reliability. With a single deployment command, you can easily deploy an Azure SQL managed instance with a system-managed Always On Availability Group backed by multiple replicas.  

 

Azure Arc enabled SQL Managed Instance Always On Availability Groups offer the following capabilities: 

  • The three-replica availability group is managed internally, including creation of the availability group, and joining replicas to the availability group created 
  • All databases are automatically added to the availability group, including all user and system databases like master and  msdb. This capability provides a single system view across the availability group replicas 
  • An external endpoint is automatically provisioned for connecting to databases within the availability group for both read-write and read-only connections 
  • Ability to run read workloads by connecting to the secondary instances 
  • Automated failovers and instance redeployment in the event of pod or node failure 

HAAG.PNG

 

Simple Deployment

Deploying a managed instance backed by multiple replicas is easy. The following command deploys the architecture diagram illustrated above in your Kubernetes cluster.

 

 

 

 

 

 

 

 

 

 

azdata arc sql mi create -n myinstance --replicas 3

 

 

 

 

 

 

 

 

 

 

Learn More

Learn how to deploy Azure Arc enabled SQL Managed Instances with high availability here

 

See Always On Availability Groups in action in a recent talk below

 

%3CLINGO-SUB%20id%3D%22lingo-sub-2175515%22%20slang%3D%22en-US%22%3EAzure%20Arc%20Enabled%20SQL%20Managed%20Instance%20High%20Availability%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2175515%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EWith%20Azure%20Arc%2C%20you%20can%20run%20Azure%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ed%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eata%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Es%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eervices%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eanywhere%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eon-premises%2C%20multi-cloud%2C%20and%20edge%20environments.%20Azure%20Arc%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eenabled%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ed%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eata%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Es%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eervices%26nbsp%3Bsimplify%26nbsp%3Bdata%20management%20with%20features%20such%20as%20automated%20provisioning%2C%20elastic%20scaling%2C%20and%20unified%20management%20from%20Azure.%20Today%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Bwe%20are%20happy%20to%20continue%20down%20this%20journey%20and%20announce%20the%20preview%20of%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAlways%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EOn%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAvailability%20Groups%20for%20Azure%20Arc%20enabled%20Managed%20Instance%20for%20improved%20high%20availability.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EBusiness%20continuity%20is%20a%20key%20requirement%20for%20many%20applications.%20On%20top%20of%20the%20high%20availability%20capabilities%20of%20Kubernetes%20which%20provides%E2%80%AFbuilt-in%E2%80%AFhealth%E2%80%AFmonitoring%2C%E2%80%AFfailure%E2%80%AFdetection%2C%E2%80%AFand%E2%80%AF%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eautomated%20redeployment%E2%80%AF%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Emechanisms%E2%80%AFto%E2%80%AFmaintain%E2%80%AFservice%E2%80%AFhealth%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAzure%20SQL%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Emanaged%20instances%E2%80%AFcan%20now%20be%E2%80%AFdeployed%E2%80%AFwith%E2%80%AFadditional%E2%80%AFreplicas%E2%80%AFfor%20increased%20reliability.%E2%80%AFWith%20a%20single%20deployment%20command%2C%20you%20can%20easily%20deploy%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ea%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3En%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAzure%20SQL%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Emanaged%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Binstance%20with%20a%20system-managed%E2%80%AF%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAlways%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EOn%20A%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Evailability%E2%80%AF%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EG%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eroup%E2%80%AF%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ebacked%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Bby%20multiple%20replicas.%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAzure%20Arc%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Benabled%20SQL%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EManaged%20Instance%E2%80%AF%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAlways%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EOn%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EA%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Evailability%E2%80%AF%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EG%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eroups%20offer%20the%20following%E2%80%AFcapabilities%3A%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThe%20three-replica%E2%80%AFavailability%E2%80%AFgroup%E2%80%AFis%E2%80%AFmanaged%E2%80%AFinternally%2C%E2%80%AFincluding%E2%80%AFcreation%20of%20the%E2%80%AFavailability%E2%80%AFgroup%2C%E2%80%AFand%E2%80%AFjoining%E2%80%AFreplicas%E2%80%AFto%E2%80%AFthe%E2%80%AFavailability%E2%80%AFgroup%E2%80%AFcreated%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAll%E2%80%AFdatabases%E2%80%AFare%E2%80%AFautomatically%E2%80%AFadded%E2%80%AFto%E2%80%AFthe%E2%80%AFavailability%E2%80%AFgroup%2C%E2%80%AFincluding%E2%80%AFall%E2%80%AFuser%E2%80%AFand%E2%80%AFsystem%E2%80%AFdatabases%E2%80%AFlike%E2%80%AF%3CEM%3Emaster%3C%2FEM%3E%E2%80%AFand%E2%80%AF%20%3CEM%3Emsdb%3C%2FEM%3E.%E2%80%AFThis%E2%80%AFcapability%E2%80%AFprovides%E2%80%AFa%E2%80%AFsingle%20system%E2%80%AFview%E2%80%AFacross%E2%80%AFthe%E2%80%AFavailability%E2%80%AFgroup%E2%80%AFreplicas%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAn%E2%80%AFexternal%E2%80%AFendpoint%E2%80%AFis%E2%80%AFautomatically%E2%80%AFprovisioned%E2%80%AFfor%E2%80%AFconnecting%E2%80%AFto%E2%80%AFdatabases%E2%80%AFwithin%E2%80%AFthe%E2%80%AFavailability%E2%80%AFgroup%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Bfor%20both%20read-write%20and%20read-only%20connections%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAbility%20to%20run%20read%20workloads%20by%20connecting%20to%20the%20secondary%20instances%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAutomated%20failovers%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eand%20instance%20redeployment%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ein%20the%20event%20of%26nbsp%3Bpod%26nbsp%3Bor%20node%20failure%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22HAAG.PNG%22%20style%3D%22width%3A%20894px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F258622iEC7C96C444BC100C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22HAAG.PNG%22%20alt%3D%22HAAG.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1975671704%22%20id%3D%22toc-hId-1975671704%22%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3ESimple%20Deployment%3C%2FSPAN%3E%3C%2FH3%3E%0A%3CP%3EDeploying%20a%20managed%20instance%20backed%20by%20multiple%20replicas%20is%20easy.%20The%20following%20command%20deploys%20the%20architecture%20diagram%20illustrated%20above%20in%20your%20Kubernetes%20cluster.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-bash%22%3E%3CCODE%3Eazdata%20arc%20sql%20mi%20create%20-n%20myinstance%20--replicas%203%0A%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-168217241%22%20id%3D%22toc-hId-168217241%22%3ELearn%20More%3C%2FH3%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-arc%2Fdata%2Fmanaged-instance-high-availability%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ELearn%20how%20to%20deploy%20Azure%20Arc%20enabled%20SQL%20Managed%20Instances%20with%20high%20availability%20here%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20Always%20On%20Availability%20Groups%20in%20action%20in%20a%20recent%20talk%20below%3C%2FP%3E%0A%3CP%3E%3CIFRAME%20src%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FIT-Ops-Talk%2FOPS119-Databases-are-cattle-too-Running-highly-available-databases-consistently-on-any-infrastructur%2Fplayer%23time%3D34m0s%3Apaused%22%20width%3D%221170%22%20height%3D%22658.125%22%20frameborder%3D%220%22%20allowfullscreen%3D%22allowfullscreen%22%20title%3D%22OPS119%20-%20Databases%20are%20cattle%20too!%20Running%20highly%20available%20databases%20consistently%20on%20any%20infrastructure%20using%20Arc%20data%20services%20-%20Microsoft%20Channel%209%20Video%22%3E%3C%2FIFRAME%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2175515%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EToday%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Bwe%20are%20happy%20to%20continue%20down%20this%20journey%20and%20announce%20the%20preview%20of%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAlways%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EOn%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAvailability%20Groups%20for%20Azure%20Arc-enabled%20Managed%20Instance%20for%20improved%20high%20availability.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2175515%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Arc%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20services%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHybrid%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ekubernetes%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMulticloud%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 04 2021 03:59 PM
Updated by: