Database (relational and non-relational databases) Flashcards
AlloyDB
Scalable & performant PostgreSQL-compatible DB
Cloud Bigtable
Petabyte-scale, low-latency, non-relational
Cloud Firestore
Serverless NoSQL document DB
Cloud Memorystore
Managed Redis and Memcached
Cloud SQL
Managed MySQL, PostgreSQL, SQL Server
Cloud SQL Insights
SQL Inspector
Cloud Spanner
Horizontally scaleable relational database
Database Migration Service
Migrate to Cloud SQL
Transactional Consistency
When a transaction completes, all operations must be successful or all are rolled back
Eventual Consistency
After data is updated, the system guarantees that all copies of the data in a distributed system will “eventually” be the same
Strong Consistency
All nodes in a distributed system that have received the same update will be in the same state once the transaction completes
DB use case: Web frameworks, ERP (Enterprise Resource Planning), CRM (Customer Relationship Management), Ecommerce and Web, SaaS Application
Cloud SQL
DB use case: Gaming, Global financial ledger, supply chain/inventory management
Cloud Spanner
DB use case: Legacy applications, Data center retirement
Bare Metal
DB use case: Mobile/web/IoT apps, real-time sync, offline sync, personalized apps
Firestore
