Azure Database for MySQL and PostgreSQL Cheat Sheet

• PaaS relational database services
• Mitigate database downtime with high availability, redundancy, and resiliency capabilities.
• Enables you to scale vertically when needed.
• Receive alerts based on the metrics of your servers.
• Protect sensitive data at rest and in transit.

• Automated backups, up to 35 days.
• PostgreSQL deployment options: Flexible Server and Hyperscale (Citus).
• Flexible Server pricing tiers: Burstable, General Purpose, and Memory Optimized.

  • Burstable – Best for low to moderate, variable workloads that don’t require full CPU continuously (e.g., dev/test, small apps).

  • General Purpose – A balanced compute and memory with scalable I/O throughput for most business workloads.

  • Memory Optimized – For high-performance database workloads requiring in-memory performance.

  High availability with 99.99% SLA: Both MySQL and PostgreSQL services now offer a financially backed 99.99% availability SLA, ensuring higher uptime for critical applications.

• MySQL Business Critical tier (now generally available): This tier provides high-performance local SSD storage, fast failovers, and built-in read replicas for scaling read-intensive workloads.

PostgreSQL – Hyperscale (Citus)

• Sharding – scales horizontally across multiple machines.
• Supports query parallelization for faster responses on large datasets.
• Primarily used for multi-tenant applications, real-time operational analytics, and high throughput transactional workloads.

Azure Database for MySQL and PostgreSQL Cheat Sheet Resources:

https://docs.microsoft.com/en-us/azure/mysql/overview
https://docs.microsoft.com/en-us/azure/postgresql/overview