Google Professional Cloud Database Engineer Question 217
Select 3Google Cloud PlatformYour organization has migrated a MySQL database to Google Cloud SQL for MySQL. To maintain business continuity, you are tasked with setting up reverse replication from Cloud SQL to an on-premises MySQL database. Which of the following steps are required to correctly configure reverse replication?
- A
Enable binary logging on the Cloud SQL for MySQL instance.
- B
Ensure the on-premises MySQL database is configured as a read replica.
- C
Create and configure a replication user on the Cloud SQL instance with appropriate privileges.
- D
Export the Cloud SQL instance data to a Cloud Storage bucket and import it to the on-premises MySQL database.
- E
Configure the on-premises MySQL server to connect to the Cloud SQL instance using the external IP and replication credentials.
- F
Set up a private network connection between the on-premises network and Google Cloud.
Show answer and explanation
Correct answers: A, C, E
Explanation
To set up reverse replication from a Cloud SQL for MySQL instance to an on-premises MySQL database, binary logging must be enabled on the Cloud SQL instance to allow changes to be captured for replication. A replication user with appropriate privileges must be configured on the Cloud SQL instance to allow the on-premises MySQL server to pull changes. Additionally, the on-premises MySQL server needs to connect to the Cloud SQL instance using its external IP address and the replication credentials. While other options may involve related tasks, they are not required for configuring reverse replication.
- A. Correct.
Correct. Binary logging must be enabled on Cloud SQL for MySQL to allow replication, as it is a prerequisite for the replication process.
- B. Incorrect.
Incorrect. The on-premises MySQL database should act as the primary or a standalone instance, not as a read replica, since it will be pulling data from Cloud SQL.
- C. Correct.
Correct. A dedicated replication user with the necessary privileges (e.g., REPLICATION SLAVE) must be created on the Cloud SQL instance to allow the on-premises database to replicate data.
- D. Incorrect.
Incorrect. Data export and import are not required for setting up reverse replication; replication handles data synchronization after the initial setup.
- E. Correct.
Correct. The on-premises MySQL must connect to the Cloud SQL instance using its external IP and the replication credentials to establish the replication link.
- F. Incorrect.
Incorrect. While a private network connection can enhance security, it is not a mandatory step for enabling reverse replication. The process can work over an external IP with proper security configurations.