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
AWS, Azure, and GCP Certifications are consistently among the top-paying IT certifications in the world, considering that most companies have now shifted to the cloud. Earn over $150,000 per year with an AWS, Azure, or GCP certification!
Follow us on LinkedIn, YouTube, Facebook, or join our Slack study group. More importantly, answer as many practice exams as you can to help increase your chances of passing your certification exams on your first try!
View Our AWS, Azure, and GCP Exam Reviewers Check out our FREE courses