[Pgcluster-general] load balance

[mitani at sraw.co.jp]

Hi,

Do you want to implemant SSL suport?
if so, it's need the ssl modules, I think.

Regards,

-- original message --
From: Chahyeon Rhee<rchyeon at gmail.com>
To: <pgcluster-general at pgfoundry.org>
Sent: Wed, 4 Jun 2008 11:30:03 -0600
Subject: [Pgcluster-general] load balance

>Hi! there,
>
>I am still working on load balance.
>
>I found some. If some can give more with this, please give me.
>
>I just looked in the source level.
>
>In my pglb.log:
>
>Wed Jun  4 11:23:45 2008
>PGRset_status_on_cluster_tbl():host:server1.***.***.*** p\
>ort:5432 max:5 use:0 status1
>Wed Jun  4 11:23:45 2008
>PGRset_status_on_cluster_tbl():host:server2.***.***.*** p\
>ort:5432 max:5 use:0 status1
>Wed Jun  4 11:23:45 2008  init_pglb():Child_Tbl size is[7740]
>Wed Jun  4 11:23:45 2008  before load_balance
>Wed Jun  4 11:24:16 2008  PGRscan_cluster:2 ClusterDB can be used
>Wed Jun  4 11:24:16 2008  PGRscan_cluster:server1.***.***.***
>[5432],useFlag->1 max\
>->5 use_num->0
>
>Wed Jun  4 11:24:16 2008
>PGRset_status_on_cluster_tbl():host:server1.***.***.*** p\
>ort:5432 max:5 use:1 status2
>Wed Jun  4 11:24:16 2008  before PGRdo_child
>Wed Jun  4 11:24:16 2008  I am 17198
>Wed Jun  4 11:24:16 2008  I am 17198 accept fd 6
>Wed Jun  4 11:24:16 2008  Protocol Major: 1234 Minor: 5679 database:  user:
>Wed Jun  4 11:24:16 2008  PGRdo_child(): SSLRequest: sent N; retry startup
>Wed Jun  4 11:24:16 2008  before return status_error_2
>Wed Jun  4 11:24:16 2008  after PGRdo_child
>
>
>This is related with the souce:
>
>child.c
>int
>PGRdo_child(int use_pool)
>{
>
>
>/* SSL? */
>        if (sp->major == 1234 && sp->minor == 5679)
>        {
>            /* SSL not supported */
>            show_debug("%s: SSLRequest: sent N; retry startup",func);
>            if (ssl_request)
>            {
>                pool_close(frontend);
>                pool_free_startup_packet(sp);
>                PGRset_status_to_child_tbl(pid,TBL_FREE);
>                if (use_pool == USE_CONNECTION_POOL )
>                {
>                    show_debug("before continue");
>
>                    continue;
>                }
>                else
>                {
>                     show_debug("before return status_error_1");
>
>                    return STATUS_ERROR;
>                }
>            }
>
>}
>
>So, I tried what happened if continue like
>child.c
>int
>PGRdo_child(int use_pool)
>{
>
>
>/* SSL? */
>        if (sp->major == 1234 && sp->minor == 5679)
>        {
>            /* SSL not supported */
>            show_debug("%s: SSLRequest: sent N; retry startup",func);
>            if (ssl_request)
>            {
>                pool_close(frontend);
>                pool_free_startup_packet(sp);
>                PGRset_status_to_child_tbl(pid,TBL_FREE);
>                //if (use_pool == USE_CONNECTION_POOL )
>                //{
>                //  show_debug("before continue");
>
>                    continue;
>                //}
>                //else
>                //{
>                //     show_debug("before return status_error_1");
>
>                //    return STATUS_ERROR;
>                //}
>            }
>
>}
>
>
>then load balance is connected and load balance can send request to server1
>or server2. But load balance looks not working correctly.
>
>
>I am thinking at this point.
>
>If anybody can give some intuition, please give me.
>
>Thanks in advance.
>
>_______________________________________________
>Pgcluster-general mailing list
>Pgcluster-general at pgfoundry.org
>http://pgfoundry.org/mailman/listinfo/pgcluster-general
>