GoogleGoogle Professional Cloud Architect (PCA) Certification Exam·EN·Updated 14 Jul 2026
You are moving an application that uses MySQL from on-premises to Google Cloud. The application will run on Compute Engine and will use Cloud SQL. You want to cut over to the Compute Engine deployment of the application with minimal downtime and no data loss to your customers. You want to migrate the application with minimal modification. You also need to determine the cutover strategy. What should you do?
Choose an answer
Tap an option to check your answer.
Correct answer: Set up Cloud VPN to provide private network connectivity between the Compute Engine application and the on-premises MySQL server. 2. Stop the on-premises application. 3. Start the Compute Engine application, configured to read and write to the on-premises MySQL server. 4. Create the replication configuration in Cloud SQL. 5. Configure the source database server to accept connections from the Cloud SQL replica. 6. Finalize the Cloud SQL replica configuration. 7. When replication has been completed, stop the Compute Engine application. 8. Promote the Cloud SQL replica to a standalone instance. 9. Restart the Compute Engine application, configured to read and write to the Cloud SQL standalone instance..
Why this is the answer
The correct option describes a minimal downtime migration strategy using Cloud SQL external replication. By initially pointing the Compute Engine application to the on-premises database via Cloud VPN, the application can continue serving requests while Cloud SQL replicates the data. Once replication is complete, promoting the Cloud SQL replica and reconfiguring the application to use it allows for a quick cutover with minimal downtime and no data loss.
The other options involve stopping the application for an extended period to perform a mysqldump and import, which results in significant downtime and does not meet the "minimal downtime" requirement. The option with Cloud SQL proxy and MySQL proxy is also incorrect because it doesn't address the continuous data synchronization needed for minimal downtime during migration.