QuestionQ96

VerifiedDesign scalable and highly available cloud database solutions

You are developing a new centralized inventory-management system to track items available in 200 stores, each of which has 500 GB of data. You plan to roll out the system gradually to a few stores each week.

You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down during nights and holidays. What should you do?

Explanation

Cloud Spanner is a distributed relational database that supports SQL queries and transactions while scaling out horizontally. Its autoscaling capability can increase compute capacity for higher workload or storage demand and reduce it during off-peak periods to lower cost. A custom Spanner autoscaling solution can set the appropriate capacity limits and scaling thresholds for phased regional onboarding without application-managed sharding.

Learn more

Community Discussion

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