GCP Services - vidyasekaran/GCP GitHub Wiki

Cloud SQL

  1. Fully managed PAAS
  2. Supports Mysql, Postgres, SQL Server
  3. Secure DB using SSL/TLS protocol or use Cloud Proxy
  4. Import / Export backups
  5. Replication & High Availablity

https://youtu.be/3zPi1AyNfYk

Features CloudSQL for MySQL CloudSQL For Postgres CloudSQL for SQLServer

Version 5.6, 5.7 9.6,10,11,12 2017

Storage supports upto 30TB upto 30TB 30TB

Import/Export mysqldump or csv file sql dump file native bak and sql file Using

Connect using mysql client, psql client SQLServer Mgmt studio sql workbench or toad 3rd party tools like A client for mysql std postgresql sqlcmd utility External apps etc client-server protocol, external app etc external app etc

Architecture : CloudSQL with read replicas

Have a read replica in same zone as Master DB or in another Region (cross region replication) for good performance of replication better to have read replicas in same region but different zone.

High Availablity arch

Have a read replica along with primary instance of cloud sql. once u enable HA data is persisted to a regional disk and it is writtern to other persistent disk in other zones. the same data is writtern to a standby instance cloud sql also. when master fails the DB connectivity is switched to standby cloud sql instance and to switch connectivity back to master we need to manually initiate another failover, in this case perform a failback.

NOTE: You can create a read replica from master database screen and you have option to failover in master db screen.

*** CloudRun *** https://cloud.google.com/blog/topics/developers-practitioners/cloud-run-story-serverless-containers

CloudRun can be invoked via HTTPS, gRPC, WebSockets, Trigger from Pub/Sub, Running services on a schedule: You can use Cloud Scheduler to securely trigger a Cloud Run service on a schedule.