DB2 connection routing using Linux load balancing

Share

From developerworks…

For any database, the first step to accessing data is making a connection from the client to the server. You may need to establish connections from clients to your IBM® DB2® Universal Database™ server across a wide area network or from the Web. If you have many connections coming in, with the potential for overloading your network or server at peak times, you may be looking at implementing a load balancing solution to spread requests across multiple servers. The flexibility of routing these connections by using facilities outside of DB2 has many potential applications.

This article discusses one method of routing TCP/IP DB2 connections using an open source TCP proxy utility called Balance.

See the complete article on developerworks