Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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 are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?

Show Suggested Answer Hide 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
Benedict
3 days ago
I was thinking along the lines of Option D, but using the mysqldump utility and binary logs might be a bit too manual for my needs.
upvoted 0 times
...
Tiera
7 days ago
Option C seems like the way to go. Cloud SQL for MySQL external replica sounds like the perfect solution for my hybrid setup.
upvoted 0 times
...
Crista
9 days ago
I prefer using the mysqldump utility and binary logs for creating replicas.
upvoted 0 times
...
Crista
11 days ago
I agree with Julene, Cloud SQL for MySQL external replica is the best option for scaling reads.
upvoted 0 times
...
Julene
15 days ago
I think we should use Cloud SQL for MySQL external replica.
upvoted 0 times
...

Save Cancel