Episode

HA and DR at a glance with Azure Database for PostgreSQL

with Silvano Coriani

POSETTE: An Event for Postgres 2024

Video of a conference talk about HA and DR in Azure Database for PostgreSQL presented by Silvano Coriani at POSETTE: An Event for Postgres 2024. Implementing a highly available (HA) database tier for mission critical applications with PostgreSQL is not a walk in the park! It requires selecting the right technologies and workflows, plus involving people with the right skills. Those are the ingredients that a cloud vendor like Microsoft is baking into a PaaS service like Azure Database for PostgreSQL, so you can get business continuity out of the box.

In this session, you will learn about the capabilities offered by the Azure managed database service, from local and zone-redundant High Availability (HA) to Multi-region Disaster Recovery (DR) for PostgreSQL.

You will also learn how to leverage new features like Virtual Endpoints and Read Replica's ""Promote to Primary"" to create highly reliable deployments with minimal effort.

Silvano Coriani is a Program Manager in Azure Database for PostgreSQL team at Microsoft. He has over 25 years of experience in application development and database design, troubleshooting, and performance tuning. He is specialised in data access libraries, query optimisation, and distributed system design. He is also an author and speaker in many international industry conferences.

Chapters

  • 00:00 - Intro
  • 00:38 - Fundamental problem
  • 01:05 - Two key metrics: RTO & RPO
  • 02:19 - HA vs. DR vs. Backups
  • 04:24 - Business continuity in Azure
  • 07:28 - Flexible Server Architecture
  • 09:08 - Demo 1: Zone redundant HA
  • 18:18 - Demo 2: Multi-region DR
  • 26:00 - Geo redundant backups

Connect

Azure
Azure Database for PostgreSQL