Storage Foundation and High Availability 8.0.2 Solutions Microsoft Clustering Solutions Guide for Microsoft SQL Server - Windows

Last Published:
Product(s): InfoScale & Storage Foundation (8.0.2)
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

Configuring InfoScale Storage in an existing Microsoft Failover Cluster

After you have configured an application for high availability, in a Microsoft Failover Cluster, you may want to move the application data from the existing disks to the InfoScale Storage -controlled storage disks. This task involves installing InfoScale Storage on all the cluster systems, converting the already configured basic disks to dynamic disks, and then adding the dynamic disk group resource to the application role.

Notes:

  • You are required to reboot the systems to successfully install InfoScale Storage. Also, you need take the application role offline before you begin to convert the basic disks to dynamic disks. These procedures result in application down-time.

  • For the steps performed using the Failover Cluster Manager, refer to the Microsoft documentation for details. For the steps performed using VEA, refer to the SFW administrator's guide for the details about Disk and Volume tasks.

To configure InfoScale Storage in an existing Microsoft Failover Cluster, perform the following steps:

  1. Install InfoScale Storage on all the cluster systems. You must select the Microsoft Failover Cluster option during the installation.

    Note:

    At the end of the installation process you are required to reboot the system. To ensure less down-time, you can first install InfoScale Storage on the cluster systems other than the one where the application role is online. After you complete the installation on all these systems initiate the installation on the system where the application role is online.

  2. After the cluster systems have restarted, using the Failover Cluster Manager, stop the application role to bring the resources offline.
  3. Check the resource dependencies to note the storage resource dependencies.
  4. Remove the existing basic disk storage resource from the application role.
  5. Remove the basic disk from the available storage.

    This step removes the basic disk resource from the application role and takes the disk offline.

  6. Using VEA, bring the basic disk online.
  7. Create a new clustered dynamic disk group using the basic disk that is brought online in step 6. Before you create a dynamic disk group, ensure that minimum 16MB free space is available in the disk. This space is required to upgrade a basic disk to a dynamic disk.
  8. Using Failover Cluster Manager, move the clustered disk group resource that is created in step 7. You must move this resource from the Available Storage to the Application Role.
  9. Set the resource dependencies as noted in step 3.

    All the earlier storage resource dependencies must now be replaced with the Volume Manager Disk Group resource.

  10. Bring the application role online.