SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Windows or Database Clustering?


Windows or Database Clustering?

Author
Message
niladri.primalink
niladri.primalink
SSChasing Mays
SSChasing Mays (619 reputation)SSChasing Mays (619 reputation)SSChasing Mays (619 reputation)SSChasing Mays (619 reputation)SSChasing Mays (619 reputation)SSChasing Mays (619 reputation)SSChasing Mays (619 reputation)SSChasing Mays (619 reputation)

Group: General Forum Members
Points: 619 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...
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (103K reputation)SSC Guru (103K reputation)SSC Guru (103K reputation)SSC Guru (103K reputation)SSC Guru (103K reputation)SSC Guru (103K reputation)SSC Guru (103K reputation)SSC Guru (103K reputation)

Group: General Forum Members
Points: 103148 Visits: 18004
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" ;-)
sql-lover
sql-lover
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8269 Visits: 1930
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
sql-lover
sql-lover
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8269 Visits: 1930
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? ...
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (103K reputation)SSC Guru (103K reputation)SSC Guru (103K reputation)SSC Guru (103K reputation)SSC Guru (103K reputation)SSC Guru (103K reputation)SSC Guru (103K reputation)SSC Guru (103K reputation)

Group: General Forum Members
Points: 103148 Visits: 18004
Google??

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
VickyDBA
VickyDBA
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 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
EdVassie
EdVassie
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25924 Visits: 3918
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 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search