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 TypeGoogle Cloud ServiceUse Case Examples
RelationalBare Metal Solution for Oracle

Lift and shift Oracle workloads to Google Cloud
Legacy applications
Data center retirement
RelationalCloud 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
RelationalCloud 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 valueCloud 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
DocumentFirestore

Cloud-native NoSQL to easily develop rich mobile, web, and IoT applications
Mobile/web/IoT applications
Real-time sync
Offline sync
DocumentFirebase Realtime Database

Store and sync data in real time
Mobile sign-ins
Personalized applications and ads
In-app chat
In-memoryMemorystore

Fully managed Redis and Memcached for sub-millisecond data access
Caching
Gaming
Leaderboard
Social chat or news feed
Additional NoSQLMongoDB Atlas

Global cloud database service for modern applications
Mobile/web/IoT applications
Gaming
Content management
Single view
Additional NoSQLGoogle 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/

Leave a Comment

Your email address will not be published. Required fields are marked *