Google Cloud SQL
Cloud SQL is a fully managed relational database service for MySQL, PostgreSQL, and SQL Server.
Key Features
- Managed: Automates backups, replication, patches, and updates.
- High Availability: Automatic failover.
- Security: Data encrypted at rest and in transit.
Use Cases
- Web Frameworks: Backend for Django, Rails, Spring, etc.
- CMS: Backend for WordPress, Drupal.
- E-commerce: Transactional data storage.
Key Concepts
- Instance: The database environment.
- Failover Replica: A standby instance for HA.
- Read Replica: A read-only copy to offload read traffic.
- Cloud SQL Proxy: Secure way to connect to instances without managing IP whitelists.