Please enable JavaScript.
Coggle requires JavaScript to display documents.
GCP_databases, Relational DB, NoSQL - Coggle Diagram
GCP_databases
-
-
Consistency
eventual consistency (scalability is more important than data integrity). like twitter post or FB post
Read after Write - inserts are immediately available, but updates take some time (updates with eventual consistency)
strong consistency. add latency, case - 1 million dollars transactions
-
problem statement - how to undersntad, that all replicas are consistent
-
-
Relational DB
Cloud SQL
-
-
-
it is a REGIONAL service, no global options
-
-
-
features
-
-
read replica is available, can be created in another region, zone or even non-cloud. Automatic back up and binary log should be enabled
there is a Database migration service, also can be done with SQL if we get source from other database
-
-
-
Best practise
-
-
Cloud SQL proxy - connect from application(GAE, CLOUD FUNTUIN, CLOUD RUN, GKE) in secure way
-
-
-
Bare metal
Deploy Oracle capabilities like clustered databases, replication, and all performance features
Leverage your on-premises licensing, run books, database administrators, and system integrators
-
NoSQL
-
BigTable
properties
-
-
Not serves, need disk HDD or SDD
Use cat, gcloud doesn't work
-
-
automatically shards data, but need to design how many nodes we need
-
Design BQ
-
-
need to test after design, MM of records with 30 GB + test dump
use cases
-
-
Petabyte scale NOSQL, designed for huge volume of data
iot, huge read/write, time series
-