Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.


pgsql-es-ayuda by date

Next:From: Mari GangrenaDate: 2009-10-18 10:46:05
Subject: distinct
Previous:From: Yadisnel Galvez VelazquezDate: 2009-10-18 03:16:06
Subject: Problemas con balanceo de carga

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group