This Blog deals with different options in Google Cloud Platform.Services like Cloud SQL, Spanner…
Different Storage options
- Cloud Storage
- Cloud SQL
- Cloud BigQuery
- Cloud Spanner
- Cloud Bigtable
Cloud SQL
- Fully managed RDBMS service
- MySQL
- PostgreSQL
- Microsoft SQL Server
- PAAS solution, managed alternative of VM with Database
- Security – can be provisioned inside VPC
Cloud Spanner
- Relational database service
- Horizontal Scaling
- Best of relational and NoSQL databases
- Data is replicated synchronously strong consistency
Cloud BigTable
- Petabyte-scale, managed NoSQL
- Large-scale, low-latency
- Billions of rows & thousands of columns
- Equivalent to Apache HBase column-oriented database
Cloud BigQuery
- It’s Data warehousing Solution
- Serverless
- Highly scalable
- Critical Query processing on petabyte scale data
- It has built in BI engine and ML capability
Cloud Storage
- Object storage Solution
- Any kind of file (CSV, Image, Video, etc…)
- Scale to Exabyte’s of data Ø 99.999999999% durability
- Store High frequency access data as well as low frequency.
Cloud Storage Classes
Standard
- High frequency access
- Storage Costliest
- Access cost is very low
- Low latency
Nearline
- Low Frequency access
- Once in a 30 days
- Cheaper than standard
- Back up
Coldline
- Very low frequency to access
- Once in 90 days
- Cheaper than Nearline
Archive
- Offline data
- Backup
- Storage Cheapest
- Access cost very high.
