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

alex 106 Reputation points
2021-02-19T21:05:11.653+00:00

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.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
745 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Andreas Baumgarten 99,551 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


  2. 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.

    71388-image.png

    Hope this helps to confirm.

    Regards
    Navtej S