tech/google/cloud/database

What problem does it solve?

This Skill streamlines the management of various GCP databases, including Cloud SQL, AlloyDB, Spanner, Firestore, Bigtable, and Memorystore, simplifying the process of setting up and maintaining these services.

Core Features & Use Cases

• Cloud SQL Management: Set up and manage managed databases like Postgres, MySQL, and SQL Server on Cloud SQL.
• AlloyDB and Spanner: Deploy and manage high-performance databases for OLTP and globally-distributed SQL.
• Firestore: Utilize Firestore for serverless document storage, suitable for mobile and web clients.
• Bigtable: Store and process vast amounts of wide-column data at petabyte scale.
• Memorystore: Implement in-memory caching with Redis, Memcached, and Valkey for improved performance.
• Use Case: For a company looking to deploy a scalable database solution with high availability and performance, this Skill provides the necessary tools and guidance to set up and manage Cloud SQL, Spanner, and Firestore services.

Quick Start

Set up a Cloud SQL instance for PostgreSQL on GCP with the following command:

gcloud sql instances create my-pg \
  --database-version POSTGRES_16 \
  --region africa-south1 \
  --tier db-custom-2-7680 \
  --storage-type SSD --storage-size 20 --storage-auto-increase \
  --availability-type ZONAL \
  --backup --enable-point-in-time-recovery