Provisioning a MySQL VDB in DCT

Once a dSource is created and snapshots are available, you can provision a MySQL virtual database (VDB) from any available snapshot or point in time.

Procedure

1. On the left navigation pane, expand Data Management and click VDBs.

2. Click the Actions button in the top-right corner and select Provision VDB from the drop down menu.

3. On the Source page, select the dSource from which you want to provision the VDB (for example, mysql-dsource). The right panel displays the source details, including Name, AppData Connector Version, Engine, Group, Timezone, Repository, and Environment. Click Next.

4. On the Provision Point page, select the snapshot or point in time from which to provision the VDB. The timeline displays available snapshots grouped by date. Select the desired snapshot and click Next.

5. On the Target Environment page, select the environment where the VDB will be provisioned (for example, MySQL Staging Env). Then configure the following:

   • User: Select the OS user (for example, mysql).

   • Instance Select the MySQL instance (for example, mysql_vFiles (20.0)).

6. Click Next.

7. On the Target Configuration page, enter the following details:

   1. VDB Name: A name for the VDB (for example, VDB-MySQL).

   2. NFS Mount Location: The mount location on the target host. No spaces allowed (for example, /mnt/VDBPG).

   3. Privileged OS Account (Optional): A privileged Unix username if required; leave blank if privilege elevation is not needed.

   4. Virtual MySQL Port Number: The port number for the target MySQL database (for example, 5435).

8. (Optional) Click + Add to configure VDB Point-in-Time (PIT) recovery with external logs.

9. (Optional) Click + Add to add custom database-level config settings.

10. Enter a tag key and value and click + Tag to add tags.

11. Click Next.

12. On the Policies page, review the default policies:

    • Snapshot Policy: Defaults to DCT Default Snapshot (daily at 03:30 AM GMT). Click Change Policy to modify.

    • Retention Policy: Defaults to DCT Default Retention (snapshots and logs removed after 1 week).

    • Click Change Policy to modify.

    • Click Next.

13. (Optional) On the Masking page, enable Mask this VDB to apply data masking during provisioning. Leave unchecked if masking is not required. Click Next.

14. (Optional) On the Hooks page, optionally add hook scripts at the following hook points:

    1. Configure Clone

    2. Pre Refresh / Post Refresh

    3. Pre Self-Refresh (Rollback) / Post Self-Refresh (Rollback)

    4. Pre Snapshot / Post Snapshot

    5. Pre Start / Post Start

15. Click + Hook to add a script. If no hooks are needed, click Next.

16. On the Summary page, review all configuration details including Source, Target, Policies, Masking, and Settings and click Submit.

17. After submission, the VDBs page displays the newly provisioned VDB (for example, VDB-MySQL) with a status of Running, platform mysql-vsdk, and engine MySQL Engine.

18. Click View to confirm that the status is RUNNING.