• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

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.

0
stevenvanooyen
Asked:
stevenvanooyen
  • 3
  • 3
1 Solution
 
zhanghlCommented:
I think you should run two SQL Server Enterpise Edition copies on two NT Server Enterprise Edition systems with a clustered architecture. The two SQL Servers can be load ballanced and the client programs would be failesafe to switch the physical data source, the logical data source specified by ODBC client will not be changed. SQL Server Ent Edition supports two instants on one server while the task handovered.
0
 
stevenvanooyenAuthor Commented:
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.
0
 
zhanghlCommented:
I have setup such a cluster NT system, but have not install SQL/ent yet.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
stevenvanooyenAuthor Commented:
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?
0
 
zhanghlCommented:
Hi, how it goes? :-)
0
 
stevenvanooyenAuthor Commented:
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.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now