Active geo-replication for Azure SQL Hyperscale now in preview

Published 04-27-2021 01:46 PM 4,913 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
  • Forced and planned failover not currently 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.  

 

In the case you need to make the geo-secondary a primary (writable database), follow the steps below:

 

1)   Break the geo-replication link using the cmdlet Remove-AzSqlDatabaseSecondary in PowerShell or az sql db replica delete link for Azure CLI, this will make the secondary database a read-write standalone database. Any data changes committed to the primary but not yet replicated to the secondary will be lost. These changes could be recovered when the old primary is available, or in some cases by restoring the old primary to the latest available point in time.

 

2)   If the old primary is available, delete it, then set up geo-replication for the new primary (a new secondary will be seeded).

 

3)   Update connection strings in your application accordingly.

 

 

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-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%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%3EForced%20and%20planned%20failover%20not%20currently%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%3EIn%20the%20case%20you%20need%20to%20make%20the%20geo-secondary%20a%20primary%20(writable%20database)%2C%20follow%20the%20steps%20below%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1)%26nbsp%3B%26nbsp%3B%20Break%20the%20geo-replication%20link%20using%20the%20cmdlet%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fen-us%252Fpowershell%252Fmodule%252Faz.sql%252Fremove-azsqldatabasesecondary%253Fview%253Dazps-5.9.0%26amp%3Bdata%3D04%257C01%257CRoberto.Bustos%2540microsoft.com%257Cc33afdd1551b47674f6708d91c5d5d8a%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637572009585664347%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DRYhQpuJyC91fcfdhEIvaCYN04hrOltd2HkgU4Z8V8CQ%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ERemove-AzSqlDatabaseSecondary%3C%2FA%3E%26nbsp%3Bin%20PowerShell%26nbsp%3B%3C%2FSPAN%3Eor%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Fdb%2Freplica%3Fview%3Dazure-cli-latest%23az_sql_db_replica_delete_link%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eaz%20sql%20db%20replica%20delete%20link%3C%2FA%3E%20for%20Azure%20CLI%2C%20this%20will%20make%20the%20secondary%20database%20a%20read-write%20standalone%20database.%20Any%20data%20changes%20committed%20to%20the%20primary%20but%20not%20yet%20replicated%20to%20the%20secondary%20will%20be%20lost.%20These%20changes%20could%20be%20recovered%20when%20the%20old%20primary%20is%20available%2C%20or%20in%20some%20cases%20by%20restoring%20the%20old%20primary%20to%20the%20latest%20available%20point%20in%20time.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E2)%26nbsp%3B%26nbsp%3B%20If%20the%20old%20primary%20is%20available%2C%20delete%20it%2C%20then%20set%20up%20geo-replication%20for%20the%20new%20primary%20(a%20new%20secondary%20will%20be%20seeded).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E3)%26nbsp%3B%26nbsp%3B%20Update%20connection%20strings%20in%20your%20application%20accordingly.%3C%2FP%3E%0A%3CP%3E%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
Version history
Last update:
‎May 21 2021 08:17 AM
Updated by: