Database / Google Spanner Database Interview questions
What is the difference between Spanner and Cloud SQL?
| Cloud Spanner | Cloud SQL |
| Horizontally scalable, distributed across zones/regions automatically. | Runs on a single managed instance (with read replicas), vertically scaled. |
| Strong external consistency via TrueTime and Paxos. | Standard MySQL/PostgreSQL/SQL Server consistency model. |
| Custom dialect (GoogleSQL) or PostgreSQL-compatible. | Real MySQL, PostgreSQL, or SQL Server engines. |
| Priced by node/processing unit capacity, not storage tiers alone. | Priced by instance size (vCPU/RAM) and storage. |
Cloud SQL is the right default for typical application databases that fit on one machine and need full engine compatibility, including extensions and stored procedures. Spanner is worth the added complexity when a single instance's write throughput or storage ceiling becomes the actual bottleneck, or when the application needs strong consistency across multiple regions rather than just read replicas.
Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!
Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.
Invest now!!! Get Free equity stock (US, UK only)!
Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.
The Robinhood app makes it easy to trade stocks, crypto and more.
Webull! Receive free stock by signing up using the link: Webull signup.
More Related questions...
