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

[Martín Marqués]

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