Google Exam Professional-Cloud-Database-Engineer Topic 13 Question 27 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 27
Topic #: 13

[All Professional Cloud Database Engineer Questions]

You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

APerform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

BCreate a read replica on Cloud SQL, and then promote it to a read/write standalone instance.

CUse Database Migration Service to migrate your database.

DCreate a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

Show Suggested Answer

Suggested Answer: D

PgBouncer maintains a pool for connections for each database and user combination. PgBouncer either creates a new database connection for a client or reuses an existing connection for the same user and database. + PgBouncer is a simple PostgreSQL connection pool that allows for several thousand connections at a time. Using Kubernetes Engine to run a Helm Chart w/ PgBouncer based on the great article from futuretech-industries, we were able to set up an easily deployable system to get the most out of our CloudSQL DBs without breaking the bank. https://medium.com/google-cloud/increasing-cloud-sql-postgresql-max-connections-w-pgbouncer-kubernetes-engine-49b0b2894820#:~:text=That%20is%20where,breaking%20the%20bank.

by Lemuel at Mar 07, 2024, 01:15 AM

Limited Time Offer

25%

Off

Get Premium Professional-Cloud-Database-Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Annelle

7 days ago

Ooh, good point. Maybe we should just hire a skywriter to announce the migration. That would really minimize the downtime, don't you think?

upvoted 0 times

...

Loise

8 days ago

What about the hot standby on Compute Engine? That's an interesting option. I wonder how it compares to the Database Migration Service in terms of complexity and reliability.

upvoted 0 times

...

Micah

10 days ago

Haha, true, but then we'd have to manage the whole process ourselves. Not exactly the 'minimum downtime' part of the requirement, am I right?

upvoted 0 times

...

Celestina

10 days ago

This is a tricky question. I'm not sure if I should go with the full backup and incremental approach or the Database Migration Service. Both seem to have their pros and cons.

upvoted 0 times

...