Last updated on April 11, 2023
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: Single Server and Hyperscale (Citus)
- Single server pricing tiers: Basic, General Purpose, and Memory Optimized.
- Basic – light compute and I/O performance workloads.
- General Purpose – a balanced compute and memory with scalable I/O throughput workloads.
- Memory Optimized – for high performance database workloads requiring in-memory performance.
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
Get 20% Off – Christmas Big Sale on All Practice Exams, Video Courses, and eBooks!
Learn AWS with our PlayCloud Hands-On Labs
Tutorials Dojo Exam Study Guide eBooks
FREE AWS Exam Readiness Digital Courses
FREE AWS, Azure, GCP Practice Test Samplers
Subscribe to our YouTube Channel
Follow Us On Linkedin
Written by: Jon Bonso
Jon Bonso is the co-founder of Tutorials Dojo, an EdTech startup and an AWS Digital Training Partner that provides high-quality educational materials in the cloud computing space. He graduated from Mapúa Institute of Technology in 2007 with a bachelor's degree in Information Technology. Jon holds 10 AWS Certifications and is also an active AWS Community Builder since 2020.
