Creating a dSource with ingestion type GCP

The following procedure provides details on creating a dSource with AWS S3 ingestion type. 

Prerequisites 

• The source and staging instances must meet the host requirements as described in Requirements for CockroachDB Staging/Target hosts. 

• The accessibility of the backup location within the AWS S3 bucket from the Staging host must be verified prior to ingestion. 

Creating dSource 

1. Login to Delphix Management application. 

2. Click Manage > Datasets. 

3. Click on Add dSource.

   

4. In the Add dSource wizard, select the CockroachDB source config you just created on the staging host.

   

    

5. Select the dSource type from the drop-down available on dSource wizard. Refer different dSource Types 

6. Enter the CockroachDB specific parameters for your dSource configuration. 

   1. dSource Type: Type of dSource 

   2. dSource (GCP) details: 

      1. Mount Path The path on the host where Delphix will mount the dSource files via NFS 

      2. IP Address / Hostname of the Staging Cluster IP Address / Hostname of the interface for the staging Cluster (default 127.0.0.1) 

      3. Staging CockroachDB Port Number Staging DB port for cluster’s inter-node communication 

      4. Staging CockroachDB Console Port Number Staging Console port for HTTP requests 

      5. CockroachDB Backup’s Subdirectory Path CockroachDB Backup’s Subdirectory Absolute Path where backups are located in GCP Bucket 

      6. CockroachDB Backup’s Bucket or Container Name Storage bucket or container name including absolute path where CockroachDB backups are located 

      7. Authentication Option for GCP Buckets 

         1. Specified Authentication Need to specify GCP credentials in dSource configuration fields:

            1. Encoded JSON Object Key Specify JSON encoded key associated with object storage holding CockroachDB backups

         2. Implicit Authentication Store GCP credentials in JSON file on the staging host. 

            1. For using implicit authentication with GCP bucket, create a service account corresponding to the bucket. 

            2. Download the service account key for the service account using google could console. 

            3. Location of JSON Credential File Specify path of json file containing the key. 

      8. Skip Checking Localities Select the checkbox to skip checking the localities of a cluster before a restore. 

      9. Secure Mode Option to run the CockroachDB server in secure mode 

      10. Certificate directory path The absolute path to the certificate directory, it must have valid certificates containing the IP address or hostname for the CockroachDB server 

      11. CockroachDB Cluster Node Count Number of nodes that consists of a Staging CockroachDB cluster. Minimum: 3 and Maximum: 9 

      12. CockroachDB Parameters Additional CockroachDB configuration parameters to start the CockroachDB cluster.

          1. Parameter Name CockroachDB Cluster configuration parameter name 

          2. Parameter Value CockroachDB Cluster configuration parameter value 

      13. Additional Nodes: Specify the node configuration for each node the CRDB cluster.  

          1. Environment Select environment on which node has to be created. 

          2. Environment User Select environment user corresponding to the environment. 

          3. IP Address / Hostname IP Address / Hostname of the interface for the staging node(default 0.0.0.0) 

          4. CockroachDB Port Number Staging DB port for node’s inter-node communication 

          5. CockroachDB Console Port Number Staging Console port for HTTP requests 

          6. Certificate directory path The absolute path to the certificate directory, it must have valid certificates containing the IP address or hostname for the CockroachDB server 

          7. Append cluster CRDB parameters Check with box if the cluster configuration parameters are applicable for the node. 

          8. Additional Node Configuration Parameters Additional CockroachDB configuration parameters to start the node 

      14. Then click Next to proceed further. 

7. Provide the details for dSource Name and Target group on the dSource configuration page and click Next. 

8. On the Data management page, select the following and click Next.

9. Staging Environment: This will be your staging host where source config was created.

   1. User: Database OS user with required privileges for linking the dataset. 

   2. On the next screens, configure a policy, hooks, and review the configuration, then click on Next button to view the summary.

10. Click the Submit button which will initiate the linking process 

11. Once dSource is created successfully, you can review the datasets on Manage > Datasets > dSource Name. 

• You must specify the input “Certificate directory path” when “Secure Mode” option is selected. 

• For more detailed guidance on CockroachDB certificate generation, refer to the official documentation: CockroachDB Certificate Generation.