I have a Azure MySQL flexible server in central India and want to setup a active-passive or active-active DR. Any possible solution?

Question

I have a Azure MySQL flexible server in central India and want to setup a active-passive or active-active DR. Any possible solution?

Deepak Mehta 20

Currently, for our disaster recovery setup, I have created a read-replica in the South India region with GRS enabled. For our DR drills, we promote the replica server to a standalone instance manually.

I understand that Azure MySQL Flexible Server supports failover within availability zones in a region. However, I would like to know if there is any possible solution to enable failover across regions, i.e., regional failover, to achieve a more seamless DR capability.

Please advise if there are any built-in options, best practices, or alternative approaches available for regional failover in Azure MySQL Flexible Server.

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-07T03:44:22.7566667+00:00

Hi Deepak Mehta,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Deepak Mehta 20 Reputation points

2025-08-07T05:53:08.2+00:00

Hi Mahesh,

I have currently set up the read-replica solution for our disaster recovery (DR) requirement. As of now, I do not have any alternative solution in place.
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-08T03:00:55.7766667+00:00

Hi Deepak Mehta,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Accepted answer

0 additional answers

Your answer

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-07T03:44:22.7566667+00:00

Hi Deepak Mehta,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Deepak Mehta 20 Reputation points

2025-08-07T05:53:08.2+00:00

Hi Mahesh,

I have currently set up the read-replica solution for our disaster recovery (DR) requirement. As of now, I do not have any alternative solution in place.
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-08T03:00:55.7766667+00:00

Hi Deepak Mehta,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Hi Deepak Mehta,

Greetings!!

Currently, Azure MySQL Flexible Server does not support automatic regional failover (active-active or active-passive) across regions. However, you're on the right track with your existing setup using a read replica in South India and geo-redundant backups. User's image

To enhance your DR capabilities, consider the following best practices:

Geo-Redundant Backups: Ensure geo-redundant backup storage is enabled at server creation. This allows you to perform a geo-restore in the paired region in case of a regional outage.

Cross-Region Read Replica: Continue using a read replica in a secondary region. During DR drills or actual failover, promote the replica manually to a standalone server. This is currently the most seamless way to achieve regional failover.

Automation for DR Drills: Consider automating the promotion and reconfiguration process using Azure CLI or automation scripts to reduce manual effort and improve RTO.

Zone-Redundant HA (Intra-Region): For protection against zone-level failures, enable zone-redundant high availability within the same region.

For more information, please refer the document: https://techcommunity.microsoft.com/blog/adformysql/dial-up-azure-db-for-mysql-flexible-server-disaster-recovery-plans-with-geo-back/2893965

https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-business-continuity#requirements-and-limitations

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

I have a Azure MySQL flexible server in central India and want to setup a active-passive or active-active DR. Any possible solution?

0 additional answers

Your answer