VCS Replicated Data Cluster configuration
You can install and configure a new Veritas Storage Foundation HA environment for SQL Server in a Replicated Data Cluster configuration.
The configuration process for a Replicated Data Cluster configuration has the following three main stages:
■ Configure the SFW HA and SQL Server components for high availability on the primary zone nodes.
■ Install and configure SFW HA and SQL Server components on the secondary zone.
■ Configure the VVR components for both zones.
Refer to the Veritas Volume Replicator Administrator’s Guide for additional details on VVR.
Table 4-5 outlines the high-level objectives and the tasks to complete each objective for a Replicated Data Cluster configuration for SQL.
Table 4-5 Process for deploying a Replicated Data Cluster
Action Description
Verify hardware and software prerequisites
See “Reviewing the requirements” on page 84.
Understand the configuration ■ Understand active/passive configuration and zone failover in a RDC environment
■ Review the sample configuration
See “About a replicated data cluster” on page 22.
See “How VCS replicated data clusters work” on page 24.
See “Reviewing the Replicated Data Cluster configuration” on page 109.
See “About setting up a Replicated Data Cluster configuration” on page 111.
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 SQL will be installed
See “Configuring the storage hardware and network”
on page 122
72 Configuration workflows for SQL Server VCS Replicated Data Cluster configuration
Install SFW HA ■ Verify the driver signing option for the system
■ Install Veritas Storage Foundation for Windows HA on all nodes that will become part of the cluster
■ During installation select the option to install VVR; this will also automatically install the Veritas Cluster Server Agent for VVR
■ If you plan to configure a disaster recovery site in addition to configuring RDC, install the Global Cluster Option (GCO)
■ Selecting the option to install Veritas Cluster Server Database Agent for Microsoft SQL Server See “Installing Veritas Storage Foundation HA for Windows” on page 124.
Configure the cluster ■ Verify static IP addresses and name resolution configured for each node
■ Configure cluster components using the Veritas Cluster Server Configuration Wizard
■ Set up secure communication for the cluster See “Configuring the cluster” on page 147.
Configure cluster disk groups and volumes for SQL Server
■ Create dynamic cluster disk groups using the Veritas Enterprise Administrator (VEA)
■ Create dynamic volumes for the SQL system database, registry replication, user databases and transaction logs using the VEA
See “Configuring cluster disk groups and volumes for SQL Server” on page 130.
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 “Installing and configuring SQL Server 2008 or SQL Server 2008 R2 on the first cluster node” on page 165.
Table 4-5 Process for deploying a Replicated Data Cluster (Continued)
Action Description
73 Configuration workflows for SQL Server VCS Replicated Data Cluster configuration
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 “Installing SQL Server on the second cluster node” on page 167.
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” on page 169.
Create a SQL Server service group
■ Ensure that you have met the prerequisites
■ Create a SQL Server service group using the VCS SQL Server 2008 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 VCS SQL Server service group” on page 172.
Create the primary system zone ■ Create the primary system zone
■ Add the nodes to the primary zone
See “Creating the primary system zone” on page 202.
Verify failover within the primary zone
■ See “Verifying the SQL Server cluster configuration” on page 183.
Create a parallel environment in the secondary zone
■ Install SFW HA on the systems in the secondary zone
■ Configure disk groups and volumes using the same names as on the primary zone
■ Install SQL Server following the prerequisites and guidelines for installing on the second zone.
See “Creating a parallel environment in the secondary zone” on page 203.
Add the secondary zone systems to the cluster
Add the secondary zone systems to the cluster.
See “Adding the systems in the secondary zone to the cluster” on page 204.
Table 4-5 Process for deploying a Replicated Data Cluster (Continued)
Action Description
74 Configuration workflows for SQL Server VCS Replicated Data Cluster configuration
Set up security for VVR on all cluster nodes
Set up security for VVR on all nodes in both zones.
This step can be done at any time after installing SFW HA on all cluster nodes, but must be done before configuring VVR replication.
See “Setting up security for VVR” on page 210.
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)” on page 213.
Configure a hybrid RVG service group
■ Create a hybrid Replicated Volume Group (RVG) service group
■ Configure the hybrid RVG service group See “Configuring a hybrid RVG service group for replication” on page 225.
Set a dependency between the service groups
Set up a dependency from the VVR RVG service group to the SQL Server service group
See “Setting a dependency between the service groups” on page 240.
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” on page 241.
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” on page 247.
Table 4-5 Process for deploying a Replicated Data Cluster (Continued)
Action Description
75 Configuration workflows for SQL Server