Скачать или смотреть HA and DR at a glance with Azure Database for PostgreSQL | POSETTE 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

📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette

✅ Learn more:
Watch more POSETTE talks: https://aka.ms/posette-playlist-2024

📌 Let’s connect:
X – @PosetteConf https://x.com/PosetteConf
Mastodon - @posetteconf https://mastodon.social/@posetteconf
Threads – @posetteconf https://www.threads.net/@posetteconf

🔔 Subscribe to the POSETTE News: https://aka.ms/posette-subscribe

#PosetteConf #PostgreSQL #Azure

Presenters:
Silvano Coriani, Product Management - Postgres on Azure, Microsoft

Connect:
Silvano Coriani:   / scoriani  ,   / scoriani