Hi,
Basicaly, PGCluster requires same version of Cluster DB for DB nodes.
For example.
server A accept 10 sessions, and server B accept 20 sessions.
30 is the suitable value in each 'max_connection' parameter.
means as follows,
server A: 10 sessions will be accepted from load balancer,
and 20 sessions should be accepted from server B through
replication server.
server B: 20 sessions will be accepted from load balancer,
and 10 sessions should be accepted from server A through
replication server.
Is it make clear for you ?
---------------
At.Mitani
> I appled the pgcluster patch in the Server A and Server B I not applied
> the pgcluster patch.
> Is it required to apply the patch in Server B also and What value I need
> to set for the max_connection parameter.
>
>
>
>
>
>
>
> Regards
> G Muniswamy
> DBA
> Extn:
> ===========================================================================
> Sobha Renaissance Information Technology Private Limited
> An SEI-CMM & P-CMM Level 5 Company
> World's 1st SSE-CMM Level 5 Company
> BS 7799 certified by British Standards Institute
> ISO 9001:2000 Certified by TUV Rheinland/Berlin-Brandenburg
> A Six Sigma Practice Company
> Tel: + 91 80 51951999; Fax: + 91 80 51523300; Video Conference: + 91 80
> 51252222
> Email: muniswamy.g@xxxxxxxxxxxxxxxxxx; Web: www.renaissance-it.com
> ===========================================================================
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you received
> this in error, please contact the sender and delete all copies from any
> computer.
>
>
>
>
> -----Original Message-----
> From: pgcluster-general-bounces@xxxxxxxxxxxxx
> [mailto:pgcluster-general-bounces@xxxxxxxxxxxxx]On Behalf Of
> a.mitani@xxxxxxxxxxxxxx
> Sent: 09 October, 2006 5:26 PM
> To: pgcluster-general@xxxxxxxxxxxxx
> Subject: Re: [Pgcluster-general] Replication Error
>
>
> Hi,
>
> Did you use the PostgreSQL-8.1.0 as cluster DB node?
>
> Replication patch is required for Cluster DB,
> therefore please use Cluster DB of PGCluster as cluster DB node.
>
> The Cluster DB is connected from loadbalancer and replication server.
> When server A received one session from loadbalancer, server A send
> replication request to replication server.
> Then replication server send replicated query to server B.
>
> Therefore, please set total connection number in your system to the each
> 'max_connection' .
>
> Regards,
> -------------------------
> At.Mitani
>
>> The Pgreplication and pgloadbalancer process runs on 'Server A',Now the
>> problem is that data is not replicating.
>> when the max_connect parameter set value as 0 ,then the data sends to
>> Server B but the data is sending to
>> Server A.When I change the max_connect value to 1 the Data sends to
>> Server
>> A and data is not replicated to Server B.
>>
>> The Postgres Versin is 8.1.0.
>>
>>
>>
>> The pgreplicator.conf is as following :
>> ========================================<Cluster_Server_Info>
>> <Host_Name> 172.16.70.1 </Host_Name>
>> <Port> 5431 </Port>
>> <Recovery_Port> 8101 </Recovery_Port>
>> </Cluster_Server_Info>
>> <Cluster_Server_Info>
>> <Host_Name> 172.16.70.2 </Host_Name>
>> <Port> 5433 </Port>
>> <Recovery_Port> 8101 </Recovery_Port>
>> </Cluster_Server_Info>
>>
>>
>>
>> <Replication_Port> 8001 </Replication_Port>
>> <Recovery_Port> 8101 </Recovery_Port>
>> <Response_Mode> normal </Response_Mode>
>>
>> The pglb.conf is as following:
>> =============================<Cluster_Server_Info>
>> <Host_Name> 172.16.70.1 </Host_Name>
>> <Port> 5431 </Port>
>> <Max_Connect> 1 </Max_Connect>
>> </Cluster_Server_Info>
>> <Cluster_Server_Info>
>> <Host_Name> 172.16.70.2 </Host_Name>
>> <Port> 5433 </Port>
>> <Max_Connect> 32 </Max_Connect>
>> </Cluster_Server_Info>
>>
>> <Backend_Socket_Dir> /tmp </Backend_Socket_Dir>
>> <Receive_Port> 5432 </Receive_Port>
>> <Recovery_Port> 6001 </Recovery_Port>
>> <Max_Cluster_Num> 128 </Max_Cluster_Num>
>> <Use_Connection_Pooling> no </Use_Connection_Pooling>
>>
>> Please send me the correct configuration Steps.
>>
>>
>>
>>
>>
>> Regards
>> G Muniswamy
>> DBA
>> Extn: 1618
>> Mobile: 9448063553
>> ==========================================================================Sobha
>> Renaissance Information Technology Private Limited
>> An SEI-CMM & P-CMM Level 5 Company
>> World's 1st SSE-CMM Level 5 Company
>> BS 7799 certified by British Standards Institute
>> ISO 9001:2000 Certified by TワV Rheinland/Berlin-Brandenburg
>> A Six Sigma Practice Company
>> Tel: + 91 80 51951999; Fax: + 91 80 51523300; Video Conference: + 91 80
>> 51252222
>> Email: muniswamy.g@xxxxxxxxxxxxxxxxxx; Web: www.renaissance-it.com
>> ==========================================================================The
>> information transmitted is intended only for the person or entity to
>> which
>> it is addressed and may contain confidential and/or privileged material.
>> Any review, retransmission, dissemination or other use of, or taking of
>> any action in reliance upon, this information by persons or entities
>> other
>> than the intended recipient is prohibited. If you received this in
>> error,
>> please contact the sender and delete all copies from any computer.
>>
>>
>>
>> _______________________________________________
>> Pgcluster-general mailing list
>> Pgcluster-general@xxxxxxxxxxxxx
>> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>>
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general@xxxxxxxxxxxxx
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general@xxxxxxxxxxxxx
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>
|
