Avatar of rwheeler23
rwheeler23
Flag for United States of America asked on

How to setup a SQL cluster using MS SQL?

I have been asked to design and setup a SQL cluster. Before I commit to this project is this something that is extremely difficult and I should bring in a team that is familiar with this process? I have not done this before but have been working with MS SQL since version 6.0. I have setup SQL replication before but I spend the vast majority of my time writing T-SQL scripts and stored procedures. Any tips beyond what I am reading in the MS notes would be appreciated. What versions of MS SQL support clustering?
SQL

Avatar of undefined
Last Comment
rwheeler23

8/22/2022 - Mon
Paul MacDonald

"...is this something that is extremely difficult..."
No.

"...I should bring in a team that is familiar with this process?"
This depends on your comfort level, but the process isn't difficult:
Build the machines.
Add Microsoft Failover Cluster Services
Install SQL Server
Optionally establish SQL AlwaysOn High Availability

"Any tips beyond what I am reading"
Maybe read up on Failover Clustering and AlwaysOn HA

"What versions of MS SQL support clustering?"
All the modern ones.  The last several versions of SQL Server are "cluster aware" <- maybe read up on what that means.
rwheeler23

ASKER
I would assume you would need at least two SQL servers to do this? What does clustering get you that SQL replication does not?
Paul MacDonald

"I would assume you would need at least two SQL servers to do this? "
Yes, at least two physical or virtual servers.

"What does clustering get you that SQL replication does not?"
A Failover Cluster can fail over when one node becomes unavailable.   In other words, you're not just duplicating the databases, but creating one, large cluster of servers.  You only ever talk to one real server at a time, but you don't know (or care, usually) which one.  If that server goes down for some reason, Failover Clustering simply grabs another SQL server and puts it in charge.  Downtime is usually minimal and the transition may go completely unnoticed.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER CERTIFIED SOLUTION
David Favor

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
rwheeler23

ASKER
In this case, we are talking about security for an airport to keep the planes flying and commerce moving. You both have given excellent advice and it is very much appreciated. I will add that the request for clustering came from their IT consultant who is not a database person. I will speak directly with the client next week and find out their true plans.
Paul MacDonald

"to keep the planes flying and commerce moving"
If the SQL Server is critical to this mission, you're completely justified in failover clustering it, depending on your threshold of pain.  If you can afford some downtime and/or lost data, just having reliable backups you can reliably restore from may be an adequate solution.
rwheeler23

ASKER
Thanks for your tips.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.