Sign in to confirm you’re not a bot
This helps protect our community. Learn more

HA and DR at a glance with Azure Database for PostgreSQL | POSETTE 2024

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
932 views 10 months ago #Azure #PostgreSQL #PosetteConf
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  …...more
...more
HA and DR at a glance with Azure Database for PostgreSQL | POSETTE 2024
22Likes
932Views
Jun 132024
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  

Follow along using the transcript.

Microsoft Developer

588K subscribers