CockroachDB virtualization process

This topic serves as a quick guide that will walk you through your first implementation of the CockroachDB Connector, providing high-level steps. Each step briefly describes the task and the expected result. Refer to the documentation links for more detailed information. 

1. Begin by reviewing the general Delphix Continuous Data architecture diagrams Identify existing or new CockroachDB source, staging, and target environments, the underlying Operating Systems, and CockroachDB database versions. This will give you a good understanding of the architectural strategy and confirm support. 

2. Review the CockroachDB Support Matrices Confirm that all system requirements are supported by the CockroachDB plugin, such as Continuous Data Engine, staging/target environment Operating Systems, and CockroachDB database versions. This will ensure that there are not any unexpected issues later.

3. Deploy and configure Delphix Continuous Data.

4. Install the CockroachDB plugin The CockroachDB plugin establishes the connection between the Delphix Continuous Data Engine and the plugin version. It is recommended to stay up-to-date with the latest version.

5. Create staging and target environments The staging environment will be a replica of the source environment that Delphix Continuous Data Engine will use to stay in sync. The target environment will provide the infrastructure to generate virtual database copies.

   1. Consult the source environment and staging/target environments requirements documentation for configuration details.

6. Discover Staging and Target Environments To enable the Delphix Continuous Data Engine to recognize the provided infrastructure, search for CockroachDB installation, and then make it available for database linking and provisioning. 

7. Linking the CockroachDB database This configures a dSource which enables the syncing mechanism between the source database, staging database, and Delphix Continuous Data Engine. There are many ingestion methods that differ between plugins and solve different requirements. Therefore, we encourage you to identify the ingestion method that best suits your organization and infrastructure policies.

8. Provision virtual CockroachDB databases Administrators and self-service users have the capability to provision an unlimited number of copies for their virtual databases.

Congratulations on successfully creating a virtual database using the Delphix Continuous Data Engine and the CockroachDB plugin! With the basics understood, we encourage you to learn about our more advanced features such as the Seed, AWS S3 and Disk ingestion methodology or our developer’s APIs and CLIs.