Migrating Critical Applications to the Cloud - Choosing the Right Google Database

Migrating Critical Applications to the Cloud - Choosing the Right Google Database

Question

JencoMart is a global retailer with over 10,000 stores in 16 countries.

The stores carry a range of goods, such as groceries, tires, and jewelry.

One of the company's core values is excellent customer service.

In addition, they recently introduced an environmental policy to reduce their carbon output by 50% over the next 5 years.

Company Background - JencoMart started as a general store in 1931, and has grown into one of the world's leading brands, known for great value and customer service.

Over time, the company transitioned from only physical stores to a stores and online hybrid model, with 25% of sales online.

Currently, JencoMart has little presence in Asia, but considers that market key for future growth.

Solution Concept - JencoMart wants to migrate several critical applications to the cloud but has not completed a technical review to determine their suitability for the cloud and the engineering required for migration.

They currently host all of these applications on infrastructure that is at its end of life and is no longer supported.

Existing Technical Environment - JencoMart hosts all of its applications in 4 data centers: 3 in North American and 1 in Europe; most applications are dual-homed.

JencoMart understands the dependencies and resource usage metrics of their on-premises architecture.

Application: Customer loyalty portal LAMP (Linux, Apache, MySQL and PHP) application served from the two JencoMart-owned U.S.

data centers.

Database -Oracle Database stores user profiles - 20 TB - Complex table structure - Well maintained, clean data - Strong backup strategyPostgreSQL database stores user credentials - Single-homed in US West - No redundancy - Backed up every 12 hours - 100% uptime service level agreement (SLA) - Authenticates all users Compute -30 machines in US West Coast, each machine has: - Twin, dual core CPUs - 32 GB of RAM - Twin 250 GB HDD (RAID 1)20 machines in US East Coast, each machine has: - Single, dual-core CPU - 24 GB of RAM - Twin 250 GB HDD (RAID 1) Storage -Access to shared 100 TB SAN in each locationTape backup every week Business Requirements -Optimize for capacity during peak periods and value during off-peak periodsGuarantee service availability and supportReduce on-premises footprint and associated financial and environmental impactMove to outsourcing model to avoid large upfront costs associated with infrastructure purchaseExpand services into Asia Technical Requirements -Assess key application for cloud suitabilityModify applications for the cloudMove applications to a new infrastructureLeverage managed services wherever feasibleSunset 20% of capacity in existing data centersDecrease latency in Asia CEO Statement - JencoMart will continue to develop personal relationships with our customers as more people access the web.

The future of our retail business is in the global market and the connection between online and in-store experiences.

As a large, global company, we also have a responsibility to the environment through green initiatives and policies.

CTO Statement - The challenges of operating data centers prevent focus on key technologies critical to our long-term success.

Migrating our data services to a public cloud infrastructure will allow us to focus on big data and machine learning to improve our service to customers.

CFO Statement - Which Google Database should they use?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

D.

Common workloads for Google Cloud Datastore: -> User profiles -> Product catalogs -> Game state Reference: https://cloud.google.com/storage-options/ https://cloud.google.com/datastore/docs/concepts/overview.

Based on the provided information, JencoMart is a global retailer with over 10,000 stores in 16 countries. The company has a hybrid model with 25% of sales online, and currently, JencoMart has little presence in Asia, but considers that market key for future growth. JencoMart wants to migrate several critical applications to the cloud but has not completed a technical review to determine their suitability for the cloud and the engineering required for migration. JencoMart hosts all of its applications in 4 data centers: 3 in North American and 1 in Europe, and most applications are dual-homed.

The application to be migrated is a customer loyalty portal LAMP (Linux, Apache, MySQL, and PHP) application served from the two JencoMart-owned U.S. data centers. The Oracle database stores user profiles of 20 TB, which has a complex table structure, well-maintained, clean data, and a strong backup strategy. The PostgreSQL database stores user credentials, is single-homed in US West, has no redundancy, backed up every 12 hours, and has a 100% uptime service level agreement (SLA) that authenticates all users.

The compute consists of 30 machines in US West Coast, each with twin dual-core CPUs, 32 GB of RAM, and twin 250 GB HDD (RAID 1) and 20 machines in US East Coast, each with a single dual-core CPU, 24 GB of RAM, and twin 250 GB HDD (RAID 1). Access to shared 100 TB SAN in each location with tape backup every week is provided.

The business requirements are to optimize for capacity during peak periods and value during off-peak periods, guarantee service availability and support, reduce on-premises footprint and associated financial and environmental impact, move to an outsourcing model to avoid large upfront costs associated with infrastructure purchase, and expand services into Asia. The technical requirements are to assess key application for cloud suitability, modify applications for the cloud, move applications to a new infrastructure, leverage managed services wherever feasible, sunset 20% of capacity in existing data centers, and decrease latency in Asia.

The CEO statement mentions JencoMart will continue to develop personal relationships with their customers as more people access the web. The future of their retail business is in the global market and the connection between online and in-store experiences. As a large, global company, they also have a responsibility to the environment through green initiatives and policies.

The CTO statement mentions the challenges of operating data centers prevent focus on key technologies critical to their long-term success. Migrating their data services to a public cloud infrastructure will allow them to focus on big data and machine learning to improve their service to customers. The CFO statement asks which Google Database they should use.

Based on the given requirements, the suitable Google Database for JencoMart is Google Cloud SQL. Google Cloud SQL is a fully-managed database service that makes it easy to set up, maintain, manage, and administer relational MySQL and PostgreSQL databases in the cloud. It provides automatic replication, scaling, backups, and recovery. JencoMart can use Google Cloud SQL to migrate their Oracle and PostgreSQL databases to the cloud and leverage its managed services.

Cloud SQL can provide high availability with automatic failover and replication. It can also scale up or down based on usage and support multi-region deployments to decrease latency in Asia. With Google Cloud SQL, JencoMart can reduce their on-premises footprint and associated financial and environmental impact, move to an outsourcing model, and optimize for capacity during peak periods and value during off-peak periods.

In conclusion, Google Cloud SQL is the most suitable option for JencoMart based on the given requirements.