A load balancing method and system for a transaction computer system having multiple
database servers for at least one database, wherein database servers cooperate
to provide a unified view of the data in the database. The method includes the
steps of establishing connections to said multiple database servers for communicating
with said database servers; and assigning transactions to respective ones of said
multiple database servers to balance respective loads of said multiple database
servers. Assigning each new transaction includes the steps of determining possible
assignments of that new transaction to one or more of said multiple database servers,
each said possible assignment to one of said multiple database servers being based
on a load balancing scheme to balance respective loads of said multiple database
servers; and assigning that new transaction to one of said multiple database servers
as a function of said possible assignments of that new transaction, to balance
respective loads of said multiple database servers.