GCP Architecture: Choosing the Right Database/Storage for your workload
Create, Migrate, Modernize, Transform your current database to Google Cloud Service database. There are some database/storage that available on GCP. These are the matrix that you can use to decide based on the characteristic and use case example.
Flowchart to decide the database based on structured, analytic, relational, scalability, low latency update, mobile sdk:
Flowchart to decide based on structured, semi structured, unstructured data:
| Database Type | Google Cloud Service | Use Case Examples |
|---|---|---|
| Relational | Bare Metal Solution for Oracle Lift and shift Oracle workloads to Google Cloud | Legacy applications Data center retirement |
| Relational | Cloud SQL Managed MySQL, PostgreSQL, and SQL Server Learn how to simplify migrations to Cloud SQL from MySQL and PostgreSQL with the Database Migration Service Learn how to migrate from Oracle to PostgreSQL with minimal downtime with Datastream | ERP CRM Ecommerce and web SaaS application |
| Relational | Cloud Spanner Cloud-native with unlimited scale, consistency, and 99.999% availability Learn how to migrate from databases such as Oracle or DynamoDB | Gaming Global financial ledger Supply chain/inventory management |
| Key value | Cloud Bigtable Cloud-native NoSQL wide-column store for large scale, low-latency workloads Learn how to migrate from HBase or Cassandra | Personalization Adtech Recommendation engines Fraud detection |
| Document | Firestore Cloud-native NoSQL to easily develop rich mobile, web, and IoT applications | Mobile/web/IoT applications Real-time sync Offline sync |
| Document | Firebase Realtime Database Store and sync data in real time | Mobile sign-ins Personalized applications and ads In-app chat |
| In-memory | Memorystore Fully managed Redis and Memcached for sub-millisecond data access | Caching Gaming Leaderboard Social chat or news feed |
| Additional NoSQL | MongoDB Atlas Global cloud database service for modern applications | Mobile/web/IoT applications Gaming Content management Single view |
| Additional NoSQL | Google Cloud Partner Services Managed offerings from our open source partner network, including MongoDB, Datastax, Redis Labs, and Neo4j | Leverage existing investments |
Reference:
– https://cloud.google.com/products/databases/
– https://cloud.google.com/architecture/data-lifecycle-cloud-platform/
Hi , do you have similar aws architecture decison flowchart or guide me where I can get in similar manner…
A cloud architecture is the most advanced and cutting-edge technology. The technique you described in this post, which includes reviewing…
Hi Tama, thanks for reading this article. Definitely the answer will be back to your decision, but here are some…
Hello Mr.Doddi! I've been read for your article since 2 years ago before i get into a collage. Then now…