[Pgcluster-general] connecting to load balancer - help

[mitani at sraw.co.jp]

Hi,

When you wanto to use loadbalancer which is installed in same machine with clusterDB,
You should specified unique port numbers in the loadbalancer and the clusterDB.

EX.
server          receive port 
----------------------------
load balancer:   5432
cluster db1  :   5001
cluster db2  :   5002

On above sample, client can access cluster DB through loadbalancer with port 5432 using.

Regards,
------------
At.Mitani

-- original message --
From: Sunitha S<sunithas at aztecsoft.com>
To: <pgcluster-general at pgfoundry.org>
Sent: Sat, 7 Jun 2008 19:22:28 +0530
Subject: [Pgcluster-general] connecting to load balancer - help

>
>Hi All,
>
>
>
>
>We have following setup
>
>
>
>
>Tstmach1:
>
>ClusterDB1
>
>Replication server1
>
>Load Balancer
>
>
>
>
>Tstmach2
>
>ClusterDB2
>
>Replication server2
>
>
>
>
>And the nodes are started in the following order
>
>ClusterDBs on Tstmach1 and 2
>
>Pgrelicates on Tstmach1 and 2
>
>Pglb on Tstmach1
>
>And log for pglb is as follows
>
>
>
>
>2008-06-08 00:11:14 [30653]
>DEBUG:PGRset_status_on_cluster_tbl():host:a3-cybertst1 port:5432 max:32
>use:0 status1
>
>2008-06-08 00:11:14 [30653]
>DEBUG:PGRset_status_on_cluster_tbl():host:a3-cybertst5 port:5432 max:32
>use:0 status1
>
>2008-06-08 00:11:14 [30653] DEBUG:init_pglb():Child_Tbl size is[49536]
>
>
>
>
>and the cluster works fine.
>
>
>
>
>But How do connect to the load balancer and test fail scenarios with a
>load balancer
>
>
>
>
>Thanks in advance
>
>
>
>
>Regards,
>
>Sunitha S
>
>
>
>This email message and its attachments may contain CONFIDENTIAL AND PRIVILEGED INFORMATION intended for the sole use of the addressee(s). If you have received it in error, please contact the sender by return email, notify your system manager and destroy the original message and any copies thereof. Any review, use, disclosure or distribution is unlawful. Please check this email and any attachments for the presence of viruses. The Company accepts no  liability for any damage caused by any virus transmitted by this email. The views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the company.
>The Company reserves the right to monitor, review and store the content of all messages sent to or from this e-mail address.
>
>
>www.aztecsoft.com
>_______________________________________________
>Pgcluster-general mailing list
>Pgcluster-general at pgfoundry.org
>http://pgfoundry.org/mailman/listinfo/pgcluster-general
>