This topic describes how to add a SQL Server Failover Cluster target environment to the Delphix Engine.

Adding a Failover Cluster target environment will discover SQL Server Failover Cluster instances that are running. You can then provision VDBs to these Failover Cluster instances.

Prerequisites

The following hotfix is required for Windows 2008 R2 Cluster nodes:

"0x80070490 Element Not found" error when you enumerate a cluster disk resource by using the WMI MSCluster_Disk class query in a Windows Server 2008 R2-based failover cluster

http://support.microsoft.com/kb/2720218


Failover Cluster target environments cannot be used as staging environments.

Supported Operating System and SQL Server Versions for Cluster Target Environments

Supported Operating System Versions
Windows 2008 R2

Windows 2012

Windows 2012 R2
Supported SQL Server Versions
SQL Server 2008 (10.0)
SQL Server 2008 R2 (10.5)
SQL Server 2012 (11.0)
SQL Server 2014 (12.0)

Procedure

  1. Click Manage.
  2. Select Environments.
  3. Next to Environments, click the green Plus icon.
  4. In the Add Environment dialog, select Windows in the operating system menu.
  5. Select Target.
  6. Select Cluster.
  7. Specify the cluster address of the Windows Failover Cluster.
  8. Select a host which is NOT a node in the cluster as the Connector Environment.
  9. Enter the Username and Password for the target environment.
  10. Click Validate Credentials.
  11. Click OK.
  12. Click Yes to confirm the target environment addition request.
    In the Delphix Engine interface, you will see a new icon for the Target environment, and two jobs running in the Delphix Admin Job History, one to Create and Discover an environment, and another to Create an environment. When the jobs are complete, click the icon for the new environment, and you will see the details for the environment.

Example Environment

 

In this example environment, the Delphix Connector was installed on Connector EnvironmentCluster Node 1, and Cluster Node 2. Each host was added to Delphix as standalone target environments. Next, the Windows Failover Cluster was added as a Windows Target Cluster environment using the cluster address. Cluster Node 1 is currently the active node for the SQL Server Failover Cluster resource group. Delphix has exported iSCSI LUs and has created the corresponding Cluster Disk resources for each VDB.

Related Links