Microsoft Azure Mastery for .NET Architects
Lesson 12 of 30 40% of course

Azure Database for PostgreSQL/MySQL: Flexible server scaling

16 · 8 min · 5/23/2026

Sign in to track progress and bookmarks.

Open Source in Azure

Azure isn't just for SQL Server. It offers world-class managed services for PostgreSQL and MySQL.

1. Flexible Server

The **Flexible Server** architecture is the modern standard. It provides a dedicated virtual machine to run your database, giving you more control over the engine versions and the underlying ecosystem. It also supports **Stop/Start** functionality to save costs on non-production environments.

2. Why PostgreSQL for .NET?

PostgreSQL is widely considered the most 'Advanced' open-source database. It has incredible support for JSONB (Document storage inside SQL) and specialized indexing. Combined with the **Npgsql** Entity Framework provider, it's a powerful and cost-effective alternative to SQL Server.

3. Architect Insight

Q: "How do I handle high availability for Postgres?"

Architect Answer: "Enable **Zone Redundant High Availability**. Azure will automatically create a 'Standby' server in a different Availability Zone and keep the data synchronized. If the primary goes down, the standby takes over in seconds. This is your insurance policy for mission-critical open-source data."

Test your knowledge

Quizzes linked to this course—pass to earn certificates.

Browse all quizzes
Microsoft Azure Mastery for .NET Architects

On this page

1. Flexible Server 2. Why PostgreSQL for .NET? 3. Architect Insight
1. Azure Identity & Governance
Microsoft Entra ID (Azure AD): Scaling identity for .NET apps App Registrations & Service Principals: Secure machine identity Azure Policy & Blueprints: Enforcing architecture standards Resource Groups & Management Groups: Organizing the Cloud
2. Azure Web & Compute
Azure App Service: Managed hosting for ASP.NET Core Azure Functions: Serverless logic with Durable Functions Azure Container Apps (ACA): Serverless K8s for microservices Azure Kubernetes Service (AKS): Enterprise orchestration
3. Azure Databases
Azure SQL Database: The king of cloud-native SQL Azure Cosmos DB: Global scale with multi-model NoSQL Azure Cache for Redis: Managed memory performance Azure Database for PostgreSQL/MySQL: Flexible server scaling
4. Networking & Security
Azure Virtual Network (VNet): Subnets, Peering, and Gateways Azure Front Door: Global CDN & Load Balancing Azure Key Vault: Managing secrets, keys, and certificates Azure Application Gateway (WAF): Protecting the front-end
5. Messaging & Integration
Azure Service Bus: Enterprise-grade message queuing Azure Event Grid: Building reactive, event-driven systems Azure Event Hubs: Large-scale data ingestion for .NET Logic Apps: No-code orchestration for .NET developers
6. AI & Data Services
Azure OpenAI Service: Integrating GPT into .NET apps Cognitive Services: Vision, Speech, and Language APIs Azure Search (AI Search): Semantic search and vector indexing Azure Data Factory: ETL and data movement
7. Monitoring & Hybrid
Azure Monitor & Application Insights: Deep .NET observability Log Analytics: KQL (Kusto) for large-scale log analysis Azure Arc: Managing on-premise and multi-cloud from Azure Azure Bicep: Modern Infrastructure as Code for Azure
8. Enterprise Scale & Patterns
Cloud Adoption Framework (CAF): The Architect's strategy Case Study: Global retail scaling with Cosmos DB and AKS