April 8, 2015 at 1:01 pm
So my boss asked me to look into SQL clustering as we may be using it down the road. I went through and installed the Windows Cluster and SQL Cluster, and practiced manually failing it over. Now the SQL Cluster is up and I'm not sure what else to try with it. Anyone have any tips, things to try, or resources that will help me become the subject matter expert of SQL Clustering? Thanks.
April 8, 2015 at 3:08 pm
If you installed it and got it failing over on your first try, you're probably already head & shoulders above most people.
The expert on clusters is Allan Hirt. He has a book and a blog and runs regular training courses. For more information, that's where I'd go. Here's his web site.[/url]
An additional thing to explore would be Availability Groups in 2014. And if you want to get really fancy, look at setting up a hybrid cluster with half of it in VMs on a virtual network with AWS or Azure.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 9, 2015 at 1:33 am
You can also check the I/O performance of storage before you hand it over for production. Also try all the possibilities of fail over to check the cluster e.g. reboot the Active node, remove the network cable etc.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2015 at 5:56 am
check for hardware and software failover scenarios.
Terminate the sqlservr.exe process on the node that owns the resources
Disconnect the network cable
Shutdown the node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2015 at 7:25 am
Good tips thank you all. My first attempt to install the cluster and then the sql cluster did not go flawlessly but mainly due to that fact I am not a domain administrator. So I had to work with the systems department during the install, as well as setting up the storage. I will try what I can out of those tips, the machine is virtual and is not local so I can't pull a plug, but I can certainly crash it. Thanks again.
April 9, 2015 at 8:18 am
check my stairway guide to SQL HA on this site starting at the link below
http://www.sqlservercentral.com/articles/FCI/107536/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply