You are viewing a free preview of this lesson.
Subscribe to unlock all 10 lessons in this course and every other course on LearningBro.
Azure provides fully managed database services for the two most popular open-source relational database engines: PostgreSQL and MySQL. These services handle infrastructure management, patching, backups, and high availability while remaining compatible with the community editions of each engine.
| Option | Status | Description |
|---|---|---|
| Flexible Server | Recommended | Full control over configuration, zone-redundant HA, and stop/start capability |
| Single Server | Retirement announced | Simpler model with fewer options; migrate to Flexible Server |
| Cosmos DB for PostgreSQL | Available | Distributed PostgreSQL (Citus) for multi-node, horizontally scaled workloads |
Flexible Server is the recommended deployment for all new PostgreSQL workloads on Azure.
Availability Zone 1 Availability Zone 2
┌──────────────────┐ ┌──────────────────┐
│ Primary Server │ ────────> │ Standby Server │
│ (Compute + Data)│ synchronous│ (Compute + Data)│
└──────────────────┘ replication└──────────────────┘
Subscribe to continue reading
Get full access to this lesson and all 10 lessons in this course.