Cloud SQL Features
- Automatic backups and patch management
- High Availability with automatic failover (Multizone databases)
- Vertical scaling with ability to add more CPU and RAM without downtime
- Horizontal read scaling with read replicas
- Integration with GKE and compute engine
- IAM authentication and network security through vpc
- Built in monitoring for observability
- note: Watch classroom video for creation steps
Cloud Spanner
- Cloud Spanner is a scalable, globally distributed relational database service that offers HA, strong consitency and horizontal scalability.
- It combines the benifits fo traditional relation database with the scalability of NO SQL Databases
- Features:
- Horizontally scalable with automatic sharding
- Strong consistency across regions
- Global transactional consistency using Google’s true time API
- SQL Based Querires
- Automatic replication across multiple regions for HA
- support schemas, ACID transactions & foriegn keys
- Usecases:
- Large scale applications requiring global consistency such as financial system, supply chain management
- High transactional applications that require strong consistency at scale.
- Refer Here for sql syntaxes
AlloyDB
- This is Google clouds new managed database service combining the best of open source postgresql with Google cloud’s advanced infrastructure. It offers low latency reads and high throughput writes and integration with Big Query
- Use cases:
- Hybrid transactional & analytical processing (HTAP)
- Application requiring the flexibilty of PostgreSQL with the performance of cloud native system.
- FeaturesL:
- High Performance PostgreSQL compatible
- Built in AL and ML capabilities with tight integrations with Google cloud services
- Horizontally scalable with low latency replication
- Designed for transactional and analytical workloads
- Serverless scaling and automating tuning of high availability
NOSQL Database
Firestore (Firebase Database)
- This is NOSQL, document based database designed for mobile, web and server applications
- It is part of Firebase and integrates seamlessly with google cloud services
- Key Features:
- Real-time synchronization of data across clients
- Horizontal scaling with automatic sharding
- Flexible, schema-less data model using collections and documents
- Supports ACID transactions at document level
- Integration with Firebase services like authentication & analytics
- Usecases:
- Mobile and web applications requiring real-time data sync
- Applications with unstructured or semi structure data
- Applications that benefit from schema flexbility
Cloud BigTable
- This is also fully managed NOSQL database, designed for large scale, low latency workloads
- Usecases:
- IoT Data storage, where time-series data requires fast read and write access
- Large scale analytical workloads like recomendation engines etc
- Financial and trading systems with high throughput demands
- Features:
- Horizontally scalable to handle petabytes of data
- Low latency access to data
- Suitable for both wide column data (HBase) and time-series data
- Fully integrated with GCP services like BigQuery & Data flow for real time processing.
