Your company runs a business-critical MySQL database on a single-region Cloud SQL instance in us-central1. Users in Europe complain that read-only queries against reporting dashboards are slow, but all write traffic must continue to be handled in the United States. Management also wants a disaster-recovery option in case the us-central1 region becomes unavailable. Which solution meets the requirements with the least operational effort?
Create a cross-region Cloud SQL read replica of the existing instance in europe-west1, direct European read traffic to the replica, and document a runbook to manually promote the replica if the primary region fails.
Add a Cloud SQL failover replica in europe-west1 and route European read traffic to it while keeping writes on the primary.
Migrate the workload to Cloud Spanner in a multi-region configuration to achieve global reads and disaster recovery.
Enable Cloud SQL's automatic read/write splitting feature so reads are transparently routed to the nearest region.
A cross-region read replica hosted in europe-west1 reduces network latency for European users because reads can be directed to the replica's private IP or read-only connection string. Cloud SQL read replicas are fully managed; they stay in sync asynchronously and can be promoted to an independent primary instance if the original region suffers an outage, providing a manual disaster-recovery path. Cloud SQL failover replicas support automatic failover but are confined to the same region and are not readable, so they cannot serve low-latency reads. Cloud SQL does not offer an automatic read/write splitting feature. Migrating to Cloud Spanner would address latency and DR but requires a complete platform change and greater operational work than adding a managed replica.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a Cloud SQL read replica?
Open an interactive chat with Bash
How does asynchronous replication work in Cloud SQL?
Open an interactive chat with Bash
Why is Cloud Spanner not a suitable choice for this scenario?
Open an interactive chat with Bash
What is a cross-region read replica in Cloud SQL?
Open an interactive chat with Bash
How does asynchronous replication work in Cloud SQL?
Open an interactive chat with Bash
Why is Cloud SQL failover replica not suitable for low-latency reads?
Open an interactive chat with Bash
GCP Associate Cloud Engineer
Planning and implementing a cloud solution
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .