Cloud Fundamentals
/Intermediate
Managed SQL Databases
Definition
Cloud services that provide fully automated Relational Database Management Systems. The provider handles provisioning, patching, backups, and failover, while the customer simply connects and runs SQL queries.
Explain Like I'm New
Running a database without a Database Administrator. AWS installs the database, updates it, backs it up every night, and fixes it if it breaks. You just write the SQL code.
Real World Example
AWS RDS, Azure SQL Database, GCP Cloud SQL. A startup needs a MySQL database. Instead of spinning up a raw VM and installing MySQL manually, they click a button in RDS. AWS provides a connection string, and automatically handles all future maintenance.
Common Use Cases
- •Traditional web applications
- •Transactional systems (ACID)
- •ERP systems
Interview Questions
basic
- In a Managed SQL service, do you have SSH access to the underlying Linux server running the database?
intermediate
- What is a 'Multi-AZ' deployment in cloud databases?