Click here to monitor SSC
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
SSC-Enthusiastic
SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)

Group: General Forum Members
Points: 129 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
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11635 Visits: 16844
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
SSC Eights!
SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)

Group: General Forum Members
Points: 819 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
SSC Eights!
SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)

Group: General Forum Members
Points: 819 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
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11635 Visits: 16844
Google??

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

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

Group: General Forum Members
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
EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3754 Visits: 3829
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. 1 Dec 2016: now over 39,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