Supported NLB (Network Load Balancer) for PostgreSQL HA
by z_haseeb from LinuxQuestions.org on (#6DPHA)
ENVIRONMENT
OS = RHEL Linux 8.x
Kong API Gateway Version = 2.6
Kong API Gateway Nodes = 2
PostgreSQL Version = 15
PostgreSQL Nodes = 3 [One Leader and Two Slaves]
NLB (Network Load Balancer) = HAPROXY
DETAIL
We have installed and configured a three nodes PostgreSQL HA at on-premises environment with the help of Patroni & ETCD. In case we reboot the Leader PostgreSQL node, One Slave node from the other two Slaves become Leader node. Means the PostgreSQL HA is working fine.*
We have placed HAPROXYas NLB between KONG API Gateway and PostgreSQL HA nodes. When any KONG API Gateway send requests to HAPROXY, the HAPROXY forward the requests to the Active/Leader node of PostgreSQL machine. With this configuration everything is again working excellent.*
We replaced the NLB/HAPROXY*(which is placed between KONG API Gateway and PostgreSQL HA nodes) with FRTIGATE 200F Firewall's NLB. With this configuration everything is again working excellent*
QUERY
Now we want to replace the NLB*which is placed between KONG API Gateway and PostgreSQL HA nodes with Citrix ADC 2504. Actually one of my client could not able to configure the Citrix ADC 2504 so that the Citrix ADC 2504 can only forward all requests to Master node of PostgreSQL HA. May anyone give me some support on this ?
OS = RHEL Linux 8.x
Kong API Gateway Version = 2.6
Kong API Gateway Nodes = 2
PostgreSQL Version = 15
PostgreSQL Nodes = 3 [One Leader and Two Slaves]
NLB (Network Load Balancer) = HAPROXY
DETAIL
We have installed and configured a three nodes PostgreSQL HA at on-premises environment with the help of Patroni & ETCD. In case we reboot the Leader PostgreSQL node, One Slave node from the other two Slaves become Leader node. Means the PostgreSQL HA is working fine.*
We have placed HAPROXYas NLB between KONG API Gateway and PostgreSQL HA nodes. When any KONG API Gateway send requests to HAPROXY, the HAPROXY forward the requests to the Active/Leader node of PostgreSQL machine. With this configuration everything is again working excellent.*
We replaced the NLB/HAPROXY*(which is placed between KONG API Gateway and PostgreSQL HA nodes) with FRTIGATE 200F Firewall's NLB. With this configuration everything is again working excellent*
QUERY
Now we want to replace the NLB*which is placed between KONG API Gateway and PostgreSQL HA nodes with Citrix ADC 2504. Actually one of my client could not able to configure the Citrix ADC 2504 so that the Citrix ADC 2504 can only forward all requests to Master node of PostgreSQL HA. May anyone give me some support on this ?