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
Teddy
2 months ago
Forget the exam, I'm just here for the free donuts. Oh, wait, this is a virtual test? Nevermind, I'll just go with C then.
upvoted 0 times
Tonette
28 days ago
Don't worry about the exam, just focus on the free donuts!
upvoted 0 times
...
Kina
1 months ago
It's a virtual test, so just go with C for now.
upvoted 0 times
...
Joye
1 months ago
Yeah, Cloud SQL for MySQL external replica is the way to go.
upvoted 0 times
...
Eun
1 months ago
I think C is the best option for creating replicas.
upvoted 0 times
...
...
Nan
2 months ago
I'm voting for Option C! Keeping it in the Google Cloud ecosystem makes the most sense for my hybrid setup.
upvoted 0 times
...
Gianna
2 months ago
Option B with the Data Migration Service could be a good choice, but I'm not sure if it supports the hybrid configuration I'm working with.
upvoted 0 times
Dudley
22 days ago
C) Cloud SQL for MySQL external replica could also be a good choice for scaling reads.
upvoted 0 times
...
Alona
23 days ago
B) I think using Data Migration Service might be the best option for your hybrid configuration.
upvoted 0 times
...
Alpha
1 months ago
A) Use external server replication.
upvoted 0 times
...
...
Benedict
3 months 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
Darrin
2 months ago
I agree, Option C is a more automated solution that can help scale reads and offload management operations efficiently.
upvoted 0 times
...
Marcos
3 months ago
Option C sounds like a better choice for you. It allows you to create replicas easily without manual intervention.
upvoted 0 times
...
...
Tiera
3 months 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
Brynn
2 months ago
Great to hear that it worked well for you. I'll definitely give it a try for my MySQL databases on Google Cloud.
upvoted 0 times
...
Page
2 months ago
I've used it before and it worked really well for me. It's a reliable option for creating replicas in a hybrid configuration.
upvoted 0 times
...
Elenora
3 months ago
I agree, using Cloud SQL for MySQL external replica will definitely help scale reads and offload management operations.
upvoted 0 times
...
Malcolm
3 months 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
3 months ago
I prefer using the mysqldump utility and binary logs for creating replicas.
upvoted 0 times
...
Crista
3 months ago
I agree with Julene, Cloud SQL for MySQL external replica is the best option for scaling reads.
upvoted 0 times
...
Julene
4 months ago
I think we should use Cloud SQL for MySQL external replica.
upvoted 0 times
...

Save Cancel