Azure data factory disaster recovery

How does Azure Data Factory (ADFv2) handle disaster recovery (DR) in the integration runtime? Will it automatically create another integration runtime? Do we have to setup our own DR "Azure-SSIS Integration Runtime"

2 Answers
2

As far as I know, there is no disaster recovery feature available with Integration runtime. If service stops due to any error, you will have to manually restart the service.

You should ideally setup multiple nodes for Integration Runtime. Link below points to section on High Availability and Scalability, with details on setting up multiple nodes (upto 4).

This avoids having a single point of failure and provides higher throughput, as all nodes are setup as active.

https://docs.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime#high-availability-and-scalability

ADF V2 support stopping the SSIS integration runtime in the current region and switch to another region (Paired-region is recommended) to start it again.

To support that,

Then you can follow these steps to switch your IR to the new region and start it again.

Call following command in PowerShell to update the integration runtime

Set-AzureRmDataFactoryV2IntegrationRuntime -Location "new region" `
-CatalogServerEndpoint "SQL Server endpoint" `
-CatalogAdminCredential "credential" `
-VNetId "new VNet" `
-Subnet "new subnet" `
-SetupScriptContainerSasUri "new script SAS Uri"

Set-AzureRmDataFactoryV2IntegrationRuntime -Location "new region" `
-CatalogServerEndpoint "SQL Server endpoint" `
-CatalogAdminCredential "credential" `
-VNetId "new VNet" `
-Subnet "new subnet" `
-SetupScriptContainerSasUri "new script SAS Uri"

Start the IR again.

About how to use PowerShell command, please refer to Create the Azure-SSIS integration runtime in Azure Data Factory for more details.

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.