Search <book_title>...

InfoScale™ 9.0 Storage Foundation and High Availability Solutions HA and DR Solutions Guide for Microsoft SQL Server - Windows

Last Published: 2025-04-13

Product(s): InfoScale & Storage Foundation (9.0)

Platform: Windows

VCS Replicated Data Cluster configuration

The configuration process for a Replicated Data Cluster configuration includes the following main stages:

Configure the SFW HA and the application components for high availability on the primary zone nodes.
Install InfoScale Enterprise and configure SFW HA and the application components on the secondary zone.
Configure the Volume Replicator components for both zones.
Refer to the Volume Replicator Administrator's Guide for additional details on Volume Replicator.

The following table outlines the high-level tasks to complete each objective for a Replicated Data Cluster configuration for your application.

Table: Process for deploying a Replicated Data Cluster

Action	Description
Understand the configuration	Understand active-passive configuration and zone failover in a RDC environment Review the sample configuration See Reviewing the Replicated Data Cluster configuration.
Configure the storage hardware and network	For all nodes in the cluster: Set up the storage hardware for a cluster environment Verify the DNS entries for the systems on which the application will be installed See Configuring the storage hardware and network.
Review pre-requisites and install InfoScale Enterprise	Install InfoScale Enterprise on all the systems where you want to configure SQL for high availability. Refer to Arctera InfoScale™ Installation and Upgrade Guide.
Review application-specific requirements	See Notes and recommendations for cluster and application configuration.
Configure cluster disk groups and volumes for SQL Server	Create dynamic cluster disk groups using the Veritas Enterprise Administrator (VEA) (if using a shared storage configuration) Create dynamic disk groups using VEA (for a single-node configuration using non-shared storage) Create dynamic volumes for the SQL system database, registry replication, user databases and transaction logs using the VEA See Configuring disk groups and volumes for SQL Server.
Configure the cluster	Verify static IP addresses and name resolution configured for each node Run the VCS Cluster Configuration Wizard (VCW) to configure cluster components and set up secure communication in the cluster See Configuring the cluster using the Cluster Configuration Wizard.
Install and configure SQL Server on the first cluster node	Ensure that the disk group and volumes for the system database are mounted on the first node Follow the guidelines for installing SQL Server in the SFW HA environment See About installing and configuring SQL Server.
Install and configure SQL Server on the failover node(s) of the primary zone	Stop SQL Server services on the first node Follow the guidelines for installing SQL Server on failover nodes in the SFW HA environment See About installing SQL Server on additional systems.
Create a SQL Server user-defined database	If not done earlier, create volumes for a user-defined database and transaction log Create a new user-defined database in SQL Server See Creating a SQL Server user-defined database.
Create a SQL Server service group	Ensure that you have met the prerequisites Create the application service group manually using templates from the Cluster Manager (Java Console) (if using a non-shared storage configuration) Create a SQL Server service group using the SQL Server Configuration Wizard Bring the service group online on the node where you ran the wizard to configure the service group. This is first cluster node where you installed SQL Server. See About configuring the SQL Server service group.
Create the primary system zone	Create the primary system zone Add the nodes to the primary zone See Creating the primary system zone for the application service group.
Verify failover within the primary zone	Test failover between the nodes in the primary zone See Verifying the SQL Server cluster configuration.
Create a parallel environment in the secondary zone	Install InfoScale Enterprise on the systems in the secondary zone Configure disk groups and volumes using the same names as on the primary zone Install your application following the prerequisites and guidelines for installing on the second zone. See Creating a parallel environment in the secondary zone.
Add the secondary zone systems to the cluster	Add the secondary zone systems to the cluster. See Adding nodes to a cluster.
Set up security for Volume Replicator on all cluster nodes	Set up security for Volume Replicator on all nodes in both zones. This step can be done at any time after installing InfoScale Enterprise on all cluster nodes, but must be done before configuring Volume Replicator replication. See Setting up security for Volume Replicator.
Set up the Replicated Data Set	Use the Setup Replicated Data Set Wizard to create RDS and start replication for the primary and secondary zones See Setting up the Replicated Data Sets (RDS).
Configure a RVG service group	Create a Replicated Volume Group (RVG) service group Configure the RVG service group See Configuring a RVG service group for replication.
Set a dependency between the service groups	Set up a dependency from the Volume Replicator RVG service group to the SQL Server service group See Setting a dependency between the service groups.
Add the nodes from the secondary zone to the RDC	Add the nodes from the secondary zone to the RVG service group Configure the IP resources for failover Add the nodes from the secondary zone to the SQL Server service group See Adding the nodes from the secondary zone to the RDC.
Verify the RDC configuration	Verify that failover occurs first within zones and then from the primary to the secondary zone See Verifying the RDC configuration.