Solved

Load balanced and failsafe SQL Server setup

Posted on 1998-05-21
6
260 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
  • 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

FIPS stands for the Federal Information Processing Standardisation and FIPS 140-2 is a collection of standards that are generically associated with hardware and software cryptography. In most cases, people can refer to this as the method of encrypti…
Enterprise networks where VoIP phones have been deployed frequently use port configurations that allow both a computer and an IP phone to be plugged into the same switch port but use different VLANs. On Cisco equipment I'm referring to the "native V…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
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 …

770 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