Workflow for a high availability (HA) configuration


Workflow for a high availability (HA) configuration
Prev	Workflows for deploying SQL Server with SFW in a Microsoft cluster	Next

You can install and configure InfoScale Storage and SQL Server in a Microsoft cluster for high availability on a single site.

Table: Process for deploying SQL Server with InfoScale Storage in a Microsoft high-availability cluster

Action

Description

Understand the configuration

See Planning your SQL Server high availability configuration.

Configure the storage hardware and network

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.

Establish a Microsoft cluster

Establish the cluster before installing InfoScale Storage.

Install InfoScale Storage with the Microsoft Failover Cluster option

Refer to the Veritas InfoScale Installation and Upgrade Guide.

Configure and manage disk groups and volumes

Use the VEA console to create disk groups and volumes for the application and for the quorum resource.

See Tasks for configuring InfoScale Storage.

Note:

Setting up a Microsoft failover cluster creates physical disk resources for all the basic disks on the shared bus. To use these disks when you create your SFW cluster disk groups, you must first remove the physical disk resources from the cluster. Otherwise, a reservation conflict occurs.

Implement a dynamic mirrored quorum resource

Create a dynamic cluster disk group with a mirrored volume for the quorum disks.
Verify that a Volume Manager Disk Group (VMDG) resource is created for the quorum disk group.

See Tasks for implementing a dynamic mirrored quorum resource.

Create the SQL virtual server resource group

Create a SQL Server resource group in the cluster.
Add the VMDG disk group resource(s).

See Creating the resource group for the SQL Server instance.

Install SQL Server

Mount the disk group and volumes created for the data files on the node where you install.
Install the software. Ensure that you install the data files to the path of the dynamic volume on shared storage.

See Installing SQL Server in an InfoScale Storage environment.
Verify the resource dependencies.

See Dependency graph for SQL Server.

Verify the cluster configuration

Move the online SQL Server cluster group to the second node and back to the first node.

See Verifying the SQL Server group in the Microsoft cluster.