You are migrating an on-premises MySQL 5.7 database used by a legacy PHP application running on Compute Engine. The team wants Google to handle backups, minor version patching, and automatic failover inside a region. In addition, the business continuity plan requires that if the entire region fails, the database can be promoted in a different region with an RPO under one hour. Which Google Cloud deployment best meets these requirements while requiring the least application change?
Create a multi-region Cloud Spanner instance to store the application data.
Migrate the data to Cloud Bigtable with multi-cluster routing enabled across two regions.
Create a Cloud SQL for MySQL instance with high-availability enabled and add a cross-region read replica that can be promoted during a regional outage.
Provision a single-zone Cloud SQL for PostgreSQL instance with automated backups.
Cloud SQL is a fully managed relational service that automates backups, patching, and minor-version updates. Enabling the high-availability (regional) configuration creates a primary and standby instance in separate zones and provides automatic failover inside the region. Adding a cross-region read replica keeps an asynchronously replicated copy in another region; if the primary region becomes unavailable the replica can be promoted, typically with replication lag well under the one-hour RPO target. Spanner would meet the availability goal but requires schema changes and higher operational costs. Bigtable is a wide-column NoSQL store and cannot serve MySQL workloads. A single-zone Cloud SQL PostgreSQL instance lacks regional failover and cross-region replication, so it does not satisfy the DR objective.
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 Cloud SQL and how does it manage backups and failover?
Open an interactive chat with Bash
How does cross-region read replication work in Cloud SQL?
Open an interactive chat with Bash
Why is Cloud Spanner not suitable for this scenario?
Open an interactive chat with Bash
What is Cloud SQL for MySQL?
Open an interactive chat with Bash
How does Cloud SQL handle high availability and failover?
Open an interactive chat with Bash
Why isn't Cloud Spanner or Cloud Bigtable suitable for this use case?
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
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .