Google Professional Cloud Architect Exam - Topic 9 Question 19 Discussion

Actual exam question for Google's Professional Cloud Architect exam

Question #: 19
Topic #: 9

[All Professional Cloud Architect Questions]

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?

A1. 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. Create a mysqldump of the on-premises MySQL server.
4. Upload the dump to a Cloud Storage bucket.
5. Import the dump into Cloud SQL.
6. Modify the source code of the application to write queries to both databases and read from its local database.
7. Start the Compute Engine application.
8. Stop the on-premises application.

B1. Set up Cloud SQL proxy and MySQL proxy.
2. Create a mysqldump of the on-premises MySQL server.
3. Upload the dump to a Cloud Storage bucket.
4. Import the dump into Cloud SQL.
5. Stop the on-premises application.
6. Start the Compute Engine application.

C1. 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.

D1. Stop the on-premises application.
2. Create a mysqldump of the on-premises MySQL server.
3. Upload the dump to a Cloud Storage bucket.
4. Import the dump into Cloud SQL.
5. Start the application on Compute Engine.

Show Suggested Answer

Suggested Answer: C

External replica promotion migration In the migration strategy of external replica promotion, you create an external database replica and synchronize the existing data to that replica. This can happen with minimal downtime to the existing database. When you have a replica database, the two databases have different roles that are referred to in this document as primary and replica. After the data is synchronized, you promote the replica to be the primary in order to move the management layer with minimal impact to database uptime. In Cloud SQL, an easy way to accomplish the external replica promotion is to use the automated migration workflow. This process automates many of the steps that are needed for this type of migration.

https://cloud.google.com/architecture/migrating-mysql-to-cloudsql-concept

- The best option for migrating your MySQL database is to use an external replica promotion. In this strategy, you create a replica database and set your existing database as the primary. You wait until the two databases are in sync, and you then promote your MySQL replica database to be the primary. This process minimizes database downtime related to the database migration. - https://cloud.google.com/architecture/migrating-mysql-to-cloudsql-concept#external_replica_promotion_migration

by Winfred at May 07, 2022, 05:50 AM

Limited Time Offer

25%

5 months ago

I practiced a similar question last week, and I think I chose "listener" for that one, so I'll go with that now.

upvoted 0 times

...