Provisioning a MySQL VDB

Perform the following steps to provision a MySQL VDB.

1. Login to the Delphix Management application.

2. Navigate to the Manage > Datasets page and select a dSource or VDB dataset.

3. Under the Timeflow tab, identify a snapshot, hover over it, and select the Provision a VDB button.

   

4. On the Target Environment page, perform the following actions:

   • From the Environment dropdown list, select a compatible target environment. This will dynamically populate the other properties.

   • From the Installation dropdown list, select the specific MySQL instances that you want to use.

     • The VDB target environment’s MySQL version should be the same as the dSource environment’s MySQL version. Otherwise, you will receive an error message. Refer to the Troubleshooting section for more information.

   • From the User dropdown list, select the environment user that matches the MySQL Instance Owner as configured in the prerequisites.

     

5. On the Target Configuration page, fill in the following values:

   • DB User: This is the database user for the VDB. Delphix Continuous Data Engine will manage the VDB using this user. You must provide the same user account used by the staging database.

   • DB Password: This is the password for the VDB database user.

   • BaseDir: This is for the MySQL installation directory. 

   • VDB Port: Port number to be used by the VDB. This port should not be used by any other application or MySQL server.

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

   • Mount Location: This is the mount directory for Delphix VDB on the Target host. This location should be unique and empty. On Linux and Unix hosts, this mount path must be the full path and not include symlinks.

   • (Optional) my.cnf Config Settings: This allows users to specify MySQL configuration properties while creating a VDB. 

     

MySQL plugin does not allow VDBs to inherit configuration properties from their parent dsource.

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

   

7. (Optional) On the Policies page, select a previously defined VDB Snapshot Policy or the Use group policy checkbox.

8. (Optional) On the Masking page, enable the Mask this VDB checkbox to mask the database following a successful provision. 

   • This feature may be disabled or unavailable if the chosen snapshot is already masked or the Delphix Continuous Compliance Engine is disconnected.

9. (Optional) On the Hooks page, select a Hook Point and then click the plus button (+) to add a script that you want to run. You have the flexibility to define scripts to run at multiple hook points in the process.

10. In the Summary tab, review the configuration profile for your VDB.

11. Click Submit.

Once the VDB is created successfully, you can review the datasets on the Manage > Datasets screen in the left-hand panel. You have now provisioned a MySQL VDB. You can connect a running application and share it with your end users. Connection information can be found in the VDB’s Configuration Custom tab and within its target environment’s database.

Updating custom configuration properties

MySQL connector UI allows you to add/update/delete custom configuration properties after provisioning a VDB. Go to Configuration > Custom and click the pencil icon to edit the fields. You can update parameters under my.cnf Config Settings section, as shown in the picture.