Your existing application keeps user state information in a single MySQL database.
This state information is very user-specific and depends heavily on how long a user has been using an application.
The MySQL database is causing challenges to maintain and enhance the schema for various users.
Which storage option should you choose?
Click on the arrows to vote for the correct answer
A. B. C. D.A.
https://cloud.google.com/solutions/migrating-mysql-to-cloudsql-conceptBased on the given scenario, Cloud Spanner seems to be the most suitable storage option for maintaining user state information. Here's why:
A. Cloud SQL: Cloud SQL is a managed relational database service that is compatible with MySQL, PostgreSQL, and SQL Server. It provides features like automatic backups, replication, and scaling, which makes it easy to manage and maintain a database. However, in the given scenario, the MySQL database is causing challenges to maintain and enhance the schema for various users. This implies that the schema needs to be updated frequently to accommodate user-specific state information. Cloud SQL may not be the best option for this, as it is optimized for traditional relational data and may not be able to handle frequent schema changes without downtime.
B. Cloud Storage: Cloud Storage is a scalable object storage service that allows you to store and retrieve data in the cloud. It is designed for unstructured data like images, videos, and log files and may not be the best option for storing user state information, which is highly structured and relational.
C. Cloud Spanner: Cloud Spanner is a globally distributed relational database service that is designed to scale horizontally without sacrificing strong consistency. It provides the benefits of a traditional relational database, such as ACID transactions, SQL queries, and strong schema enforcement, while also providing the scalability and availability of a NoSQL database. This makes it a good fit for storing user state information that is highly structured and relational but also needs to scale and be highly available.
D. Cloud Datastore/Firestore: Cloud Datastore and Firestore are NoSQL document databases that are optimized for scalability and performance. They are designed to handle unstructured and semi-structured data and may not be the best option for storing highly structured user state information.
Therefore, based on the given scenario, Cloud Spanner seems to be the most suitable storage option for maintaining user state information.