June 13, 2003 at 11:42 am
In a two node sql server 2000 active/active cluster, is it possible to do load balancing there for the db servers?
June 16, 2003 at 8:00 am
This was removed by the editor as SPAM
June 17, 2003 at 3:20 am
I may be wrong, but I don't think it is possible to do dynamic load balancing between both instances in an active/active cluster (ie having incoming requests dispatched on the less loaded server, for example).
What is possible, on the other hand, is to split your databases between both servers. It's like having 2 separate servers, but you get the added benefit of failover.
June 17, 2003 at 3:55 am
We have been investigating setting up an active/active cluster. We have identified that cross database chaining is not intended to work across two separate servers. This may be an issue, depending on how tightly security is locked down on the database. We are going for execute permissions only on stored procedures and this policy must be relaxed if linked databases are split across two servers
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply