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 automatically become master nodes.
This is accomplished via the Cloud SQL Proxy (all connections to Cloud SQL go through the proxy).
Can I backup my SQL Server more frequently than the default 4 hours - e.g. 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 Server) writes out to cloud storage every 10 minutes.
Need an experienced Cloud Networking or a Cloud Data Protection Expert? Anuj has successfully delivered over a dozen deployments on each of the public clouds (AWS/GCP/Azure) including several DevSecOps engagements. Set up a time with Anuj Varma.
