Topic 1 Question 24
You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?
Use Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.
Use HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
ユーザの投票
コメント(11)
Per GPC72's referenced link, you need PgBouncer only does connection pooling, need Load balancing coupled. Since Load Balancing not referenced in B., is not A the best answer?
PgBouncer is a popular connection pooler designed for PostgreSQL, but it is not enough to achieve PostgreSQL High Availability by itself as it doesn’t have multi-host configuration, failover, or detection.
Using a Load Balancer is a way to have High Availability in your database topology. It could be useful for redirecting traffic to healthy database nodes, distribute the
👍 3sp572022/12/30- 正解だと思う選択肢: A👍 2Teraflow2023/02/08
- 正解だと思う選択肢: B
B is the correct answer https://severalnines.com/blog/how-achieve-postgresql-high-availability-pgbouncer/
👍 1GCP722022/12/24
シャッフルモード