Archives for Cloud SQL
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 not support…
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. - seems to be a fairly…
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 instances after…
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 run commands…
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 ( .bak file in SQL Server) writes…
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 designed to…
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 -O cloud_sql_proxy && chmod +x cloud_sql_proxyConnection String…