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

Last Published:
Product(s): InfoScale & Storage Foundation (9.0)
Platform: Windows
  1. Introducing SFW solutions for a Microsoft cluster
    1.  
      About Microsoft clustering solutions with SFW
    2.  
      Advantages of using SFW in a Microsoft cluster
    3.  
      About high availability clusters
    4.  
      About campus clusters
    5.  
      About disaster recovery clusters
  2. Planning for deploying SQL Server with SFW in a Microsoft cluster
    1.  
      InfoScale requirements for Microsoft clustering solutions
    2. Planning your SQL Server high availability configuration
      1.  
        Sample high availability configuration for SQL Server with SFW
      2.  
        Configuring the quorum device for high availability
    3. Planning your campus cluster configuration
      1.  
        Microsoft campus cluster failure scenarios
      2. Microsoft cluster quorum and quorum arbitration
        1.  
          Quorum
        2.  
          Cluster ownership of the quorum resource
        3.  
          The vxclus utility
    4. Planning your disaster recovery configuration
      1.  
        Sample disaster recovery configuration for SQL Server with SFW and Volume Replicator
  3. Workflows for deploying SQL Server with SFW in a Microsoft cluster
    1.  
      Workflow for a high availability (HA) configuration
    2. Workflow for a campus cluster configuration
      1.  
        Campus cluster: Connecting the two nodes
    3.  
      Workflow for a disaster recovery configuration
    4.  
      Using the Solutions Configuration Center workflow
    5.  
      Configuring the storage hardware and network
  4. Configuring SFW storage
    1.  
      Tasks for configuring InfoScale Storage
    2. Planning for SFW cluster disk groups and volumes
      1.  
        Sample SQL Server high-availability cluster storage configuration
      2.  
        Sample campus cluster storage configuration
      3.  
        Sample SQL Server disaster recovery storage configuration
    3.  
      Considerations when creating disk groups and volumes for a campus cluster
    4.  
      Considerations when creating volumes for a DR configuration using Volume Replicator replication
    5.  
      Viewing the available disk storage
    6.  
      Creating dynamic cluster disk groups
    7.  
      Adding disks to campus cluster sites
    8.  
      Creating dynamic volumes for high availability clusters
    9.  
      Creating dynamic volumes for campus clusters
  5. Implementing a dynamic mirrored quorum resource
    1.  
      Tasks for implementing a dynamic mirrored quorum resource
    2.  
      Creating a dynamic cluster disk group and a mirrored volume for the quorum resource
    3.  
      Adding a Volume Manager Disk Group resource for the quorum
    4.  
      Changing the quorum resource to a dynamic mirrored quorum resource
  6. Installing SQL Server and configuring resources
    1.  
      Tasks for installing and configuring SQL Server
    2.  
      Creating the resource group for the SQL Server instance
    3.  
      Prerequisites for installing SQL Server
    4.  
      Installing SQL Server in an InfoScale Storage environment
    5.  
      Dependency graph for SQL Server
    6.  
      Verifying the SQL Server group in the Microsoft cluster
  7. Configuring disaster recovery
    1.  
      Tasks for configuring the secondary site for disaster recovery for SQL Server
    2.  
      Verifying the primary site configuration
    3.  
      Creating a parallel environment for SQL Server on the secondary site
    4.  
      Volume Replicator components overview
    5.  
      Setting up security for Volume Replicator
    6.  
      Creating resources for Volume Replicator
    7. Configuring Volume Replicator: Setting up an RDS
      1.  
        Prerequisites for setting up the RDS
      2.  
        Creating a Replicated Data Set (RDS)
    8.  
      Creating the RVG resource
    9.  
      Setting the SQL server resource dependency on the RVG resource
    10. Normal Volume Replicator operations and recovery procedures
      1.  
        Monitoring the status of the replication
      2.  
        Performing planned migration
      3. Replication recovery procedures
        1.  
          Bringing up the application on the secondary host
        2.  
          Restoring the primary host
  8. Appendix A. Configure InfoScale Storage in an existing Microsoft Failover Cluster
    1.  
      Configuring InfoScale Storage in an existing Microsoft Failover Cluster

Creating dynamic cluster disk groups

Create a dynamic cluster disk group with volumes on shared storage so that they can be shared between nodes in the cluster.

Part of the process of creating a dynamic disk group is assigning it a name. Choose a name that is unique to your environment. Make note of this name, as it will be required later.

To create dynamic cluster disk groups, use the Veritas Enterprise Administrator (VEA). The VEA can be invoked on one of the servers and can be used to connect to all the other servers. However, VEA can also be launched on client system and can be used to manage all the servers remotely.

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. After creating the SFW cluster disk groups, corresponding Volume Manager Disk Group (VMDg) resources are added to the cluster, under the available storage. The VMDg resource name corresponds to the cluster disk group name. You can then assign any of these resources to an application service group..

Note:

Dynamic disks belonging to a Microsoft Disk Management Disk Group do not support cluster disk groups.

To create a dynamic (cluster) disk group

  1. Launch Veritas Enterprise Administrator from the Apps menu on the Start screen.

    Select a profile if prompted.

  2. Click Connect to a Host or Domain.
  3. In the Connect dialog box, select the host name from the pull-down menu and click Connect. To connect to the local system, select localhost. Provide the user name, password, and domain if prompted.
  4. To start the New Dynamic Disk Group wizard, expand the tree view under the host node, right click the Disk Groups icon, and select New Dynamic Disk Group from the context menu.
  5. In the Welcome screen of the New Dynamic Disk Group wizard, click Next.
  6. Provide information about the cluster disk group as follows.

    • In the Group name field, enter a name for the disk group (for example, INST1_DG).

      Note:

      A dynamic disk group name is limited to 18 ASCII characters. It cannot contain spaces, slash mark (/), backslash (\), exclamation point (!), angle brackets (< >), or equal sign (=). Also, a period cannot be the first character in the name.

    • Click the checkbox for Create cluster group.

    • Select the appropriate disks in the Available disks list, and use the Add button to move them to the Selected disks list.

    • Optionally, check the Disk names prefix checkbox and enter a disk name prefix to give the disks in the disk group a specific identifier. For example, entering TestGroup as the prefix for a disk group that contains three disks creates TestGroup1, TestGroup2, and TestGroup3 as internal names for the disks in the disk group.

    • Windows Disk Management Compatible Dynamic Disk Group creates a type of disk group that is created by Windows Disk Management (LDM).

    • Click Next.

  7. Click Next to accept the confirmation screen with the selected disks.
  8. Click Finish to create the new disk group.