Load balancing.

Hi!

I have two sql servers. One raid rack in the middle for them both.

I installe two cluster groups, with two sql installation.

Now I can put a db on one server and it can fail over to the other one and
the other way around. Fine.

But how can I set it up so the same db is located one both cluster groups
(on the raid and shared by both cluster groups) and use some kind of load
balacing system to harvest the power of both servers for one db.

The only ways I have found so far is DTC and replikation. DTC no slack in
time for having the db exactly the same on both servers, but needs knowledge
and rewrite of code to use DTC transactions. Replikation, slack in time in
update between the cluster groups.

Is there another way to do this? We want to use the power of both servers in
a normal situation, have the fail over if one goes down, only one copy of
the db. No slack in time between the both servers.

regards

cj


.

Loading