Active geo-replication for Azure SQL Hyperscale now in preview

Published 04-27-2021 01:46 PM 4,160 Views
Microsoft

Active geo-replication for Azure SQL Hyperscale now in preview

 

Business continuity is a key requirement to implement any business-critical system, not having a disaster recovery plan in place can put organizations at great financial loss, reputation damage and customer churn.

 

Active geo-replication is an Azure SQL Database business continuity and disaster recovery feature that allows customer applications to have a disaster recovery strategy and regional resiliency,  some of the key benefits include: 

 

  • Automatic asynchronous replication at the database level where data changes to the primary database are automatically replicated to a secondary database. 
  • Cross-region redundancy allowing applications to recover from loss of a datacenter or an entire region. 
  • Readable and online secondary databases that can be used for read-only workloads such as reporting. 

 

We are excited to announce the preview release of Active geo-replication for Azure SQL Database Hyperscale tier.  Azure SQL geo-replication feature provides the availability to create a readable secondary database in the same or in different region, in the case of regional disaster, failover to the secondary can initiated to have business continuity.

 

Hyperscale service tier supports 100 TB of database size, rapid scale (out and up) and nearly instantaneous database backups, removing the limits traditionally seen in cloud databases.

 

How Geo-replication works for Hyperscale?

 

When creating a geo-replica for Hyperscale,  the geo secondary is seeded with data from the primary and is a size of data operation. A geo-replica does not share page servers with the primary, even if they are in the same region. This provides the necessary redundancy for geo-failovers. 

 

 

roberto_bustos_0-1618874017369.png

 

 

Current preview limitations:

 

  • Only one geo-secondary in the same or a different region
  • Only forced failover supported
  • Using a geo-replica as the source database for Database Copy, or as the primary for another geo-secondary is not supported
  • Restore database from geo-secondary not supported
  • Auto-failover groups are not currently supported.

We are working on addressing these limitations to have Hyperscale with the same Active geo-replication capabilities that we have for other Azure SQL service tiers including Auto-failover groups support.  

 

Available regions 

 

Active Geo-replication for Hyperscale will be supported in all regions where Azure SQL Hyperscale is supported.

 

Quick Start

 

a. Configure from Portal using the Geo Replication blade

 

GeoDRPic.png

 

b. Configure using Azure CLI 

c. Configure using Powershell 

 

To learn more,

 

https://aka.ms/activegeoreplication

https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale

2 Comments
Contributor

Good update,  we are recently planning to use Azure sql db as backend for site core component this could help us for BCDR with proximity. Thanks for sharing

Occasional Visitor

Wonderful news. Thank you for the updates.

%3CLINGO-SUB%20id%3D%22lingo-sub-2299714%22%20slang%3D%22en-US%22%3ERe%3A%20Active%20geo-replication%20for%20Azure%20SQL%20Hyperscale%20now%20in%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2299714%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20update%2C%26nbsp%3B%20we%20are%20recently%20planning%20to%20use%20Azure%20sql%20db%20as%20backend%20for%20site%20core%20component%20this%20could%20help%20us%20for%20BCDR%20with%20proximity.%20Thanks%20for%20sharing%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2278570%22%20slang%3D%22en-US%22%3EActive%20geo-replication%20for%20Azure%20SQL%20Hyperscale%20now%20in%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2278570%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EActive%20geo-replication%20for%20Azure%20SQL%20Hyperscale%20now%20in%20preview%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EBusiness%20continuity%20is%20a%20key%20requirement%20to%20implement%20any%20business-critical%20system%2C%20not%20having%20a%20disaster%20recovery%20plan%20in%20place%20can%20put%20organizations%20at%20great%20financial%20loss%2C%20reputation%20damage%20and%20customer%20churn.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EActive%20geo-replication%20is%20an%20Azure%20SQL%20Database%26nbsp%3Bbusiness%20continuity%20and%20disaster%20recovery%26nbsp%3Bfeature%20that%26nbsp%3Ballows%20customer%20applications%20to%20have%20a%20disaster%20recovery%20strategy%20and%20regional%20resiliency%2C%26nbsp%3B%20some%20of%20the%26nbsp%3Bkey%26nbsp%3Bbenefits%20include%3A%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%222%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%221%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EAutomatic%20asynchronous%20replication%26nbsp%3Bat%26nbsp%3Bthe%20database%20level%20where%26nbsp%3Bdata%26nbsp%3Bchanges%20to%20the%20primary%20database%20are%20automatically%20replicated%20to%26nbsp%3Ba%26nbsp%3Bsecondary%20database.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%222%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%222%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ECross-region%20redundancy%26nbsp%3Ballowing%26nbsp%3Bapplications%20to%20recover%20from%20loss%20of%20a%20datacenter%20or%20an%20entire%20region.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A180%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%222%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EReadable%20and%20online%20secondary%20databases%20that%20can%20be%20used%20for%20read-only%20workloads%20such%20as%20reporting.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A180%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EWe%20are%20excited%20to%20announce%20the%20preview%20release%20of%20Active%20geo-replication%20for%20Azure%20SQL%20Database%20Hyperscale%20tier.%20%26nbsp%3BAzure%20SQL%20geo-replication%20feature%20provides%20the%20availability%20to%20create%20a%20readable%20secondary%20database%20in%20the%20same%20or%20in%20different%20region%2C%20in%20the%20case%20of%20regional%20disaster%2C%20failover%20to%20the%20secondary%20can%20initiated%20to%20have%20business%20continuity.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fservice-tier-hyperscale%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EHyperscale%3C%2FA%3E%20service%20tier%20supports%20100%20TB%20of%20database%20size%2C%20rapid%20scale%20(out%20and%20up)%20and%20nearly%20instantaneous%20database%20backups%2C%20removing%20the%20limits%20%3C%2FSPAN%3E%3CSPAN%3Etraditionally%20seen%20in%20cloud%20databases.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSTRONG%3EHow%20Geo-replication%20works%20for%20Hyperscale%3F%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EWhen%20creating%20a%20geo-replica%20for%20Hyperscale%2C%26nbsp%3B%20the%20geo%20secondary%20is%20seeded%20with%20data%20from%20the%20primary%20and%20is%20a%20size%20of%20data%20operation.%20A%20geo-replica%26nbsp%3Bdoes%26nbsp%3Bnot%26nbsp%3Bshare%26nbsp%3Bpage%20servers%20with%20the%20primary%2C%26nbsp%3Beven%20if%20they%20are%20in%26nbsp%3Bthe%20same%26nbsp%3Bregion.%26nbsp%3BThis%20provides%26nbsp%3Bthe%20necessary%20redundancy%26nbsp%3Bfor%26nbsp%3Bgeo-failovers.%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22roberto_bustos_0-1618874017369.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273952i5674938DC0CB8F83%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22roberto_bustos_0-1618874017369.png%22%20alt%3D%22roberto_bustos_0-1618874017369.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ECurrent%20preview%20limitations%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EOnly%20one%20geo-secondary%20in%20the%20same%20or%20a%20different%20region%3C%2FLI%3E%0A%3CLI%3EOnly%20forced%20failover%20supported%3C%2FLI%3E%0A%3CLI%3EUsing%20a%20geo-replica%20as%20the%20source%20database%20for%20Database%20Copy%2C%20or%20as%20the%20primary%20for%20another%20geo-secondary%20is%20not%20supported%3C%2FLI%3E%0A%3CLI%3ERestore%20database%20from%20geo-secondary%20not%20supported%3C%2FLI%3E%0A%3CLI%3EAuto-failover%20groups%20are%20not%20currently%20supported.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EWe%20are%20working%20on%20addressing%20these%20limitations%20to%20have%20Hyperscale%20with%20the%20same%20Active%20geo-replication%20capabilities%20that%20we%20have%20for%20other%20Azure%20SQL%20service%20tiers%20including%20Auto-failover%20groups%20support.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EAvailable%20regions%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EActive%20Geo-replication%20for%20Hyperscale%20will%20be%20supported%20in%20all%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fservice-tier-hyperscale%23available-regions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eregions%3C%2FA%3E%20where%20Azure%20SQL%20Hyperscale%20is%20supported.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EQuick%20Start%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ea.%20Configure%20from%20Portal%20using%20the%20Geo%20Replication%20blade%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorDenzil%20Ribeiro_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22GeoDRPic.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274466iB0A49ABDABC702C8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22GeoDRPic.png%22%20alt%3D%22GeoDRPic.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eb.%20Configure%20using%26nbsp%3B%3CA%20title%3D%22Azure%20CLI%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fscripts%2Fsql-database-setup-geodr-and-failover-database-cli%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20CLI%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ec.%20Configure%20using%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fscripts%2Fsetup-geodr-and-failover-database-powershell%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EPowershell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ETo%20learn%20more%2C%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Factivegeoreplication%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Factivegeoreplication%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fservice-tier-hyperscale%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fservice-tier-hyperscale%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2278570%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20availability%20to%3CSPAN%3E%26nbsp%3Bcreate%20a%20readable%20secondary%20database%20in%20the%20same%20or%20in%20different%20region%20using%20Active%26nbsp%3Bgeo-replication%20for%20Azure%20SQL%20Hyperscale%20tier%20is%20now%20in%20preview.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2278570%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20SQL%20Database%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2318408%22%20slang%3D%22en-US%22%3ERe%3A%20Active%20geo-replication%20for%20Azure%20SQL%20Hyperscale%20now%20in%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2318408%22%20slang%3D%22en-US%22%3E%3CP%3EWonderful%20news.%20Thank%20you%20for%20the%20updates.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Apr 27 2021 02:40 PM
Updated by: