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

alex 106 Reputation points

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

    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.

    The purpose of a read-replica is not focussing on high availability. At least that is my understanding.

    Some more information about HA and MySQL are here:

    Maybe helpful as well;
    Flexible Server for Azure Database for MySQL


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

    Andreas Baumgarten

  2. Navtej Singh Saini 4,221 Reputation points Microsoft Employee


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


    Hope this helps to confirm.

    Navtej S