Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Windows or Database Clustering? Expand / Collapse
Author
Message
Posted Monday, April 15, 2013 11:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 14, 2016 6:12 AM
Points: 113, Visits: 226
Hi All,

if my windows in clustering mode, is my database in SQL server also in Clustering? or I will have to do it for SQL server.

Actually we have huge database for client. Now we want to cluster for windows and for Database. Now my question is will we have to do 2 different clustering one for windows and one for database...or just clustering for only windows?


Please reply...
Post #1442596
Posted Tuesday, April 16, 2013 12:18 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Monday, September 26, 2016 11:57 PM
Points: 8,234, Visits: 16,383
A well formed Windows cluster is a pre requisite for a clustered sql server instance.

First you must cluster the Windows operating system on the computer nodes. Once this is done you then have to install the sql server instance as a cluster aware application.

If you're going to be using Veritas Cluster Server or HP Polyserve instead of Windows Server Failover Cluster, then the process is somewhat more complicated.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1442605
Posted Tuesday, April 16, 2013 7:34 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, September 22, 2016 11:12 AM
Points: 645, Visits: 1,929
niladri.primalink (4/15/2013)
Hi All,

if my windows in clustering mode, is my database in SQL server also in Clustering? or I will have to do it for SQL server.

Actually we have huge database for client. Now we want to cluster for windows and for Database. Now my question is will we have to do 2 different clustering one for windows and one for database...or just clustering for only windows?


Please reply...


-You install MS Clustering services 1st (two node at min. You can actually with one, but makes no sense)
-You install MS-SQL as a failover instance. Then it will run as a cluster aware SQL installation

If you do not require geographical dispersion, MS Clustering should work. Keep in mind that if the same datacenter or SAN fails, or both servers, the whole Cluster goes down.

If you need geographical dispersion, let's say Houston and Dallas, then you may need a software like Veritas. In my experience, most companies do not require it, unless the database is MC and extremely important for the business.

So, two steps... one Windows Cluster..... one SQL failover (at least) after installing the Cluster Service or make it run ... also, you need a SAN (common storage) for your Cluster.

You can start learning more, with a very simple link or resource like this one: Windows Clustering
Post #1443065
Posted Tuesday, April 16, 2013 7:36 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, September 22, 2016 11:12 AM
Points: 645, Visits: 1,929
Perry Whittle (4/16/2013)

If you're going to be using Veritas Cluster Server or HP Polyserve instead of Windows Server Failover Cluster, then the process is somewhat more complicated.


Wow, never heard of that HP service or software. Any link or resource? ...
Post #1443066
Posted Tuesday, April 16, 2013 10:44 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Monday, September 26, 2016 11:57 PM
Points: 8,234, Visits: 16,383
Google??

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1443091
Posted Wednesday, April 17, 2013 2:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 17, 2015 2:21 AM
Points: 10, Visits: 78
HP Polyserve is not just a Cluster software but it does provide a well consolidation feature where 15-20 SQL server instances can be well managed on a well configured server (number of instances can be more on one server but this is just a well estimated guess as per my experience). However, getting the support for HP Polyserve is not so easy and not sure the future of product as I had heard that HP is working on newer similar product and the Polyserve is almost to an end of life!

You can get more information on HP's site.

Thanks,
Vikas
Post #1443145
Posted Wednesday, April 17, 2013 2:52 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, August 30, 2016 2:28 AM
Points: 3,034, Visits: 3,711
If you already know SQL Server but do not know SQL Clustering then you have a lot of learning to do. SQL Clustering introduces new and interesting ways to trash your data if you get things wrong.

My advice is to start with a SQL Cluster in your development environment, and spent 2 or 3 weeks trying to break it and then fixing the problems. You should then have the skills you need to troubleshoot problems you might get in Production.

This assumes that Clustering is the right answer for your problem. SQL Clustering gives high availability but not high resilience. There are many single points of failure in SQL Clustering, so if you want high resilience then you need a different solution. Have you considered database mirroring or Peer to Peer replication - both of these options give you high resilience as wel as high availability.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005. 29 Aug 2016: now over 38,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
Post #1443152
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse