Load balanced and failsafe SQL Server setup
Posted on 1998-05-21
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.