[Pgpool-general] Load-Balancing works... at least for minutes..

[Gaetan Allart]

I should have told you that I'm using londiste to replicate data over nodes.

Gaëtan

Le 30 mars 2010 à 09:06, William King a écrit :

> I'm new to pgpool2 as well, but don't you want to be replicating the
> inserts and updates? because your slave would not be getting the new
> data otherwise.
> 
> On 03/30/2010 12:05 AM, Gaetan Allart wrote:
>> Hi everybody,
>> 
>> I'm a new user of PgPool-II and I'm experiencing a strange issue with it.
>> I have two PostgreSQL servers acting as master/slave. All INSERT/UPDATE queries go to master and SELECT queries are load-balanced over master and slave.
>> 
>> This configuration works pretty fine, at least for minutes...
>> 
>> Upon startup, pgpool correctly load-balances queries over my two servers. But within minutes, queries sent to slave are decreasing... decreasing... decreasing...
>> Within 30 minutes, my master gets all queries and becomes sick...
>> 
>> ncp_node_info tells me that status of both servers is all right (status = 2). Even more strange, if I ncp_node_detach and re-attache my slave server, it then gets queries back. And once again, within minutes, load falls down without any particular reason.
>> 
>> Here is my config_file :
>> 
>> listen_addresses = '0.0.0.0'
>> port = 5433
>> pcp_port = 9898
>> socket_dir = '/tmp'
>> pcp_socket_dir = '/tmp'
>> backend_socket_dir = '/tmp'
>> pcp_timeout = 10
>> num_init_children = 64
>> max_pool = 4
>> child_life_time = 0
>> connection_life_time = 0
>> child_max_connections = 0
>> client_idle_limit = 0
>> authentication_timeout = 10
>> logdir = '/var/run'
>> pid_file_name = '/var/run/pgpool/pgpool.pid'
>> replication_mode = false
>> load_balance_mode = true
>> replication_stop_on_mismatch = false
>> replicate_select = false
>> reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
>> print_timestamp = true
>> master_slave_mode = true
>> connection_cache = true
>> health_check_timeout = 20
>> health_check_period = 0
>> health_check_user = 'nobody'
>> failover_command = ''
>> failback_command = ''
>> insert_lock = true
>> ignore_leading_white_space = true
>> log_statement = false
>> log_connections = false
>> log_hostname = false
>> parallel_mode = false
>> enable_query_cache = false
>> pgpool2_hostname = ''
>> backend_hostname0 = 'localhost'
>> backend_port0 = 5432
>> backend_weight0 = 0.4
>> backend_hostname1 = 'Ip.Of.My.Server'
>> backend_port1 = 5432
>> backend_weight1 = 0.6
>> enable_pool_hba = true
>> recovery_user = 'nobody'
>> recovery_password = ''
>> recovery_1st_stage_command = ''
>> recovery_2nd_stage_command = ''
>> recovery_timeout = 90
>> client_idle_limit_in_recovery = 0
>> 
>> My pgpool version :
>> 
>> pgpool-II version 2.3.1 (tomiteboshi)
>> 
>> 
>> Any idea where I should look at?
>> 
>> 
>> Best regards,
>> Gaëtan
>> 
>> 
>> 
>> 
>> _______________________________________________
>> Pgpool-general mailing list
>> Pgpool-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgpool-general
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general