Solved

Load balanced and failsafe SQL Server setup

Posted on 1998-05-21
6
263 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
Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

 

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Have you ever set up your wireless router at home or in the office to find that you little pop-up bubble in the bottom right-hand corner of Windows read "IP Conflict - One of more computers on the network have been assigned the following IP address"…
A common practice in small networks is making file sharing easy which works extremely well when intra-network security is not an issue. In essence, everyone, that is "Everyone", is given access to all of the shared files - often the entire C: drive …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

710 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