· Mar 2, 2017

Load balance for ECP servers

Has anyone ever worked with a load balance for ECP servers access? If yes, wich one? 

What are the pros and cons of such a solution? We use ECP servers as data servers via ODBC, thanks!

Discussion (7)0
Log in or sign up to continue

Hi, thanks for the reply.

I have two ECP application servers connected in a ECP data server. The ODBC clients are connected to my two ECP application servers and I want do load balance of their connections. 

My servers runs in Windows Server 2008 R2. I am wondering if someone has alreadey used a load balance solution, like Microsoft NLB or HAProxy, for this cenario.

Several years ago our company (SP.ARM) had developed Krasnoyarsk Kray Regional HIS, which was finally deployed using haproxy to balance CacheActiveX traffic load among 7 ECP application servers. This kind of traffic is based on the same protocol as ODBC, so the behavior should be quite the same (long sessions via 1972/tcp). To achieve high availability of the proxy server, it was deployed in two similar copies connected with ucarp.

Our initial solution for load balancing and high availability of proxy was based on LVS+keepalived, but the engineers of maintainer company (Rostelecom) prefered to use haproxy+ucarp as they felt themselves more comfortable with them; we didn't mind.

Hi Victor,

There is a customer in Brazil which is using HAProxy and KeepAlived  to set up high availability for their load balancers. They currently have 2 HAProxy servers (primary an secondary) 4 ECP servers and 1 DB server. They currently are load balancing all connections ODBC, JDBC, etc. with this solution. They are managing/load balancing approximately 5.000 user connections. I can manage to put you in contact with the customer in order to help you with some question about the architecture or configuration. 

I hope it helps.


Fábio Gonçalves.