You are viewing a free preview of this lesson.
Subscribe to unlock all 10 lessons in this course and every other course on LearningBro.
Choosing the right database service and designing your data layer correctly are among the most consequential decisions in any GCP project. This lesson consolidates best practices for selecting, designing, operating, and securing databases on Google Cloud Platform.
GCP offers many database services, each optimised for specific workloads. The first and most important decision is selecting the right one:
| Requirement | Recommended Service |
|---|---|
| Traditional relational (MySQL, PostgreSQL, SQL Server) | Cloud SQL |
| High-performance PostgreSQL with analytics | AlloyDB |
| Globally distributed relational with strong consistency | Cloud Spanner |
| Document-oriented with real-time sync | Firestore |
| Wide-column NoSQL at petabyte scale | Cloud Bigtable |
| In-memory caching | Memorystore (Redis or Memcached) |
| Low-latency real-time sync (chat, presence) | Firebase Realtime Database |
| Data warehouse and analytics | BigQuery (not a traditional database, but often relevant) |
Ask these questions:
Subscribe to continue reading
Get full access to this lesson and all 10 lessons in this course.