Forced failover for Azure Database for MySQL – Flexible Server

Published 04-26-2021 11:52 AM 1,188 Views
Microsoft

We’re pleased to announce the availability of forced failover for Azure Database for MySQL - Flexible Server in all zone redundant regions. This functionality enables you to manually force a failover to test functionality with your application scenarios, which can help to prepare you in case of any outages.

 

When you trigger a failover, the standby replica is activated to become the primary server with the same database server name by updating the DNS record. While client connections are disconnected, you can automatically reconnect them to resume operations if you have implemented retry-logic, which is recommended for cloud native applications.

 

Before the forced failover begins, a pop-up window displays the estimated time for completion of the operation by factoring the recency of the last checkpoint and the current transactions running on the primary server.

 

Forcing a failover in Azure Database for MySQL – Flexible Server using the Azure Portal

To force a failover from your primary server to a standby instance of Flexible Server, perform the following steps:

 

  1. In the Azure portal, select an existing instance of Azure Database for MySQL Flexible Server that has high availability enabled.
  2. On the page associated with the selected server, under Settings, select High availability.
  3. On the High availability page, make a note of the values associated with Primary availability zone and Standby availability zone.

  We’ll compare these numbers to similar values we get after the failover completes.

  1. To initiate the manual failover procedure, select Forced Failover.

Image1.png

 

A pop-up window displays the estimated failover time, estimated based on the current workload on the primary server and the recency of the last checkpoint.

 

Image2.png

 

  1. Read the message, and then select OK.

An "Initiating the failover process..." notification appears. Then, after failover to the standby server completes successfully, second notification appears.

 

Image4.png

 

  1. Compare the new Primary availability zone and the Standby availability zone to the values before the failover.

 

Image5.png

 

Notice that the value of the Primary availability zone is now the original value of the Standby availability zone.

 

As you can see, the forced failover process is easy to accomplish and use in your own environment. Azure Database for MySQL Flexible Server also offers automatic failover using zone redundant high availability. For more information, see High availability concepts in Azure Database for MySQL Flexible Server.

%3CLINGO-SUB%20id%3D%22lingo-sub-2280671%22%20slang%3D%22en-US%22%3EForced%20failover%20for%20Azure%20Database%20for%20MySQL%20%E2%80%93%20Flexible%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280671%22%20slang%3D%22en-US%22%3E%3CP%3EWe%E2%80%99re%20pleased%20to%20announce%20the%3CSPAN%3E%20availability%20of%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FForcedFailover%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eforced%20failover%3C%2FA%3E%20for%20%3CSPAN%3EAzure%20Database%20for%20MySQL%20-%20Flexible%20Server%20in%20all%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fmysql%2Fflexible-server%2Foverview%23azure-regions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ezone%20redundant%20regions%3C%2FA%3E%3CSPAN%3E.%20This%20functionality%20enables%20you%20to%20manually%20force%20a%20failover%20to%20test%20functionality%20with%20your%20application%20scenarios%2C%20which%20can%20help%20to%20prepare%20you%20in%20case%20of%20any%20outages.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EWhen%20you%20trigger%20a%20failover%2C%20the%20standby%20replica%20is%20activated%20to%20become%20the%20primary%20server%20with%20the%20same%20database%20server%20name%20by%20updating%20the%20DNS%20record.%20While%20client%20connections%20are%20disconnected%2C%20you%20can%20%3C%2FSPAN%3Eautomatically%20reconnect%20them%20to%20resume%20operations%20if%20you%20have%20implemented%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fmysql%2Fconcepts-connectivity%23handling-transient-errors%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eretry-logic%3C%2FA%3E%2C%20which%20is%20recommended%20for%20cloud%20native%20applications.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EBefore%20the%20forced%20failover%20begins%2C%20a%20pop-up%20window%20displays%20the%20estimated%20time%20for%20completion%20of%20the%20operation%20by%20factoring%20the%20recency%20of%20the%20last%20checkpoint%20and%20the%20current%20transactions%20running%20on%20the%20primary%20server.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSTRONG%3EForcing%20a%20failover%20in%20Azure%20Database%20for%20MySQL%20%E2%80%93%20Flexible%20Server%20using%20the%20Azure%20Portal%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ETo%20force%20a%20failover%20from%20your%20primary%20server%20to%20a%20standby%20instance%20of%20Flexible%20Server%2C%20perform%20the%20following%20steps%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EIn%20the%20%3CA%20href%3D%22https%3A%2F%2Fportal.azure.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EAzure%20portal%3C%2FA%3E%2C%20select%20an%20existing%20instance%20of%20Azure%20Database%20for%20MySQL%20Flexible%20Server%20that%20has%20high%20availability%20enabled.%3C%2FLI%3E%0A%3CLI%3EOn%20the%20page%20associated%20with%20the%20selected%20server%2C%20under%20%3CSTRONG%3ESettings%3C%2FSTRONG%3E%2C%20select%20%3CSTRONG%3EHigh%20availability%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3CLI%3EOn%20the%20%3CSTRONG%3EHigh%20availability%3C%2FSTRONG%3E%20page%2C%20make%20a%20note%20of%20the%20values%20associated%20with%20%3CSTRONG%3EPrimary%20availability%20zone%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EStandby%20availability%20zone%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%20class%3D%22lia-align-left%20lia-indent-padding-left-30px%22%3E%26nbsp%3B%20We%E2%80%99ll%20compare%20these%20numbers%20to%20similar%20values%20we%20get%20after%20the%20failover%20completes.%3C%2FP%3E%0A%3COL%20start%3D%224%22%3E%0A%3CLI%3ETo%20initiate%20the%20manual%20failover%20procedure%2C%20select%20%3CSTRONG%3EForced%20Failover%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Image1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274558i2151C84735B451F6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Image1.png%22%20alt%3D%22Image1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3EA%20pop-up%20window%20displays%20the%20estimated%20failover%20time%2C%20estimated%20based%20on%20the%20current%20workload%20on%20the%20primary%20server%20and%20the%20recency%20of%20the%20last%20checkpoint.%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Image2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274552i4BF21988DAC7E191%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Image2.png%22%20alt%3D%22Image2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20start%3D%225%22%3E%0A%3CLI%3ERead%20the%20message%2C%20and%20then%20select%20%3CSTRONG%3EOK%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3EAn%20%22Initiating%20the%20failover%20process...%22%20notification%20appears.%20Then%2C%20after%26nbsp%3Bfailover%20to%20the%20standby%20server%20completes%20successfully%2C%20second%20notification%20appears.%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorJim%20Toland_3%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Image4.png%22%20style%3D%22width%3A%20479px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274555iFFE79198D4A0A3E8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Image4.png%22%20alt%3D%22Image4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20start%3D%226%22%3E%0A%3CLI%3ECompare%20the%20new%20%3CSTRONG%3EPrimary%20availability%20zone%3C%2FSTRONG%3E%20and%20the%20%3CSTRONG%3EStandby%20availability%20zone%20%3C%2FSTRONG%3E%3CSTRONG%3Eto%20the%20values%20before%20the%20failover%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Image5.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274562i076396C4872229FE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Image5.png%22%20alt%3D%22Image5.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3ENotice%20that%20the%20value%20of%20the%20%3CSTRONG%3EPrimary%20availability%20zone%3C%2FSTRONG%3E%20is%20now%20the%20original%20value%20of%20the%20%3CSTRONG%3EStandby%20availability%20zone%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20you%20can%20see%2C%20the%20forced%20failover%20process%20is%20easy%20to%20accomplish%20and%20use%20in%20your%20own%20environment.%20Azure%20Database%20for%20MySQL%20Flexible%20Server%20also%20offers%20automatic%20failover%20using%20zone%20redundant%20high%20availability.%20For%20more%20information%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fmysql%2Fflexible-server%2Fconcepts-high-availability%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EHigh%20availability%20concepts%20in%20Azure%20Database%20for%20MySQL%20Flexible%20Server%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2280671%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22TextRun%20SCXW7463338%20BCX8%22%20data-contrast%3D%22auto%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%3EWe%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%3E%E2%80%99re%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%3Epleased%20to%20announce%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ethe%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW7463338%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%20data-ccp-charstyle-defn%3D%22%7B%26quot%3BObjectId%26quot%3B%3A%26quot%3B50b70566-c736-464e-b516-a490c5d86317%7C18%26quot%3B%2C%26quot%3BClassId%26quot%3B%3A1073872969%2C%26quot%3BProperties%26quot%3B%3A%5B134233614%2C%26quot%3Btrue%26quot%3B%2C201340122%2C%26quot%3B1%26quot%3B%2C469775450%2C%26quot%3Bnormaltextrun%26quot%3B%2C469778129%2C%26quot%3Bnormaltextrun%26quot%3B%2C469778324%2C%26quot%3BDefault%20Paragraph%20Font%26quot%3B%5D%7D%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Eavailability%20of%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CA%20class%3D%22Hyperlink%20SCXW7463338%20BCX8%22%20href%3D%22https%3A%2F%2Faka.ms%2FForcedFailover%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%22%3E%3CSPAN%20class%3D%22TextRun%20Underlined%20SCXW7463338%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3Ef%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3Eorced%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3Ef%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3Eailover%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20class%3D%22TextRun%20SCXW7463338%20BCX8%22%20data-contrast%3D%22auto%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efor%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW7463338%20BCX8%22%20data-contrast%3D%22auto%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW7463338%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3EAzure%20Database%20for%20MySQL%20-%20Flexible%20Server%20in%20all%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CA%20class%3D%22Hyperlink%20SCXW7463338%20BCX8%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fmysql%2Fflexible-server%2Foverview%23azure-regions%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%22%3E%3CSPAN%20class%3D%22TextRun%20Underlined%20SCXW7463338%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22Hyperlink%22%3Ezone%20redundant%20regions%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20class%3D%22TextRun%20SCXW7463338%20BCX8%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3E.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3EThis%20functionality%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Eenables%20you%20to%20manually%20force%20a%20failover%20to%20test%20functionality%20with%20your%20application%20scenarios%2C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Ewhich%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Ecan%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Ehelp%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eto%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Eprepare%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW7463338%20BCX8%22%20data-ccp-charstyle%3D%22normaltextrun%22%3Eyou%20in%20case%20of%20any%20outages.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22EOP%20SCXW7463338%20BCX8%22%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A120%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Overview%20graphic.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274460i3247CC928CCA65C3%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Overview%20graphic.png%22%20alt%3D%22Overview%20graphic.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Co-Authors
Version history
Last update:
‎Apr 21 2021 06:56 PM
Updated by: