IPv6, Windows Server 2008 (RTM and R2), and Failover Clustering

by Allan January 12, 2010 19:26

There has been a lot of discussion lately among MVPs around “Should/can I disable IPv6 on Windows Server 2008 (RTM or R2) for servers that will act as failover clustering nodes?” Obviously this affects any products such as SQL Server or Exchange that will be then clustered on top of a Windows Server 2008 failover cluster.

In the sake of full disclosure, I have been recommending to many customers who were going to cluster over the past year or so to disable IPv6 if they were not using it. There was no definitive statement one way or the other and in all of my use and testing, I’ve seen no issues with doing so. While I didn't say to disable IPv6 in my book Pro SQL Server 2008 Failover Clustering, since I have been telling people to consider it, I had to "fess up".

Due to the MVP discussions, a PM from the Windows clustering team chimed in and they recommend that unless there is a strong reason to disable IPv6, you should not do so. Why? The following three points come directly from the PM:

  • In all of our current troubleshooting and investigation of [Windows Server] 2008 and [Windows Server] 2008 R2 networking issues which may have been caused by IPv6, it has turned out that disabling it has not directly solved any problems.  These issues were resolved by disabling related networking components, such as Teredo or TCP Offload.
  • By default, all clusters will communicate between nodes over IPv6.  If that is not available on network interfaces, then the cluster will try to communicate using 6-to-4 tunnels.  If IPv6 is completely unavailable in this environment, the nodes will then communicate by IPv4.  So yes, it is possible to disable either IPv4 or IPv6 and still have the cluster function correctly.
  • We recommend keeping IPv6 on as this is the default configuration, which means that it is the most thoroughly tested and stable configuration.  IPv4, by itself, certainly will work, but we don’t recommend disabling IPv6 unless there is a good reason to do so.

So there you have the definitive “word” on the topic. As of the writing of this blog post, there is no official SQL Server statement on the “should I disable IPv6” topic (and if there is one at some point, I’ll update this post), but  since a SQL Server failover cluster is built on top of Windows Server 2008, I strongly suggest you follow the recommendation above for IPv6: don’t disable it. I know this will be my recommendation going forward in further talks/presentations, training, and consulting I do.

Come See Me at World of Windows Server in Singapore Dec 8 - 10.

by Allan November 20, 2009 02:52

Well, it's official - the website just went up. Can't hide it anymore ... I'm delivering a 3-day masterclass on consolidation and virtualization at World of Windows Server in Singapore as well as delivering two sessions (although the current website shows two different, it is going to be a two parter on clustering). I'm very exicted and honored to have been asked to do this.

If you don't live in Singapore or can't get there (hey, what's a few thousand US dollars to take a little excursion to Singapore at the last minute - just ask ask your boss!), I do plan on delivering the masterclass and possibly expanding it to four or five days. Or not. I've spent a lot of time over this past month in content development (official v1 of my Windows Server 2008/SQL Server failover clustering class and this upcoming delivery in Singapore), and am going to assess it after I'm done to see if any tweaks are needed. I can promise you that whether you come to Singapore or see it in a town near you, it'l be a lot of fun, technical content, and information.

Contact me if you want to know more!

File Under Not Supported (PowerShell and Clustering Content)

by Allan November 16, 2009 11:27

So it's no secret I've been using Windows Server 2008 R2 for quite some time. I like the PowerShell commandlets, and I've occasionally used the failover clustering module for PowerShell in R2 to manage "downlevel" Windows Server 2008 RTM (and SP2) based clusters with no issue.

This week I also figured, "What the heck?" and installed PowerShell 2.0 on a Windows Server 2008 SP2 cluster, and took the module from R2. It seemed to work just fine. You obviously don't get any new features, so things like Live Migration won't work. Only the basic failover clustering PowerShell commands would technically be applicable.

Despite both of these scenarios seemingly working fine in my limited use of them, they are 100% unsupported by Microsoft. So I will say this: I'm glad I tried it, but I would never recommend you doing something that would put your supportability in jeopardy - especially on a production system. If you do use these in either of the scenarios, do it at your own risk.

PASS Wrapup and Other Musings

by Allan November 12, 2009 15:23

PASS was a whirlwind week between the three main conference days and the two MS Insider days on either end. I don't ever remember being so busy at PASS, yet for the first time in ... well ... I don't know how long I actually attended a handful of sessions. I highly recommend the HA customer panel led by two good friends on SQLCAT Prem Mehra and Sanjay Mishra. Besides hearing about real world implementations, I was SO glad the panel talked about people and process. You don't get 12 seconds of downtime with technology alone! It wouldn't be PASS if I didn't say that it was good seeing everyone - friends new and old, including putting faces with people I had been talking to for quite awhile either over e-mail or on the phone. Oh, and Buck - stop trying to make friends with fire hydrants!

Despite all of the excitement I also managed to deliver my own, not without its own set of challenges. By the time I hit PASS, I realized that my session had been made 500 level. 500 level? I may be good, but 500 I think implies I must know a lot about SQL Server and failover clustering lol Now wanting to disappoint, my presentation and demos had major surgery before Thursday, and I hope I passed the audition (to paraphrase a famous rock band ...). I'll see when I get my scores in a few weeks. I only wish I had a two parter or more time, as it would have even been better. It was also fun sitting in for the afternoon on the failover clustering pre-con.

I did see that people posted Tweets about me on Twitter http://twitter.com/search?q=Hirt%20sqlpass. I'm not on Twitter and don't plan on it (I am on Facebook, though). Someone pointed it out to me. Seeing it was a strange experience.

In other news, I saw that Ken Simmons took the time to read and blog with a brief review of my new consolidation whitepaper. It's always nice to see people actually thinking what you do is worthwhile; sometimes it's hard to see the forest through the trees when you're writing and editing.

On Amazon, my Pro SQL Server 2005 High Availability book just got its first review after two years in publication. I was pretty shocked to see it, considering how long it's been out. I know what people have said to me about it, but funny to see a formal review after my new book was published.

Speaking of my new book, I thank those of you who have already bought Pro SQL Server 2008 Failover Clustering  in eBook or a physical format (i.e. a book of the paper kind) since its publication in July. The word on the street is it's doing fairly well, and people seem to like it. I saw at PASS it sold out, which I took to mean it was popular.

Oh, and I know I need to finish the scripts. I will soon - and one of them is a PowerShell-based script which automatically creates the scripts to install your Windows and SQL Server failover clusters pulling the info from my configuration spreadsheet. I know the scripts are way late, but I've been a tad busy and I want to give you guys good value. My apologies.

I've got a few future book ideas up my sleeve - a few of which may come to fruition over the next year or so - but I can say with relative certainty that I'll probably be doing a full HA book (not just failover clustering) for the next full version of SQL Server after SQL Server 2008 R2. Chances are it will be bigger than the 2005 HA book which is about 800 pages. Yes, you read that right. Bigger. Better start lifting weights now!

Well, in the mean time, I'm off to finish preparing for a failover clustering training class I'm delivering next week, and finalize my consolidation/virtualization class I'll be delivering in Singapore in December, along with two normal presentations (one on failover clustering, another on consolidation/virtualization).

Thankfully I'll have a little bit of downtime in Japan (before Singapore) and Hong Kong (after Singapore). I get to spend my upcoming 38th birthday on a plane flying to Tokyo. I look forward to catching the Tokyo Kosei Wind Orchestra and hopefully Stanley Clarke, Chick Corea, and Lenny White at the Blue Note while in town. I found my USA-made 1976 maple neck fretless Fender Precision there in 2008 for a great price, and it's become a favorite to play. Tokyo not only a great place to visit just as a tourist (this will be my third time there), but an awesome music town. If you're a lover of buying music in a physical format, one of the last places on Earth that still has a lot of great CD and record stores. Hopefully I'll also get to hang a bit with my friend Jason who I was in a band with back in college. My new jazz album is partially done, and I'll be doing a lot of composing and arranging while on that trip. Heaven knows I'll have a LOT of time on airplanes!

Node Names, x64, SQL Server 2005 with SP3, and Windows Server 2008 R2

by Allan November 12, 2009 03:30

I have been at a client all week implementing a SQL Server 2005 Standard Edition SP3 cluster using Windows Server 2008 R2 for the underlying operating system. Since this is W2K8 R2, it's 64-bit only, so we implemented SQL Server 2005 x64. Everything went pretty smoothly, as did the cutover from their current production box. However, we did notice one weird issue: we couldn't configure a Maintenance Plan (I'm not a huge fan - I'm more of a create it on your own kind of guy). As it turns out, I found the following blog post from a Microsoft support engineer. We had named the nodes ending in lowecase letters. The problem was that by the time we figured this out, we were already live in production, and there is no way we could take another outage, and run through the whole process of evicting and renaming nodes.

The blog only mentions Maintenance Plans and Database Mail. What it doesn't mention is that it also does not create the System/Performance Monitor counters for use, and you have replication issues if you are using a Publisher and Distributor on the same instance (although replication works, you get errors and it is just odd). If you configure replication to go against a remote Distributor, everything is just fine. We did a bunch of testing against another cluster we configured (same hardware configuration) for their soon-to-be reporting server and had none of the problems we had on the original cluster we configured as production.

The unfortunate thing is that the customer is now in production and they can't afford another outage to go and evict things and reconfigure the servers in use. Everything else is working and stable. They may consider migrating to the other cluster in another outage, but not anytime soon.

Moral of this sad tale of woe: never use lowercase letters for Windows Server 2008 (RTM or R2) node names with a SQL Server 2005 clustered implementation. It affects more than just Database Mail and Maintenance Plans.

If this isn't a reason to use SQL Server 2008, I don't know what is! :)

Consolidation Using SQL Server 2008 Whitepaper Now Posted to MSDN!

by Allan October 23, 2009 10:47

I've been talking about it for awhile, but it's finally here - my update of the old SQL Server 2000 consolidation whitepaper. It just went live less than an hour ago.

The basic info including the link to the download of the Word document can be found here:
http://msdn.microsoft.com/en-us/library/ee692366.aspx

or you can just download the Word doc from http://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/SQLServer2008Consolidation.docx.

I hope you find it useful!

 

2009 PASS Summit Schedule Update

by Allan September 11, 2009 09:56

I just saw that my session "Advanced Failover Clustering Installation Techniques with SQL Server 2008 and Windows Server 2008" will be on Thursday, November 5 from 1 - 2:15 in 3A-B.

I'm just starting to pull the session together and will have as much info as I can cram in 75 minutes with some demos, too :) A heads up: I will be talking about Windows (and some differences between RTM and R2) quite a bit in this one.

I'll also be giving out a copy of my book as well ...

Hope to see some of you there!

Creating a Clustered Distributed Transaction Coordinator (MSDTC/DTC) Using PowerShell - Method #1

by Allan September 02, 2009 11:23

Now that Windows Server 2008 R2 is RTM and the book is done, I can get to some of the things that were impossible to do prior to getting Pro SQL Server 2008 Failover Clustering out the door.

One of the things I was not able to do was document how to create the Microsoft Distributed Transaction Coordinator using PowerShell. It is not hard, but it also isn't the most straightforward task, either. Use the script below to create DTC; all you need to do is change the parameters (self-explanatory) to the right values for your environment.

$clunm = "Windows failover cluster name"
$dtcdisknm = "Name of the disk resource to use with DTC"
$dtcdnsnm = "Name for DTC in DNS"
$dtcgrpnm = "Name of the DTC resource group"
$dtcipaddr = "IP address for DTC"
$dtcsubnet = "Subnet mask for DTC"
$dtcipresnm = "Name of the DTC IP address resource"
$dtcnetnm = "Name of the DTC network name resource"
$dtcresnm = "Name of the DTC resource name"

Add-ClusterGroup $dtcgrpnm -Cluster $clunm
Add-ClusterResource $dtcipresnm -ResourceType "IP Address" -Cluster $clunm -Group $dtcgrpnm
$ipres = Get-ClusterResource $dtcipresnm
$ipaddr = New-Object Microsoft.FailoverClusters.PowerShell.ClusterParameter $ipres,Address,$dtcipaddr
$subnet = New-Object Microsoft.FailoverClusters.PowerShell.ClusterParameter $ipres,Address,$dtcsubnet
$setparams = $ipaddr,$subnet
$setparams | Set-ClusterParameter
Add-ClusterResource $dtcnetnm -ResourceType "Network name" -Cluster $clunm -Group $dtcgrpnm
$nnres = Get-ClusterResource $dtcnetnm
$netnm = New-Object Microsoft.FailoverClusters.PowerShell.ClusterParameter $nnres,Address,$dtcdnsnm
$netnm | Set-ClusterParameter
Add-ClusterResourceDependency $dtcnetnm $dtcipresnm -Cluster $clunm
Add-ClusterResource $dtcresnm -ResourceType "Distributed Transaction Coordinator" -Cluster $clunm -Group $dtcgrpnm
Add-ClusterResourceDependency $dtcresnm $dtcnetnm -Cluster $clunm
Move-ClusterResource $dtcdisknm -Cluster $clunm -Group $dtcgrpnm
Add-ClusterResourceDependency $dtcresnm $dtcdisknm -Cluster $clunm

In my next blog post, I will show you how to map MSDTC to a specific instance of SQL Server since even the current SQL Server 2008 failover clustering whitepaper gets it slightly wrong. Screenshots will be included.

My Complete TechEd Schedule

by Allan April 30, 2009 18:42

Below is my complete schedule for TechEd. I hope to see you at the panel and my session. Feel free to come by also when I'm working the DAT booth.

Monday, May 11
12 - 1PM     Speaker Idol Judge
1 - 2 PM      Panel Discussion - Planning a Windows Deployment for SQL Server 2008 Failover Clustering (with Max Verun from the SQL Server Develeopment Team and Steven Ekren from the Windows Development Clustering Team) - Room 501C
2:30 - 6PM  Answering questions in the Microsoft SQL Server booth

Tuesday, May 12
9:30 - 11:45AM  Answering questions in the Microsoft SQL Server booth
12 - 1PM     Speaker Idol Judge

Wednesday, May 13
12 - 1PM     Speaker Idol Judge
3 - 6PM  Answering questions in the Microsoft SQL Server booth

Thursday, May 14
12 - 1PM     Speaker Idol Judge
1:30 - 4:45PM  Answering questions in the Microsoft SQL Server booth
Evening - Speaker Idol Finals

I'll also probably pick up the bass at some point during the jam session. Had two gigs this past weekend and it'll be odd to go without playing for a week or so. Anyone else remember when they had them nearly every night in the older years of TechEd?

Friday, May 15
10AM - 12PM  Answering questions in the Microsoft SQL Server booth
1 - 2:15PM   DAT322 Tips and Tricks for Successful Database Mirroring Deployments with Microsoft SQL Server - Room 502A

RunAs Radio #106 is Up!

by Allan April 23, 2009 08:36

Enjoy! Click here to listen to it.

Powered by BlogEngine.NET 1.6.0.0
Theme by Mads Kristensen | Modified by Mooglegiant