[Pgcluster-general] concept of load balance server

[Chahyeon Rhee]

Well, I have this kind of log from pglb log
Thu May 29 16:54:21 2008
PGRset_status_on_cluster_tbl():host:***.***.***.*** port:5432 max:3 use:0
status1
Thu May 29 16:54:21 2008
PGRset_status_on_cluster_tbl():host:***.***.***.*** port:5432 max:3 use:0
status1
Thu May 29 16:54:21 2008  init_pglb():Child_Tbl size is[4644]
Thu May 29 16:55:16 2008  PGRscan_cluster:2 ClusterDB can be used
Thu May 29 16:55:16 2008  PGRscan_cluster:***.***.***.*** [5432],useFlag->1
max->3 use_num->0

Thu May 29 16:55:16 2008
PGRset_status_on_cluster_tbl():host:***.***.***.*** port:5432 max:3 use:1
status2
Thu May 29 16:55:16 2008  I am 880
Thu May 29 16:55:16 2008  I am 880 accept fd 6
Thu May 29 16:55:16 2008  Protocol Major: 1234 Minor: 5679 database:  user:
Thu May 29 16:55:16 2008  PGRdo_child(): SSLRequest: sent N; retry startup
Thu May 29 16:58:04 2008  PGRscan_cluster:2 ClusterDB can be used
Thu May 29 16:58:04 2008  PGRscan_cluster:***.***.***.*** [5432],useFlag->2
max->3 use_num->0

Thu May 29 16:58:04 2008  I am 882
Thu May 29 16:58:04 2008  I am 882 accept fd 6
Thu May 29 16:58:04 2008  Protocol Major: 1234 Minor: 5679 database:  user:
Thu May 29 16:58:04 2008  PGRdo_child(): SSLRequest: sent N; retry startup


I think load balancer detect two server and the number of max.
After that when I try to connect by 5433, it looks like trying to connect to
one server. I think after that, there is some problem with ssl. Do I have to
do something with ssl configuration?


On Wed, May 28, 2008 at 10:30 PM, <mitani at sraw.co.jp> wrote:

> Hi,
>
> The load balncer has current session numbers of each cluster db.
> The maximum session number of each cluster db is defined in "pglb.conf".
> Then, load balancer consider the load as "(connected sessions)/(max
> sessions)".
> It is consider neither connecting times nor cpu load.
> It is using just number of sessions.
>
> About the pg_connect error.
> Can you let us know the debug messages of replication server.
> Probably, we can find something in the debug log.
>
> Regards,
> --------------
> At.Mitani
>
> -- original message --
> From: Chahyeon Rhee<rchyeon at gmail.com>
> To: <pgcluster-general at pgfoundry.org>
> Sent: Wed, 28 May 2008 17:03:31 -0600
> Subject: [Pgcluster-general] concept of load balance server
>
> >Hi!
> >I am setting up load balance and cluster db1 in server 1
> >and replicator and cluster db2 in server 2.
> >I just tested replication and restoration.
> >Now, I would like to test load balance. But, I am little bit confused.
> >What I am thinking  is that I think if client request some then they will
> go
> >to some page in server 1.
> >Which is starting point. So I used pg_connect(host=server1 port=5433
> dbname=
> >... )
> >What I am thinking is if that connection go to load balance server in port
> >5433 then load balance server will determine which is lower load from
> >server1 and server 2. Server 1 and server 2 has port 5432. And the
> selected
> >database will be used for that service.
> >Is that right ?
> >If not, please give me any advice.
> >Also when I am doing like this, I am getting this error message *
> >Warning*: pg_connect()
> >[function.pg-connect<
> http://seo.gkmc.utah.edu/cha_test/pgcluster/function.pg-connect>]:
> >Unable to connect to PostgreSQL server: server closed the connection
> >unexpectedly This probably means the server terminated abnormally before
> or
> >while processing the request.
> >
> >If you know about this, please give me some help.
> >
> >Thanks,
> >
> >_______________________________________________
> >Pgcluster-general mailing list
> >Pgcluster-general at pgfoundry.org
> >http://pgfoundry.org/mailman/listinfo/pgcluster-general
> >
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080529/c4e714fa/attachment.html