asked on

Load balanced and failsafe SQL Server setup

I need a failsafe configuration that will effectively route ODBC datasources between two SQL Server machines. Here is my configuration: 4 Web servers on the front. These are running Cold Fusion Server in conjunction with IIS4 and using ODBC to transact with two sql server machines. The 4 web servers are balanced using Cisco's Local Director machines. We would like to achieve the same balance with the backend. Along with the balance, we would like to make sure that if one machine goes down the other would get all of the hits. I am not sure if it matters, but we will just be running NETBEUI from the front machines to the back. Any software or hardware suggestions would be appreciated.

ASKER CERTIFIED SOLUTION

zhanghl

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

stevenvanooyen

ASKER

Thanks for the answer. I think that you have put me on the right track. So, it will allow me to balance the work between the two SQL Servers and do the failover stuff I need? Have you implemented this before? Thanks for your help.

zhanghl

I have setup such a cluster NT system, but have not install SQL/ent yet.

stevenvanooyen

ASKER

Ok.. The one thing that I am looking for right now in the documentation is how the clustering handles the synchronization of the data from the db's on the two machines. In other words, how will the cluster manage the two copies of the db that must exist on both systems to allow for both failover and load-balancing. Do you know that?

zhanghl

Hi, how it goes? :-)

stevenvanooyen

ASKER

We just now got the hardware from Compaq to setup the cluster. I will try to remember to update this when we have it up.