Problemas con balanceo de carga

From: Yadisnel Galvez Velazquez <ygalvez(at)uci(dot)cu>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Problemas con balanceo de carga
Date: 2009-10-18 03:20:58
Message-ID: 2036583594.717211255836058886.JavaMail.root@ucimail3.uci.cu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hola,
Tengo montado PgCluster, he configurado dos nodos Cluster DB, un replicador y un balanceador de carga. He probado la réplica y lo hace muy bien al igual que la recuperación. Cuando intento conectarme al balanceador de carga con PgAdmin III, me devuelve el siguiente error:

"Error connecting to the server: server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request."

La configuración que tengo es como sigue:
cluster.conf en Cluster DB 1:
#---------------------------------------------------
# Replicator 1
#---------------------------------------------------
<Replicate_Server_Info>
<Host_Name> eipad2.uci.cu </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
#---------------------------------------------------
# Cluster DB 1
#---------------------------------------------------
<Host_Name> eipad1.uci.cu </Host_Name>
<Recovery_Port> 7001 </Recovery_Port>
<Rsync_Path> /usr/bin/rsync </Rsync_Path>
<Rsync_Option> ssh -2 </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<Rsync_Timeout> 10min </Rsync_Timeout>
<Rsync_Bwlimit> 0KB </Rsync_Bwlimit>
<Pg_Dump_Path> /usr/local/pgsql/bin/pg_dump </Pg_Dump_Path>
<Ping_Path> /bin/ping </Ping_Path>
<When_Stand_Alone> read_only </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 11s </LifeCheck_Interval>

cluster.conf en Cluster DB 2:
#---------------------------------------------------
# Replicator 1
#---------------------------------------------------
<Replicate_Server_Info>
<Host_Name> eipad2.uci.cu </Host_Name>
<Port> 8001 </Port>
<Recovery_Port> 8101 </Recovery_Port>
</Replicate_Server_Info>
#---------------------------------------------------
# Cluster DB 1
#---------------------------------------------------
<Host_Name> eipad5.uci.cu </Host_Name>
<Recovery_Port> 7001 </Recovery_Port>
<Rsync_Path> /usr/bin/rsync </Rsync_Path>
<Rsync_Option> ssh -2 </Rsync_Option>
<Rsync_Compress> yes </Rsync_Compress>
<Rsync_Timeout> 10min </Rsync_Timeout>
<Rsync_Bwlimit> 0KB </Rsync_Bwlimit>
<Pg_Dump_Path> /usr/local/pgsql/bin/pg_dump </Pg_Dump_Path>
<Ping_Path> /bin/ping </Ping_Path>
<When_Stand_Alone> read_only </When_Stand_Alone>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 11s </LifeCheck_Interval>

Replicador:
#---------------------------------------------------
# Cluster DB 1
#---------------------------------------------------
<Cluster_Server_Info>
<Host_Name> eipad1.uci.cu </Host_Name>
<Port> 5001 </Port>
<Recovery_Port> 7001 </Recovery_Port>
</Cluster_Server_Info>

#---------------------------------------------------
# Cluster DB 5
#---------------------------------------------------
<Cluster_Server_Info>
<Host_Name> eipad5.uci.cu </Host_Name>
<Port> 5005 </Port>
<Recovery_Port> 7005 </Recovery_Port>
</Cluster_Server_Info>
#---------------------------------------------------
# Load Balance Server 1
#---------------------------------------------------
<LoadBalance_Server_Info>
<Host_Name> eipad3.uci.cu </Host_Name>
<Recovery_Port> 6001 </Recovery_Port>
</LoadBalance_Server_Info>
#---------------------------------------------------
# Replicator 1
#---------------------------------------------------
<Host_Name> eipad2.uci.cu </Host_Name>
<Replication_Port> 8001 </Replication_Port>
<Recovery_Port> 8101 </Recovery_Port>
<RLOG_Port> 8301 </RLOG_Port>
<Use_Replication_Log> no </Use_Replication_Log>
<Replication_Timeout> 1min </Replication_Timeout>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 15s </LifeCheck_Interval>
<Log_File_Name> /tmp/pgreplicate.log </Log_File_Name>
<Log_File_Size> 1M </Log_File_Size>
<Log_Rotate> 3 </Log_Rotate>

pglb.conf en el balanceador de carga:
#---------------------------------------------------
# Cluster DB 1
#---------------------------------------------------
<Cluster_Server_Info>
<Host_Name> eipad1.uci.cu </Host_Name>
<Port> 5001 </Port>
<Max_Connect> 32 </Max_Connect>
</Cluster_Server_Info>
#---------------------------------------------------
# Cluster DB 5
#---------------------------------------------------
<Cluster_Server_Info>
<Host_Name> eipad5.uci.cu </Host_Name>
<Port> 5005 </Port>
<Max_Connect> 32 </Max_Connect>
</Cluster_Server_Info>
#---------------------------------------------------
# Load Balancer 3
#---------------------------------------------------
<Host_Name> eipad3.uci.cu </Host_Name>
<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>
<LifeCheck_Timeout> 3s </LifeCheck_Timeout>
<LifeCheck_Interval> 15s </LifeCheck_Interval>
<Connection_Life_Time> 0s </Connection_Life_Time>
<Log_File_Name> /tmp/pglb.log </Log_File_Name>
<Log_File_Size> 1M </Log_File_Size>
<Log_Rotate> 3 </Log_Rotate>

Agradecería cualquier ayuda, Gracias.

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Mari Gangrena 2009-10-18 10:46:05 distinct
Previous Message Yadisnel Galvez Velazquez 2009-10-18 03:16:06 Problemas con balanceo de carga