Your Browser is Out of Date

ShareDemos uses technology that works best in other browsers.
For a full experience use one of the browsers below
Deployment Guide—VMware vSphere and Red Hat Enterprise Linux for High-Performance Database Applications

close

view all chapters

XtremIO Virtual Copy Database Environment Setup
Overview of XVC database environment setup Configuring XtremIO storage in the XVC database environment LAN and SAN connectivity in the XVC database environment Configuring the XVC database server Taking XVC snapshots of the PROD database Creating a snapshot database on the XVC server

Taking XVC snapshots of the PROD database

Taking XVC snapshots of the PROD database

  • To take XVC snapshots of the PROD database, follow the procedures in this section to:

    1. Create a consistency group of PROD database volumes.
    1. Take a snapshot of the consistency group.
    2. Map the consistency group to the XVC server.

    Creating a consistency group

    To maintain consistency among the database files when taking the XVC snapshot of the production database, put all database volumes into one consistency group as follows:

    1. Log in to the XtremIO management console.
    1. From the management console, click the Configuration tab, click Consistency Groups, and then click the New(+) icon.
    2. In the New Consistency Group window:
      1. Enter a consistency group name.
      2. Select all the source (PROD) database volumes where the database files are stored, as shown in the following figure:

    Figure 21.     Specifying source database volumes

    1. Click Apply.

    Within a few seconds, the consistency group (CG_PROD in this instance) is created:

    3_CG

    Figure 22.     New consistency group

    Taking a snapshot of the consistency group

    Follow these steps to create a snapshot of the consistency group that you created in the previous section:

    1. To create an XVC snapshot of the PROD database volumes, create a repurpose copy of the consistency group that contains the PROD database volumes:
      1. Select the PROD database consistency group (CG_PROD in this instance) and click the Repurpose icon.
      2. In the Create Repurpose Copy window, specify the new Consistency Group Name (for example, CG_DEV for the DEV_XVC database), and click Apply.

    The repurpose copy (CG_DEV) of CG_PROD is created instantly. CG_DEV itself is a consistency group that consists of seven snapshot volumes of the corresponding seven PROD database volumes, as shown in the following figure:

    C:\work\work\projects\2018\projects\Q2\deployment_guild\materials\snapshot_2\6_CG_COPY.PNG

    Figure 23.     Snapshot (repurpose copy) of consistency group

    To map the consistency group to the XVC server:

    1. Select the snapshot consistency group CG_DEV and click the Mapping icon on the menu bar.
    1. Select the Initiator Groups (R740-HBAs in this instance) that contain the XVC database server initiators and click Next.

    The Mapping Confirmation window is displayed.

    1. Click Apply to create the mapping and verify that the following mapping is established:

    12_mapping

    Figure 24.     Consistency group mapping

    1. Repeat the steps in Taking a snapshot of the consistency group and Mapping the consistency group to the XVC server for the second snapshot database OLAP XVC.