CockroachDB provision operations

To create a VDB via CLI, you must first create a dSource. For more information on creating a dSource, refer to Link operation via CLI section.

To create a VDB and perform operations via CLI, login to the Delphix Continuous Data Engine using the admin user account.

CODE

ssh admin@<CONTINUOUS-DATA-FQDN-or-IP>

Provision

Run the below commands to provision a VDB. The below example uses dlpxstg-s3 dSource.

CODE

Example - 
database provision
set type=AppDataProvisionParameters
set container.name=dlpxtgt-s3
set container.group=cockroach
set sourceConfig.repository=APPDATA_REPOSITORY-9
set timeflowPointParameters.type=TimeflowPointSnapshot
set timeflowPointParameters.snapshot=APPDATA_SNAPSHOT-3
set sourceConfig.name=dlpxstg-s3
set source.allowAutoVDBRestartOnHostReboot=false
set source.parameters="{\"mount_path\":\"/mnt/provision/dlpxtgt-s3\",
\"ip_addr\":\"10.43.35.72\",\"cockroach_port\":26257,
\"cockroach_db_console_port\":8080,\"cockroach_cluster_name\":\"dlpxtgt-s3\",
\"enable_secure_mode\":true,\"cert_dir\":\"/home/delphix/certs\",
\"crdb_parameters\":[{\"property_name\":\"max-sql-memory\", 
\"value\":\"0.25\"},{\"property_name\":\"cache\", 
\"value\":\"0.25\"}]}"
commit

Disable

Run the below commands to disable a dSource. You must select the same sourceConfig name that was given during VDB creation.

CODE

Example - 
source
select testscfgv
disable
commit

Enable

Run the below command to enable a dSource.

CODE

Example - 

source
select testscfgv
enable
commit

Stop

Run the below command to stop a dSource.

CODE

Example - 

source
select testscfgv
stop
commit

Start

Run the below command to start a dSource.

CODE

Example - 

source
select testscfgv
start
commit