pgpool fundamental questions

From: "Brian Maguire" <bmaguire(at)vantage(dot)com>
To: "postgresql-general mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: pgpool fundamental questions
Date: 2005-02-27 20:12:46
Message-ID: 4BAFBB6B9CC46F41B2AD7D9F4BBAF7850DE2B9@vt-pe2550-001.vantage.vantage.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pgpool is a real cool project, I really hope it keeps evolving. I have a couple basic/fundamental questions that I hoping to get some clarification on.

Question 1: If pgpool is used in conjuntion with slony or a another replication it can be used only for its loadbalancing and failover. I am correct like this? What else needs to be done to set in failover?

set the backends....

backend_host_name =master
secondary_backend_host_name=slave

set it to lb on and replication off...

load_balance_mode=true
replication_mode=false

set the health checks for failover.

health_check_timeout=20
health_check_period=20
health_check_user=user

Question 2: In the case that the master goes down pgpool would failover to the slave/secondary. What would be the logical steps to bring it back to normal. Can this be down with no downtime with both?

1) Turn off health check or weight the weight_master =0 so when you bring the master back load does not go to it when you bring the db backup. or does pgpool leave it down automatically until you restart pgpool?

2) Shutdown replication on the master. Bring back the master backup.

3) rsynch the data from the slave to the master???

4) turn replication?

Question 3: Is there anyway to make pgpool loadbalance certain select queries to the slave such as queries to a particular table? Is that a future feature planned?

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message cbbrowne 2005-02-27 20:21:47 Re: [Slony1-general] Nagios plugin to check slony replication
Previous Message Ron Mayer 2005-02-27 20:07:03 Re: [PATCHES] A way to let Vacuum warn if FSM settings are low.