Which migration approach minimizes downtime and on-premises performance impact when moving MySQL to the cloud?
Choose an answer
Tap an option to check your answer.
Correct 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..
Why this is the answer
Setting up a MySQL replica in the cloud and configuring asynchronous replication from your on-premises master minimizes downtime and performance impact. Data continuously syncs to the cloud replica while the on-premises master remains fully operational. At cutover, you simply switch application traffic to the cloud replica. Creating a dump requires significant downtime for the on-premises server during the dump, upload, and restore process. Writing to both on-premises and cloud masters introduces data consistency challenges and application complexity. Migrating to Cloud Datastore is a platform change, not a direct MySQL migration, and requires significant application re-architecture, making it unsuitable for minimizing downtime in a direct MySQL move.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed