Provisioning VDBs from MySQL dSources

Virtual Databases (VDB) are virtualized copies of dSource. A VDB can be created using a snapshot on the dSource timeflow.

Prerequisites

• Require a linked dSource with at least 1 snapshot.

• Require a Target environment added to Delphix.

• A MySQL binary with the same version as the source database must be installed on the Target environment.

Provisioning a VDB

1. On the dSource Timeflow, click on the Provision action on the snapshot that you want to use for the VDB as shown below.

2. 

   Select the target host from the dropdown on which VDB needs to be created. If there are multiple MySQL repositories on the host, select the one that matches the source database version. If there are multiple OS users on the host, select the user you want to use.

3. 

   Enter the following values for the target configuration:

   1. DB User This is the database user for the VDB. Delphix will use this user to manage the VDB. User needs to provide the same user account that was used by the staging database.

   2. DB Password Password for the VDB database user.

   3. BaseDir MySQL installation directory. This is the location of /bin/mysql

   4. VDB Port MySQL database port for the VDB. This port should not be used by any other application or MySQL server

   5. VDB Server ID MySQL server id for the VDB. This server-id must be non-zero.

   6. Mount Location This is the mount directory for Delphix VDB on the Target host. This location should be unique and empty.

4. 

   On Configuration screen, add VDB name, select Target Group, check Auto vFiles Restart checkbox and click Next

   

5. On the Policies screen, add any required policies and click Next.

6. If you want to Mask the VDB, select the required configuration on this screen and click Next.

7. On the Hooks screen, add any required Hooks and click Next.

8. Preview the summary and click Submit.

   Once the VDB is created successfully, you can review the datasets on Manage > Datasets > VDB Name. You have now provisioned a MySQL VDB.