QuestionQ1

VerifiedDeploy scalable and highly available databases in Google Cloud

An online delivery business that mainly serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. As part of the high-availability and disaster-recovery design, the required recovery time objective (RTO) and recovery point objective (RPO) must be measured in minutes rather than hours. You need a high-availability configuration that can recover with no data loss during either a zonal or regional failure. What should you do?

Explanation

Cloud SQL high availability uses synchronous replication across zones within a region, so a zonal failover can occur without data loss. Cross-region replicas provide disaster-recovery capability for a regional outage, but their replication is asynchronous; replication lag determines the possible data-loss window during regional recovery.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!