Lync Server 2013 Now Supports SQL Server Clustering

In August 2013, Microsoft expanded its support for high-availability solutions in Lync Server 2013. Microsoft now supports SQL Server clustering solutions for Back End Servers. Previously, the only supported solution for Lync Server 2013 Back End Servers was SQL Server mirroring.

If you're new to Lync and hearing about this change for the first time, you might be wondering what all the hoopla is about. But if you've been involved with Lync Server 2013 since its initial release, I hope you're delighted at this change.

What the Hoopla Is All About

Before the change, Microsoft supported only mirroring in SQL Server 2012 and SQL Server 2008 R2 databases in Lync Server 2013 environments. As a result, organizations that already invested a lot of time and financial resources in a SQL Server clustering solution for their Lync Server 2010 or Office Communications Server (OCS) 2007 R2 environment were up in arms. If those organizations wanted to upgrade to Lync Server 2013 and have their back-end high-availability solutions supported, they had to do away with their clustering solutions and implement a mirroring approach. The "subtle" way (and I say "subtle" sarcastically) in which Microsoft delivered the message that Lync Server 2013 didn't support SQL Server clustering was basically telling organizations that they had two options if they wanted to upgrade:

What to Consider Now That Mirroring and Clustering Are Supported

Figure 2: Lync Server 2013 High-Availability Solution Using SQL Server Mirroring

Fortunately, organizations using Lync Server 2013 Back End Servers can now use either SQL Server mirroring or clustering as a supported solution. Before I go any further, I want to point out that this article isn't about the pros and cons of each approach in a Lync Server 2013 environment. Each approach has its benefits. Instead, I'll be discussing what you need to consider after you've decided which approach to use.

Figure 1: Lync Server 2013 High-Availability Solution Using SQL Server Clustering

Figure 1 and Figure 2 illustrate two high-availability topologies that are supported for the back-end SQL Server servers in a Lync Server 2013 pool. In Figure 1, the pool has a two-node active/passive SQL Server cluster. In Figure 2, the pool uses database mirroring. Keep in mind that, in a truly redundant Lync Server 2013 environment, these solutions for the Back End Servers are only part of the high-availability infrastructure.

Here are some items to consider when deploying a SQL Server mirroring or clustering solution in a Lync Server 2013 environment:

Microsoft Listened to Customers' Feedback

Just when you think Microsoft isn't listening to customers' feedback and concerns, it sometimes pleasantly surprises you with good news. This is one of those cases where I'm glad to say that Microsoft was listening. As a Lync consultant and trainer, I often had to deliver the bad news about Lync Server 2013 not supporting clustering for back-end SQL Server servers. Now I can gladly say that mirroring and clustering are supported options. For more information about these options, see TechNet's Database Software Support web page.