VDB Creation

This topic describes the basic concepts involved with provisioning VDBs from CockroachDB dSources using CRDB plugin.

A dSource is a virtualized representation of source database. As a virtual representation, it cannot be accessed or manipulated using database tools. Instead, you must create a virtual database (VDB) from a dSource snapshot. A VDB is an independent, writable copy of a dSource snapshot. You can also create VDBs from other VDBs. Once you have provisioned a VDB to a target environment, you can also implement snapshot and retention policies for the VDB, which will determine how frequently Delphix Engine will take a database snapshot and how long the snapshots will be retained for recovery and provisioning purposes.

Snapshots accumulate over time. To view a snapshot:

1. From the Datasets panel, click the group containing the dSource.
2. Select dSource.
3. Click the TimeFlow tab.

The TimeFlow appears as a list of dates, each of which expands to show snapshots from that date. Times, when the VDB has been refreshed, are marked by a blue line between dates.

On the TimeFlow, you can also filter by type of snapshot. To do so, click the filter button, which is shaped like an eye.

You can scroll through these lists to select the a specific snapshot.

Once you have provisioned a VDB, you can also take snapshots of it. As with the dSource snapshots, you can find these when you select the VDB in the Datasets panel. You can then provision additional VDBs from these VDB snapshots.

Dependencies

If there are dependencies on the snapshot, you will not be able to delete the snapshot free space; the dependencies rely on the data associated with the snapshot.

Provisioning VDB

This topic describes how to provision a virtual database (VDB) from a CockroachDB dSource using CRDB plugin.

Prerequisites

• Install delphix engine compatible with the CRDB plugin version as per support matrix
• Install CockroachDB binaries on staging host.
• Execute Discovery on staging host.
• Create dSource on staging host.
• Add target environments to Delphix engine.

Create VDB

Steps:

1. Login to the Delphix Management application.
2. Click Manage.
3. Select Datasets.
4. Select a dSource.
5. Select a snapshot from which you want to provision.
6. Click Provision VDB icon to open Provision VDB wizard.
7. Select a target environment from the left pane.
8. Select an Installation to use from the dropdown list of available CockroachDB repositories on that environment.
9. Select the Environment User.
10. Enter VDB specific parameters for creating virtual copy of CockroachDB target cluster on target host.
11. Select a Target Group for the VDB.
12. Click the Add Dataset Group icon to add a new group, if necessary.
13. Select a Snapshot Policy for the VDB.
14. Click Next.
15. Select the masking option if you wish to mask this VDB.
16. Click Next.
17. Specify any desired hook operations.
18. Click Next.
19. Review the Provisioning Configuration and Data Management information.
20. Click Submit.

When provisioning starts, you can review the progress of the job in the Databases panel, or in the Job History panel of the Dashboard.

When provisioning is complete, the VDB will be included in the group you designated and listed in the Databases panel.

If you select the VDB in the Databases panel and click the Configurations -> Custom section, you can view the details of VDB configuration that was selected during it’s setup.