Answer-first summary for fast verification
Answer: Setup a MySQL replica server/slave in the cloud environment, and configure it for asynchronous replication from the MySQL master server on-premises until cutover.
The best approach to migrate Dress4Win's on-premises MySQL deployment to the cloud while minimizing downtime and performance impact is to set up a MySQL replica server/slave in the cloud environment and configure it for asynchronous replication from the MySQL master server on-premises until cutover. This method ensures that the data is consistently replicated to the cloud with minimal disruption to the live environment. Option A would cause downtime since it involves shutting down the master server. Option C could lead to data inconsistencies and the need for complex configuration. Option D is not suitable as Google Cloud Datastore is a NoSQL database and not directly compatible with MySQL.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Dress4Win, a web-based company that helps users organize their personal wardrobe, is planning to migrate their on-premises MySQL deployment to the cloud to handle rapid growth and infrastructure capacity issues. They aim to minimize downtime and performance impact during the migration. Which approach should you recommend?
A
Create a dump of the on-premises MySQL master server, and then shut it down, upload it to the cloud environment, and load into a new MySQL cluster.
B
Setup a MySQL replica server/slave in the cloud environment, and configure it for asynchronous replication from the MySQL master server on-premises until cutover.
C
Create a new MySQL cluster in the cloud, configure applications to begin writing to both on-premises and cloud MySQL masters, and destroy the original cluster at cutover.
D
Create a dump of the MySQL replica server into the cloud environment, load it into Google Cloud Datastore, and configure applications to read/write to Cloud Datastore at cutover.