Load Balancing Question
7942Jul 12 2007 — edited Jul 13 2007WE have the following scenario
WE have a 3 node RAC. We have 2 clustered OLTP databases (db1 and db2). We have built 2 sevices srv_db1 and srv_db2 to service the requests to the databases. So does load balancing happen across these services?
For example
Currently say there are 50 users connected to srv_db1 via node1. There 2 users connected to srv_db2 via node2. ( A total of 52 users connected to node1)
There are 2 users connected to srv_db1 via node2. There are 100 users connected to srv_db2 via node2.
So new user wants to connect to srv_db1? Does he go to node1 or node2? If the load balancing needs to be done using the number of connections.