GCP Storage Types

How to choose a storage solution?

Cloud Storage

• High performance, internet-scale
• Simple administration (Does not reqire capacity management)
• Data encryption at rest
• Data encryption in transit by default from Google endpoint
• Online and offline import services are available

• Tightly integrated with other services

• Immutable blobs

Bucket attributes	Bucket contents
Globally unique name	Files (in a flat namespace)
Storage class (Mulit-regional, Regional, Nerline, Coldline)
Location (region of multi-region)
IAM policies or Access Cotnroll Lists	Access Control Lists
Object versioning settings
Object lifecycle management rules

Get Data into Cloud Storage

• Online Transfer (Self-managed, Command-line tools like gsutil)
• Storage Transfer Service (Scheduled batch transfers)
• Transfer Appliance (Rackable applicances)

Cloud Bigtable

• Fully managed NoSQL, wide-column database service for terabyte applications
• NoSQL Schema. Not all columns have same datatype. Sparsely populated tables.
• Integrated (HBase API, Mative compatibility with big data, Hadoop)
• Compatibility to HBase
  • Bigtable is scaleable
  • Admin Tasks transparent
  • Same Database as Google Core Services
• Does not support SQL Queries
• No Muli-row transactions

When to choose Cloud BigTable

• Replicated storage
• Data encryptino in-flight and at rest
• Role-based ACLs
• Drives major applications

• IoT, User Analytics, Financial Analytics

• Big > 1TB
• Fast
• NoSQL
• Time series
• Big data
• Machine Learning

Cloud SQL

Database as a service.

• MySQL and PostgreSQL
• Automatic replication
• Managed backups
• Vertical scaling (read and write)
• Horizontal scaling (read)
• Google security

• Integrated in GCP services

• Full SQL
• No horizontal scalability

Cloud Spanner

• Horizontally scalable RDBMS
• Automatic replication
• Strong global consistency
• SQL Queries
• Managed instances with high availability
• Outgrown relational database, global data, consolidate database

• Financial applications, inventory applications

• Database >2TB
• Full SQL
• Horizontal scalability

Cloud Datastore

Horizontally scalable NoSQL DB.

• NoSQL designed for aplication backends
• Fully managed
• Built-in redundancy

• Supports ACID transactions

• Schemaless access
• Local development tools
• Includes a free daily quota

• Access from anywhere though a RESTful interface

• Unstructured objects
• Transactions
• SQL-like queries