Solved

Load balanced and failsafe SQL Server setup

Posted on 1998-05-21
6
265 Views
Last Modified: 2013-12-23
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
Comment
Question by:stevenvanooyen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 1

Accepted Solution

by:
zhanghl earned 200 total points
ID: 1562525
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
 

Author Comment

by:stevenvanooyen
ID: 1562526
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
 
LVL 1

Expert Comment

by:zhanghl
ID: 1562527
I have setup such a cluster NT system, but have not install SQL/ent yet.
0
Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

 

Author Comment

by:stevenvanooyen
ID: 1562528
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
 
LVL 1

Expert Comment

by:zhanghl
ID: 1562529
Hi, how it goes? :-)
0
 

Author Comment

by:stevenvanooyen
ID: 1562530
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

Optimum High-Definition Video Viewing and Control

The ATEN VM0404HA 4x4 4K HDMI Matrix Switch supports 4K resolutions of UHD (3840 x 2160) and DCI (4096 x 2160) with refresh rates of 30 Hz (4:4:4) and 60 Hz (4:2:0). It is ideal for applications where the routing of 4K digital signals is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is in response to a question (http://www.experts-exchange.com/Networking/Network_Management/Network_Analysis/Q_28230497.html) here at Experts Exchange. The Original Poster (OP) requires a utility that will accept a list of IP addresses …
Many of us in IT utilize a combination of roaming profiles and folder redirection to ensure user information carries over from one workstation to another; in my environment, it was to enable virtualization without needing a separate desktop for each…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Suggested Courses
Course of the Month10 days, 17 hours left to enroll

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question