search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.24k stars 21.41k forks source link

Availability Zone behaviour #62912

Closed robertlagrant closed 4 years ago

robertlagrant commented 4 years ago

It would be good to know the behaviour of the Azure Postgres service regarding availability zones, where a region has an outage in one zone, but not in another. For example, it is possible to run a Kubernetes service across availability zones, but what happens to the Postgres database they connect to? Will that also survive?

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

Karishma-Tiwari-MSFT commented 4 years ago

Thanks for the question. We are currently investigating and will update you shortly.

Mike-Ubezzi-MSFT commented 4 years ago

Hi, @robertlagrant. The regional disaster recovery process is detailed in this document and essentially comes down to manually promoting a Read-Replica to Master. If you are looking for a complete high availability solution for Kubernetes based upon availability zones, please see: Create an Azure Kubernetes Service (AKS) cluster that uses availability zones. Additional information: Best practices for business continuity and disaster recovery in AKS.

So yes, it will survive but with manual intervention. Please see this TechCommunity blog to see about scripting the deployment and then using a script to make the promotion.

Azure Database for PostgreSQL (Single Server) Regional Disaster Plan

Scenario Recovery plan
Region failure Failure of a region is a rare event. However, if you need protection from a region failure, you can configure one or more read replicas in other regions for disaster recovery (DR). (See this article about creating and managing read replicas for details). In the event of a region-level failure, you can manually promote the read replica configured on the other region to be your production database server.

Please let me know if you have any additional questions here.

Mike-Ubezzi-MSFT commented 4 years ago

@robertlagrant Update to this conversation. The solution is the a new service - Azure Database for PostgreSQL - Flexible Server. Please see: High availability concepts in Azure Database for PostgreSQL - Flexible Server.

KalyanChanumolu-MSFT commented 4 years ago

@robertlagrant Its been a while we heard from you. We will proceed to close this issue now. If you need further assistance, please comment and we will gladly continue the conversation.

varunsharmas commented 3 years ago

The answer did not cover the question.. for the single server / hyperscale PG DB... there is not enough documentation on what happens when a AZ thats hosting the service fails.. region is still up; will the PG service come up in another AZ?