A cluster refers to a group of interconnected computers or servers that work together to perform computing tasks as a single cohesive unit. The goal of clustering is to enhance the availability, reliability, and scalability of a system by distributing the workload across multiple machines.
Active-Active configuration is a high-availability setup in which multiple nodes or servers are actively participating in serving requests or processing tasks simultaneously. In this configuration, all nodes are actively engaged in handling a portion of the workload concurrently, distributing the traffic or workload across them. This is in contrast to an Active-Passive configuration where only one node is actively serving traffic while others remain on standby as backups.
In an Active-Passive configuration, multiple nodes or servers are set up in a way that only one node, the “active” node, actively handles incoming requests or processes tasks at any given time. The other nodes, known as “passive” nodes, remain on standby and do not actively participate in serving the workload. The passive nodes are essentially in a hot standby state, ready to take over if the active node fails or if a failover event is triggered.
Installing the SSIS PowerPack in an Active-Active configuration involves configuring SQL Server Integration Services to support high availability, and then installing the SSIS PowerPack on each node of the cluster.
During installation, ensure that you configure the installer to recognize the clustered environment. Provide the necessary details about the SQL Server instance and cluster configuration and if you have a valid license, activate the license key
Complete the installation on the first node. Repeat the installation process on each additional node of the cluster. Ensure that you provide the same configuration details for each installation. (Each license is per node)
The last step is to test your SSIS packages to ensure that they run successfully in the clustered environment. Simulate failovers or monitor failovers to ensure that SSIS PowerPack continues to function seamlessly during failover events.
Installing SSIS PowerPack in an Active-Passive configuration involves configuring SQL Server Integration Services (SSIS) to support high availability and then installing the SSIS PowerPack on both the active and passive nodes. Here are the general steps:
Set up a SQL Server Failover Cluster if not already configured. This involves configuring shared storage, IP addresses, and installing SQL Server in a failover cluster instance. Install SQL Server Data Tools (SSDT) and SQL Server Integration Services (SSIS) on the cluster. Configure SSIS to work in the clustered environment.
Run the SSIS PowerPack installer on the active node of the cluster. Follow the installation wizard, accept the license agreement, and specify installation options
During installation, ensure that you configure the installer to recognize the clustered environment. Provide the necessary details about the SQL Server instance and cluster configuration. Complete the installation on the active node
Copy the SSIS PowerPack installer to the passive node. Run the installer on the passive node using the same configuration details used on the active node.
Test your SSIS packages to ensure they run successfully on both nodes. Simulate failovers or monitor failovers to ensure that SSIS PowerPack continues to function seamlessly during failover events.