You need to choose a database for a new project that has the following requirements:
✑ Fully managed
✑ Able to automatically scale up
✑ Transactionally consistent
✑ Able to scale up to 6 TB
✑ Able to be queried using SQL
Which database do you choose?
Cloud Spanner is a fully managed database that offers automatic scaling both vertically and horizontally, strong transactional consistency, and SQL querying capabilities. It supports databases up to multi-terabyte scale including the requirement of 6 TB. Therefore, it meets all the outlined requirements perfectly.
Correct: A It asks for scaling up which can be done in cloud sql, horizontal scaling is not possible in cloud sql Automatic storage increase If you enable this setting, Cloud SQL checks your available storage every 30 seconds. If the available storage falls below a threshold size, Cloud SQL automatically adds additional storage capacity. If the available storage repeatedly falls below the threshold size, Cloud SQL continues to add storage until it reaches the maximum of 30 TB.
C:- Cloud SQL is not fully managed as that is one of the requirement.
https://cloud.google.com/sql it is fully managed
Google documentation says "Cloud SQL is a fully-managed database service that helps you set up, maintain, manage, and administer your relational databases on Google Cloud Platform."
Have you really worked on GCP?
C - CloudSQL does not scale automatically.
Cloud SQL can automatically scale up storage capacity when you are near your limit
it does not say about type of scaling, Cloud SQL scale up automatically with storage, that should works
A. Cloud SQL There is no need of Spanner
Should be C.
May be A
Guys - this is 1000% C. ".....automatically scale up" Cloud SQL needs restart! this is not the solution. Only Spanner (and BQ) are true automatically scale up
What problem in restart? There are no any constraints about this, but there directly writes: "Fully managed"
I feel this is a 'fit-for-purpose' question, and TB's large Cloud-SQL is enough. The up-to-6TB is a sign for me to not go for Cloud-Spanner.
The requirements does not mention high-availability, and Cloud SQL is up to 64TB now https://cloud.google.com/sql/docs/quotas#storage_limits
Cloud SQL can also automatically scale up storage capacity when you are near your limit. https://cloud.google.com/sql/?utm_source=google&utm_medium=cpc&utm_campaign=japac-HK-all-en-dr-BKWS-all-super-trial-PHR-dr-1605216&utm_content=text-ad-none-none-DEV_c-CRE_652279903175-ADGP_Hybrid%20%7C%20BKWS%20-%20BRO%20%7C%20Txt%20~%20Databases_Cloud%20SQL_gcp%20horizontal%20sql_main-KWID_43700076522535474-kwd-2005739330106&userloc_2344-network_g&utm_term=KW_google%20sql%20horizontal&gclid=Cj0KCQjwqs6lBhCxARIsAG8YcDjWaS5NbG3remUHnHQ7EFK-wJNsF0I_IvePKHF0mHaiBK3_-eM7Z-UaAqQeEALw_wcB&gclsrc=aw.ds#section-2:~:text=Cloud%20SQL%20can%20also%20automatically%20scale%20up%20storage%20capacity%20when%20you%20are%20near%20your%20limit.
sahi A hai. Dekho mitra mujhe bhi pahale yahi laga cloud spanner hi hoga but read the question again. scaleup required till 6TB aur The requirements does not mention high-availability, and Cloud SQL is up to 64TB now https://cloud.google.com/sql/docs/quotas#storage_limits to phir jab kaam jara sa hai to spanner ko kyo laaye aur cloud sql bhi autoscaleup hota hai https://www.tutorialspoint.com/differences-between-google-cloud-sql-and-cloud-spanner#:~:text=Cloud%20Spanner%20is%20compatible%20with,and%20extra%2Dlarge%20database%20instances.&text=The%20price%20is%20comparatively%20less,of%20Cloud%20Spanner%20is%20high.
Able to automatically scale up = Memory and CPU Able to scale up to 6 TB = Disk Correct is C, because Cloud SQL no scale Memory and CPU.
Fully Managed: Cloud Spanner is a fully managed database service provided by Google Cloud, which means you don't have to worry about managing infrastructure, updates, or backups. Automatic Scaling: Cloud Spanner can automatically scale both horizontally and vertically to handle increased workloads and data volume. It can handle databases ranging from a few gigabytes to multi-terabyte scale. Transactionally Consistent: Cloud Spanner offers strong transactional consistency, making it suitable for applications that require ACID compliance. SQL Querying: You can query Cloud Spanner databases using SQL, which is a familiar query language for many developers and analysts. Given your requirements, Cloud Spanner is designed to meet the need for a fully managed, scalable, transactionally consistent, and SQL-accessible database solution.
C: Cloud Spanner Why not A: Cloud SQL? No "automatically" scale up feature
A seems to be correct because of the scaling factor of 6 TB because cloud sql easily supports up to 40 TB and obviously there is a limitation of GLOBALLY MULTI REGIONAL which is nothing to do with question. Hence A seems more closer.
Spanner is consistent and fully-managed https://cloud.google.com/spanner/docs/transactions?hl=en
"Able to scale up to 6 TB" -seems to be the key it looks like autoscaling is related to storage - possible in case of Cloud SQL
no way , u can automaticly scale the Cloud SQL , please read the documents of Cloud SQL, Spanner is the solution .
i will go with A, since the question doesnt specifically say it should be scaling horizontally
Not horizontal scaling is required, cloud SQL will work for 10 TB
Answer : A Cloud SQL and Cloud Spanner are the options for the questions. But here as per requirement they don't need horizontal scaling, they want manager SQL instance and it should support 6 TB of storage. Cloud SQL can support up to 64 TB of storage https://cloud.google.com/sql/docs/quotas#:~:text=Cloud%20SQL%20storage%20limits,core%3A%20Up%20to%203%20TB.
Transactional consistency: spanner provides strong consistency across rows, regions, and continents.