 |
 |
Archives of the TeradataForum
Message Posted: Tue, 07 Sep 2004 @ 20:47:58 GMT
| Subj: | | Re: JDBC Type 4 / URL string |
| |
| From: | | Victor Sokovin |
Jose,
| | To have a behavior similar to the ODBC driver. We would like to evenly distribute our sessions across nodes so we don't overload just one
of them with 200 web sessions which I assume will generate unbalanced CPU and memory consumption on the overall environment. | |
I think your concern has a good reason for it.
With type 4 JDBC drivers, an application actually submits an alias for the Database Server Name. That's the string that you denoted by "node1".
The string does not have to be a particular TD node, though. It can just be an alias.
What happens further with this alias depends on your DNS configuration. I would suggest to talk to your network administrators and ask them
whether they can set up the so called DNS Round Robin for you. If they can, that's all there is to do about load balancing in this case. That's
the difference with the ODBC configuration.
Regards,
Victor
| |
