Is it possible to see or specify the mysql single server availability zone?

alex 106

I have not found anything in the portal or the cli.

If you create a read-replica in the same region, you obviously want it in a different zone than the master.

2 answers

Andreas Baumgarten 97,731 Reputation points MVP

2021-02-19T22:51:55.04+00:00

I doubt you can see the availability zone a mysql server is running.

You can't specify the availability zone when creating a read-replica neither via portal nor with PowerShell or Azure CLI. Even if you know in which availability zone the source server is running, it doesn't help.
Sources;
https://learn.microsoft.com/en-us/azure/mysql/howto-read-replicas-portal
https://learn.microsoft.com/en-us/azure/mysql/howto-read-replicas-powershell
https://learn.microsoft.com/en-us/azure/mysql/howto-read-replicas-cli

The purpose of a read-replica is not focussing on high availability. At least that is my understanding.
Source: https://learn.microsoft.com/de-de/azure/mysql/concepts-read-replicas#when-to-use-a-read-replica

Some more information about HA and MySQL are here:
https://learn.microsoft.com/en-us/azure/mysql/concepts-high-availability

Maybe helpful as well;
Flexible Server for Azure Database for MySQL
https://techcommunity.microsoft.com/t5/azure-database-for-mysql/announcing-flexible-server-for-azure-database-for-mysql/ba-p/1686617

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten
Please sign in to rate this answer.
alex 106 Reputation points

2021-02-22T16:22:48.56+00:00

The purpose of a read-replica is not focussing on high availability

Of course it is, and the docs even state it explicitly:

if you need protection from a region failure, you can configure one or more read replicas in other regions for disaster recovery

I am merely looking for protection from a zone failure, and don't want a replica in another region but in a different zone.
Sign in to comment
Navtej Singh Saini 4,221 Reputation points Microsoft Employee

2021-02-24T03:21:51.743+00:00

@alex

Please check this link which confirms the zone redundancy as below in High Availability which points to this link.

Hope this helps to confirm.

Regards
Navtej S
Please sign in to rate this answer.
alex 106 Reputation points

2021-02-24T13:35:52.033+00:00

zone-redundant HA with auto fail-over is an explicit feature of flexible and that's what that pic appears to be showing.

I am asking about single-server. Its by definition has to be in some zone, but I can neither specify the zone nor see it after creation. Why? Again, if I were to create a replica in the same region for manual fail-over, I would want it obviously in a different zone from the master. Why is something this obvious so problematic?

Navtej Singh Saini 4,221 Reputation points Microsoft Employee

2021-02-27T00:13:22.52+00:00

@alex

We have response from our team:

"In zone redundant setup, service will make sure that both server is in different zone. We do not have a feature to explicitly choose zone in single server and supporting this is not in the Roadmap of single server. We are working on enabling customer to choose AZ for Flexible server and will be available in flexible server tentatively in a month."

Please let us know if you have any other question.

Regards
Navtej S

alex 106 Reputation points

2021-03-01T18:53:16.157+00:00

In zone redundant setup, service will make sure that both server is in different zone

Are they talking about flexible? I don't understand what "zone redundant setup" means for single-server. The single-server HA and replication docs don't mention zones at all.

https://learn.microsoft.com/en-us/azure/mysql/concepts-read-replicas
https://learn.microsoft.com/en-us/azure/mysql/concepts-high-availability

Are they saying that a single-server read-replica in the same region as the master is guaranteed to be in a different zone? Since that's a useful feature, why isn't it mentioned in the docs?

Navtej Singh Saini 4,221 Reputation points Microsoft Employee

2021-03-03T00:47:48.85+00:00

We apologize for the confusion. Here is the clarification from the team:

Are they talking about flexible? I don't understand what "zone redundant setup" means for single-server. The single-server HA and replication docs don't mention zones at all.
[Team] Yes, Zone redundant setup is the feature of flexible server and not single server. The single server HA and replication does not allow zone selection. You can read more about HA in flexible server here and HA in single server here.

Please let us know if you have any further questions.

Regards
Navtej S

Navtej Singh Saini 4,221 Reputation points Microsoft Employee

2021-03-03T00:48:10.243+00:00

Answer to second part:

Are they saying that a single-server read-replica in the same region as the master is guaranteed to be in a different zone? Since that's a useful feature, why isn't it mentioned in the docs?
[Team] No, Single server read-replica in the same region as the master is not guaranteed in a different zone.

Navtej Singh Saini 4,221 Reputation points Microsoft Employee

2021-03-05T22:58:20.803+00:00

@alex Please let us know if you need any further help.
Sign in to comment