Edit

Share via

Scale Out support for high availability via SQL Server failover cluster instance

  • Article

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

To set up high availability on the Scale Out Master side with SQL Server failover cluster instance, do the following things:

1. Prerequisites

Set up a Windows failover cluster. See the blog post Installing the Failover Cluster Feature and Tools for Windows Server 2012 for instructions. Install the feature and tools on all cluster nodes.

2. Install SQL Server failover cluster

Install a SQL Server failover cluster. See SQL Server Failover Cluster Installation for instructions. During the installation, select Database Engine Services on Feature Selection page. Log the SQL Server network name for future configuration.

SQL network name

Add secondary node to the SQL Server failover cluster.

3. Install Scale Out Master on the primary node

Install Integration Services and Scale Out Master on the primary node with the setup wizard for nonclustered installation.

During installation, include the SQL Server network name in the CNs of the Scale Out Master certificate.

Note

If you want to failover SSISDB and Scale Out Master service separately, follow 2. Install Scale Out Master on the primary node for Scale Out Master configuration.

4. Install Scale Out Master on the secondary node

Follow 3. Install Scale Out Master on the secondary node

5. Update the Scale Out Master service configuration file

Update the Scale Out Master service configuration file, <drive>:\Program Files\Microsoft SQL Server\140\DTS\Binn\MasterSettings.config, on the primary and secondary nodes. Update SqlServerName to [SQL Server network name]//[Instance name] or [SQL Server network name] for default instance.

6. Add Scale Out Master service to SQL Server role in Windows failover cluster

In Failover Cluster Manager, connect to the cluster for Scale Out. Select Roles in the explorer, right-click the SQL Server role, and select Add Resource, Generic Service.

Generic service

In the New Resource Wizard, select Scale Out Master service and finish the wizard.

Bring the Scale Out Master service online.

Bring online

Note

If you want to failover SSISDB and Scale Out Master service separately, follow 7. Configure the Scale Out Master service role of the Windows failover cluster

7. Install Scale Out Workers

Install Scale Out Worker on worker nodes. During the installation, specify https://[Sql Server network name]:[master port] for master endpoint.

Note

If you want to failover SSISDB and Scale Out Master service separately, specify Scale Out Master service DNS host name instead of Sql Server network name.

8. Install Scale Out Worker client certificate

Install the worker certificate on all nodes in the SQL Server failover cluster. See Install Scale Out Worker client certificate.

Note

Scale Out Manager has not supported SQL Server failover cluster. If you use Scale Out Manager to add Scale Out Worker, you still need to install worker certificate to all master nodes manually.

Next steps

For more info, see the following articles: