nerdexam
Google

PROFESSIONAL-CLOUD-DEVELOPER · Question #97

Case Study 1 - HipLocal Company Overview HipLocal is a community application designed to facilitate communication between people in close proximity. It is used for event planning and organizing sporti

The correct answer is D. Replace the MySQL instance with Cloud SQL.. Replacing the self-managed MySQL instance with Cloud SQL for MySQL provides a fully managed, Google-operated database service that is API-compatible with MySQL. This means minimal or no application code changes are required, while gaining automated backups, replication, failover,

Designing scalable and highly available data storage solutions

Question

Case Study 1 - HipLocal Company Overview HipLocal is a community application designed to facilitate communication between people in close proximity. It is used for event planning and organizing sporting events, and for businesses to connect with their local communities. HipLocal launched recently in a few neighborhoods in Dallas and is rapidly growing into a global phenomenon. Its unique style of hyper-local community communication and business outreach is in demand around the world. Executive Statement We are the number one local community app; it's time to take our local community services global. Our venture capital investors want to see rapid growth and the same great experience for new local and virtual communities that come online, whether their members are 10 or 10000 miles away from each other. Solution Concept HipLocal wants to expand their existing service, with updated functionality, in new regions to better serve their global customers. They want to hire and train a new team to support these regions in their time zones. They will need to ensure that the application scales smoothly and provides clear uptime data. Existing Technical Environment HipLocal's environment is a mix of on-premises hardware and infrastructure running in Google Cloud Platform. The HipLocal team understands their application well, but has limited experience in global scale applications. Their existing technical environment is as follows:

  • Existing APIs run on Compute Engine virtual machine instances hosted in GCP.
  • State is stored in a single instance MySQL database in GCP.
  • Data is exported to an on-premises Teradata/Vertica data warehouse.
  • Data analytics is performed in an on-premises Hadoop environment.
  • The application has no logging.
  • There are basic indicators of uptime; alerts are frequently fired when the APIs are unresponsive.

Business Requirements HipLocal's investors want to expand their footprint and support the increase in demand they are seeing. Their requirements are:

  • Expand availability of the application to new regions.
  • Increase the number of concurrent users that can be supported.
  • Ensure a consistent experience for users when they travel to different regions.
  • Obtain user activity metrics to better understand how to monetize their product.
  • Ensure compliance with regulations in the new regions (for example, GDPR).
  • Reduce infrastructure management time and cost.
  • Adopt the Google-recommended practices for cloud computing.

Technical Requirements

  • The application and backend must provide usage metrics and monitoring.
  • APIs require strong authentication and authorization.
  • Logging must be increased, and data should be stored in a cloud analytics platform.
  • Move to serverless architecture to facilitate elastic scaling.
  • Provide authorized access to internal apps in a secure manner.

In order to meet their business requirements, how should HipLocal store their application state?

Options

  • AUse local SSDs to store state.
  • BPut a memcache layer in front of MySQL.
  • CMove the state storage to Cloud Spanner.
  • DReplace the MySQL instance with Cloud SQL.

How the community answered

(29 responses)
  • A
    10% (3)
  • B
    3% (1)
  • C
    3% (1)
  • D
    83% (24)

Explanation

Replacing the self-managed MySQL instance with Cloud SQL for MySQL provides a fully managed, Google-operated database service that is API-compatible with MySQL. This means minimal or no application code changes are required, while gaining automated backups, replication, failover, and reduced operational overhead - addressing reliability and scale concerns for HipLocal's growth. Option A (local SSDs) stores state on ephemeral instance storage, which is not suitable for a shared database. Option B (Memcache in front of MySQL) adds a caching layer but doesn't address the core database manageability problem. Option C (Cloud Spanner) offers global consistency but requires significant schema and application code rewrites, making it a much larger migration.

Topics

#Database Services#Scalability#Managed Services#Global Architecture

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DEVELOPER Practice