Migrating from Cloud SQL to Cloud Spanner
Here are some considerations when planning a trial or actual migration from Cloud SQL To Cloud Spanner on GCP. Design Spanner Schema Adapt Schema for Spanner: Spanner does…
Archive
Category: Cloud SQL
Cloud SQL and Editor roles
All I want to do is connect to a Cloud SQL Instance You have two pre-defined roles that you can use for this purpose. roles/cloudsql.editor – seems to…
Cloud SQL Private and Public IP – GCP
Connections to Cloud SQL Authentication (local or domain joined) Public IP Connectivity to Cloud SQL For extra security, consider using the Cloud SQL proxy to connect to your…
SSMS access to CLoud SQL on GCP
While there is no native GUI for CLoud SQL, you CAN use your own SSMS to connect (using an appropriate connection string). And you should be able to…
Cloud SQL Backups and Restore
Can you backup every 10 minutes (your maximum tolerable data loss)? Yes, up to 10 minutes of data loss, as the db backups (e.g. .bak file in SQL…
Read Replica versus Failover Replica in Cloud SQL
How do I create a failover replica? Read Replicas CAN be promoted to master nodes in the case of DR. However, there is downtime entailed. Failover Replicas are…
Cloud SQL Proxy to Connect to Cloud SQL
Create a VM to serve as your proxy instance. SSH onto the instance Download the Cloud SQL Proxy and make it executable: wget https://dl.google.com/cloudsql/cloud_sql_proxy.linux.amd64 -O cloud_sql_proxy && chmod…