Azure Fundamentals · Lesson

Azure Database for Open-Source Engines

Use managed services for PostgreSQL, MySQL, and MariaDB on Azure, and compare them with running your own engine on a VM.

Why Managed Open-Source Databases?

Many organisations run open-source relational engines — PostgreSQL, MySQL, and MariaDB — as the backbone of their applications. Rather than managing these engines on VMs (patching, backups, HA configuration), Azure provides fully managed PaaS services that handle the operational heavy lifting while keeping the familiar SQL interface your developers already know.

Azure Database for PostgreSQL

Azure Database for PostgreSQL is a fully managed service supporting PostgreSQL versions 11 through 16. It offers two deployment modes: Single Server (being retired) and Flexible Server, the current recommended option. Flexible Server gives you a choice of burstable, general purpose, and memory-optimised compute tiers, and supports standby replicas within or across availability zones for high availability.

# Create a Flexible Server PostgreSQL instance
az postgres flexible-server create \
  --resource-group myRG \
  --name mypgserver \
  --location eastus \
  --admin-user pgadmin \
  --admin-password 'P@ssw0rd!' \
  --sku-name Standard_D2s_v3 \
  --tier GeneralPurpose \
  --version 16 \
  --high-availability ZoneRedundant

All lessons in this course

← Back to Azure Fundamentals