CLOUD-DIGITAL-LEADER · Question #44
Your ed-tech start-up was originally launched in a small geography. Any user sign-ups, course progress, tests taken, etc. are captured on a self-managed MySQL database. Every user generates many…
The correct answer is B. Migrate to Cloud Spanner. Cloud Spanner is Google Cloud's globally distributed, horizontally scalable, fully managed relational database service. It supports standard SQL and ACID transactions, making it a natural migration target from MySQL when global scale and high transaction throughput are…
Question
Your ed-tech start-up was originally launched in a small geography. Any user sign-ups, course progress, tests taken, etc. are captured on a self-managed MySQL database. Every user generates many such transactions. Now you're taking the application globally and preparing for a much larger influx of users from all over the world. The existing MySQL server is unlikely to be able to scale. Which convenient option can be considered?
Options
- AMigrate to BigQuery
- BMigrate to Cloud Spanner
- CMigrate to Cloud SQL
- DMigrate to Bigtable
How the community answered
(27 responses)- A4% (1)
- B85% (23)
- C4% (1)
- D7% (2)
Explanation
Cloud Spanner is Google Cloud's globally distributed, horizontally scalable, fully managed relational database service. It supports standard SQL and ACID transactions, making it a natural migration target from MySQL when global scale and high transaction throughput are required. Cloud SQL is a managed MySQL/PostgreSQL service but does not offer the same horizontal global scalability. BigQuery is an OLAP analytics warehouse, not suited for high-volume transactional workloads. Bigtable is a NoSQL wide-column store - it scales massively but does not support relational SQL queries or complex transactions. Cloud Spanner bridges the gap: relational semantics at planetary scale.
Topics
Community Discussion
No community discussion yet for this question.