Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 17, 2014 1:29 AM
Points: 97, Visits: 187
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:46 AM
Points: 6,619, Visits: 14,185
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:39 AM
Points: 415, Visits: 1,333
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:39 AM
Points: 415, Visits: 1,333
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:46 AM
Points: 6,619, Visits: 14,185
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: 2 days ago @ 4:35 AM
Points: 10, Visits: 64
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 14, 2014 8:26 AM
Points: 2,896, Visits: 3,278
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 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1443152
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse