[Pgpool-general] [pgpool problem] about streaming replication and load balancing.

[Tatsuo Ishii]

Can you show me debug out? I mean run pgpool with "-d -n" option.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> yes, i am sure.
> 
> I tried it)
> 
> I tried a test how to change backend_hostname0 and backend_hostname1.
> (like as
> ..
> backend_hostname0='192.168.3.141'
> backend_weight0 = 1     # but not changed 'backend_weight0'
> backend_hostname1='192.168.3.160'
> backend_weight1 = 1000    # not changed 'backend_weight1' too.
> ...
> )
> 
> then pgpool has always connected backend_hostname0(192.168.3.141).
> 
> i think that this mean is 'can not reading pgpool load balancing' or 'can
> not reading PG server after backend_hostname0'.
> 
> what do you have a idea about something please?
> 
> 
> 2011/11/11 Martín Marqués <martin.marques at gmail.com>
> 
>> Are you sure that pgpool can connect to the second PG server?
>>
>> 2011/11/10 イジュヨン <elijah9 at gmail.com>:
>> > hello, developers and anybody using pgpool.
>> >
>> > i have a something problem about 'streaming replication' and 'load
>> > balancing'.
>> > i don't know what mail address for to ask like this problem. then i send
>> > this asking mail to you.
>> >
>> > (if i mistake this doing, please teach me that i can ask mailling list.)
>> >
>> > well, my question is this)
>> >
>> > <server spac>
>> >  - my 1st postgresql server(os:ubuntu10.4, ip:192.168.3.160, postgresql
>> > version 9.1) run normal operations.
>> >
>> >    (i checked that requested query success by use log)
>> >
>> >  - my 2nd postgresql server(os:ubuntu10.4, ip:192.168.3.141, postgresql
>> > version 9.1) run normal operations too.
>> >    (i checked it too.)
>> >
>> >  - my pgpool server(ip:192.168.3.160 - with 1st postgresql server, pgpool
>> > version 3.1 -
>> >
>> http://ftp2.jp.postgresql.org/pub/postgresql/projects/pgFoundry/pgpool/pgpool-II-3.1.tar.gz
>> )
>> > run normal operations too.
>> >
>> >    (i checked that requested query success by use log too.)
>> >
>> >
>> > <pgpool conf information>
>> > # cat pgpool.conf
>> > listen_addresses = '*'
>> > port = 9999
>> > socket_dir = '/tmp'
>> > pcp_port = 9898
>> >
>> > pcp_socket_dir = '/tmp'
>> > backend_hostname0 = '192.168.3.160'
>> > backend_port0 = 5432
>> > backend_weight0 = 1
>> > backend_data_directory0 = '/DbCenter_master/data'
>> > backend_flag0 = 'ALLOW_TO_FAILOVER'
>> >
>> > backend_hostname1 = '192.168.3.141'
>> > backend_port1 = 5432
>> > backend_weight1 = 1000
>> > backend_flag1 = 'ALLOW_TO_FAILOVER'
>> > enable_pool_hba = on
>> > authentication_timeout = 60
>> > ssl = off
>> > num_init_children = 32
>> >
>> > max_pool = 4
>> > child_life_time = 300
>> > child_max_connections = 0
>> > connection_life_time = 0
>> > client_idle_limit = 0
>> > log_destination = 'syslog'
>> > print_timestamp = on
>> > log_connections = on
>> > log_hostname = on
>> >
>> > log_statement = on
>> > log_per_node_statement = on
>> > log_standby_delay = 'if_over_threshold'
>> > syslog_facility = 'LOCAL0'
>> > syslog_ident = 'pgpool'
>> > debug_level = 0
>> > pid_file_name = '/var/run/pgpool/pgpool.pid'
>> >
>> > logdir = '/tmp'
>> > connection_cache = off
>> > reset_query_list = 'ABORT; DISCARD ALL'
>> > replication_mode = off
>> > replicate_select = off
>> > insert_lock = off
>> > lobj_lock_table = ''
>> > replication_stop_on_mismatch = off
>> >
>> > failover_if_affected_tuples_mismatch = off
>> > load_balance_mode = on
>> > ignore_leading_white_space = on
>> > white_function_list = ''
>> > black_function_list = 'currval,lastval,nextval,setval'
>> > master_slave_mode = on
>> >
>> > master_slave_sub_mode = 'stream'
>> > sr_check_period = 10
>> > sr_check_user = 'repl_user'
>> > sr_check_password = 'password'
>> > delay_threshold = 10000000
>> > follow_master_command = 'date > /DataCenter_nas/abc'
>> >
>> > parallel_mode = off
>> > enable_query_cache = off
>> > pgpool2_hostname = ''
>> > system_db_hostname  = 'localhost'
>> > system_db_port = 5432
>> > system_db_dbname = 'pgpool'
>> > system_db_schema = 'pgpool_catalog'
>> >
>> > system_db_user = 'pgpool'
>> > system_db_password = ''
>> > health_check_period = 0
>> > health_check_timeout = 20
>> > health_check_user = 'nobody'
>> > health_check_password = ''
>> > failover_command = 'date > /DataCenter_nas/abc2'
>> >
>> > failback_command = 'date > /DataCenter_nas/abc3'
>> > fail_over_on_backend_error = on
>> > recovery_user = 'nobody'
>> > recovery_password = ''
>> > recovery_1st_stage_command = ''
>> > recovery_2nd_stage_command = ''
>> >
>> > recovery_timeout = 90
>> > client_idle_limit_in_recovery = 0
>> > relcache_expire = 0
>> > #-------------- the end of pgpool conf---------------
>> >
>> >
>> > <i tried it>
>> > i send query request to pgpool, and 1st postgresql catch it always.
>> >
>> > it is a wrong working
>> >  why i did set pgpools to 1:1000 about backend_weight0 and
>> backend_weight1
>> > values.(look my pgpool.conf file)
>> > i think that this case's good working is almost catch 2nd postgresql
>> server.
>> >
>> > i don't know this working reason(about wrong pgpool's load balancing and
>> > after backend_hostname1 setting values).
>> >
>> > do you have to teach me about this problem or something idea?
>> > I hope your help. please help me.
>> >
>> >
>> > i waiting your mail.
>> > thanks.
>> >
>> >
>> > _______________________________________________
>> > Pgpool-general mailing list
>> > Pgpool-general at pgfoundry.org
>> > http://pgfoundry.org/mailman/listinfo/pgpool-general
>> >
>> >
>>
>>
>>
>> --
>> Martín Marqués
>> select 'martin.marques' || '@' || 'gmail.com'
>> DBA, Programador, Administrador
>>