Scale database up or down when geo replication is in use

Published 09-22-2020 05:17 AM 845 Views
Microsoft

Question:

When I'm using P1 tier for my geo-replicated database I can scale to another edition such as Standard or Business critical, but it will not allow me to scale to General purpose.

Why?

 

Short Answer:

When scaling between DTU and vCore model you may only scale between equivalent editions.

Standard is similar to General purpose and Premium to Business Critical.

If needed, scale both Primary and Secondary to Standard and then to General Purpose.

Never break the geo-replication setup for such modifications.

 

Answer:

When using Geo-Replication for your database the recommendation is to keep both in the same edition and tier.

 

The reason behind that is that (most common scenario) if the secondary will have lower tier compare to the primary, it might lag when processing changes coming from the primary database.

It will affect workloads running on both primary and secondary. And it will impact RPO and RTO when failover in needed.

 

However, if your workload is more of reads on the primary and less write, you may find that having lower tier on the secondary that need to deal with writes only will be more efficient for you (financial wise)

 

To allow customer to scale between editions (Standard, Premium) we must allow temporary hybrid setup while secondary and primary does not have the same edition.

 

The instructions about how to do that correctly is well described in additional considerations for scale database resource docs page.

 

Now back to our question, when scaling the database from Standard edition which uses DTU model we may only scale to General Purpose as this would be the equivalent edition in vCore model.

 

Same thing for Premium while the equivalent vCore edition is Business Critical.

 

Therefore if you need to go from P1 to GP (General Purpose) you may first scale both primary and secondary to Standard edition and then move to GP

 

In any case it is not recommended to break the geo-replication setup as during this time you have no active cross region High Availability solution for your database, this means that your database setup is vulnerable and might be impacted if an issue happen.

%3CLINGO-SUB%20id%3D%22lingo-sub-1698612%22%20slang%3D%22en-US%22%3EScale%20database%20up%20or%20down%20when%20geo%20replication%20is%20in%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1698612%22%20slang%3D%22en-US%22%3E%3CDIV%20style%3D%22direction%3A%20ltr%3B%20border-width%3A%20100%25%3B%22%3E%0A%3CDIV%20style%3D%22direction%3A%20ltr%3B%20margin-top%3A%200in%3B%20margin-left%3A%200in%3B%20width%3A%207.5895in%3B%22%3E%0A%3CDIV%20style%3D%22direction%3A%20ltr%3B%20margin-top%3A%200in%3B%20margin-left%3A%200in%3B%20width%3A%207.5895in%3B%22%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22font-weight%3A%20bold%3B%22%3EQuestion%3C%2FSPAN%3E%3A%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3EWhen%20I'm%20using%20P1%20tier%20for%20my%20geo-replicated%20database%20I%20can%20scale%20to%20another%20edition%20such%20as%20Standard%20or%20Business%20critical%2C%20but%20it%20will%20not%20allow%20me%20to%20scale%20to%20General%20purpose.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3EWhy%3F%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22font-weight%3A%20bold%3B%22%3EShort%20Answer%3A%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3EWhen%20scaling%20between%20DTU%20and%20vCore%20model%20you%20may%20only%20scale%20between%20equivalent%20editions.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3EStandard%20is%20similar%20to%20General%20purpose%20and%20Premium%20to%20Business%20Critical.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3EIf%20needed%2C%20scale%20both%20Primary%20and%20Secondary%20to%20Standard%20and%20then%20to%20General%20Purpose.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3ENever%20break%20the%20geo-replication%20setup%20for%20such%20modifications.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22font-weight%3A%20bold%3B%22%3EAnswer%3C%2FSPAN%3E%3A%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3EWhen%20using%20Geo-Replication%20for%20your%20database%20the%20recommendation%20is%20to%20keep%20both%20in%20the%20same%20edition%20and%20tier.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3EThe%20reason%20behind%20that%20is%20that%20(most%20common%20scenario)%20if%20the%20secondary%20will%20have%20lower%20tier%20compare%20to%20the%20primary%2C%20it%20might%20lag%20when%20processing%20changes%20coming%20from%20the%20primary%20database.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3EIt%20will%20affect%20workloads%20running%20on%20both%20primary%20and%20secondary.%20And%20it%20will%20impact%20RPO%20and%20RTO%20when%20failover%20in%20needed.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3EHowever%2C%20if%20your%20workload%20is%20more%20of%20reads%20on%20the%20primary%20and%20less%20write%2C%20you%20may%20find%20that%20having%20lower%20tier%20on%20the%20secondary%20that%20need%20to%20deal%20with%20writes%20only%20will%20be%20more%20efficient%20for%20you%20(financial%20wise)%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3ETo%20allow%20customer%20to%20scale%20between%20editions%20(Standard%2C%20Premium)%20we%20must%20allow%20temporary%20hybrid%20setup%20while%20secondary%20and%20primary%20does%20not%20have%20the%20same%20edition.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3EThe%20instructions%20about%20how%20to%20do%20that%20correctly%20is%20well%20described%20in%20additional%20considerations%20for%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fsingle-database-scale%23additional-considerations%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Escale%20database%20resource%3C%2FA%3E%20docs%20page.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3ENow%20back%20to%20our%20question%2C%20when%20scaling%20the%20database%20from%20Standard%20edition%20which%20uses%20DTU%20model%20we%20may%20only%20scale%20to%20General%20Purpose%20as%20this%20would%20be%20the%20equivalent%20edition%20in%20vCore%20model.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3ESame%20thing%20for%20Premium%20while%20the%20equivalent%20vCore%20edition%20is%20Business%20Critical.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3ETherefore%20if%20you%20need%20to%20go%20from%20P1%20to%20GP%20(General%20Purpose)%20you%20may%20first%20scale%20both%20primary%20and%20secondary%20to%20Standard%20edition%20and%20then%20move%20to%20GP%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2012.0pt%3B%22%20lang%3D%22en-US%22%3EIn%20any%20case%20it%20is%20not%20recommended%20to%20break%20the%20geo-replication%20setup%20as%20during%20this%20time%20you%20have%20no%20active%20cross%20region%20High%20Availability%20solution%20for%20your%20database%2C%20this%20means%20that%20your%20database%20setup%20is%20vulnerable%20and%20might%20be%20impacted%20if%20an%20issue%20happen.%3C%2FP%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Sep 22 2020 05:17 AM
Updated by: