Azure Postgresql Flexible Automatic Failover to another region

Mohan Kumar S 0 Reputation points
2023-03-10T12:07:58.1733333+00:00

We are using Azure Postgresql Flexible server with West Europe as primary region.

Is there Automatic failover to North Europe Incase of region outage in primary region? How do we move to Secondary region (North Europe)

What is the best approach for this without Downtime?

Azure Database for PostgreSQL

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 5,866 Reputation points Microsoft Employee
    2023-03-10T13:22:09.7866667+00:00

    Hi @Mohan Kumar S ,

    Welcome to Microsoft Q&A forum.

    As I understand, you have Azure Postgresql Flexible server with West Europe as primary region.

    And want to know automatic failover to secondary region.

    Unplanned outages include software bugs or infrastructure component failures that impact the availability of the database. If the primary server becomes unavailable, it is detected by the monitoring system and initiates a failover process. The process includes a few seconds of wait time to make sure it is not a false positive. The replication to the standby replica is severed and the standby replica is activated to be the primary database server. That includes the standby to recover any residual WAL files. Once it is fully recovered, DNS for the same end point is updated with the standby server's IP address. Clients can then retry connecting to the database server using the same connection string and resume their operations.

    If the question is: Can I configure HA across regions?
    No. HA is configured within a region, but across availability zones. In future, we are planning to offer read replicas that can be configured across regions for disaster recovery (DR) purposes. We will provide more details when the feature is enabled.

    Is zone redundant HA available in all regions?
    Zone-redundant HA is available in regions that support multiple AZs in the region. For the latest region support, please see this documentation. We are continuously adding more regions and enabling multiple AZs. Same-zone HA is available in all supported regions.

    Reference Link: HA configuration options

    Hope this helps. Let us know if your question is different to my understanding and require more insights.

    Thank you.

  2. GeethaThatipatri-MSFT 17,211 Reputation points Microsoft Employee
    2023-03-13T18:48:45.8833333+00:00

    @Mohan Kumar S Adding to what @ShaktiSingh-MSFT mentioned

    It is never recommended to use automatic failover in the case of cross-region (DR). Automatic failover should be used more from the HA perspective within AZ's as cross-AZ latency is negligible.

     Geo Redundant backups / Cross regions read replicas are your best options for DR scenarios and you can read more information below. 

    Read replicas - Azure Database for PostgreSQL - Flexible Server | Microsoft Learn

    Backup and restore in Azure Database for PostgreSQL - Flexible Server | Microsoft Learn

    Please let me know if you still have any questions.

    Regards

    Geetha