Databases

Database in GCP and how to use them effectively

Cloud SQL

Managed relational db that use

  • Cloud SQL for PostgreSQL

  • Cloud SQL for MySQL

  • Cloud SQL for SQL Server


Bigtable

A table that can have billions of rows and thousands of columns.

Each row has a key and it is indexed.

It support high read and write throughput at low latency.

Spanner

Relational db structure but can scale like non-relational.

Provide high performance and consistency across rows, regions and continents

Spanner provides a 99.999% availability SLA.

It has no planned downtime and enterprise grade security

Memorystore

A managed Redis service for Google Cloud.

Use to increase performance by highly available, scalable, secure Redis service. Customer need not have to worry about managing Redis deployment

Firestore

NOSQL document database that provide

  • high scale

  • high performance


Firebase realtime database

Firebase store data as JSON. It synchronize in real time to every connected client.

It is great for building cross platform apps with Google, iOS, Android and Javascript SDKs.

all of client share one real time database instance and automatically receive update with new data.

Open Source Databases

Open source databases are available for MongoDB, Redis, MariaDB too.