MySQL provision operations via CLI

To create a VDB from CLI you must create a dSource first. Instructions on how to create dSource from CLI, refer to MySQL link operation via CLI section.

To create VDB and perform the VDB operations from CLI, you first need to log in to the Delphix Continuous Data Engine with the admin user.

CODE

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

Provision

Here we are using dSource testdb.

CODE

Example - 

database provision
set type=AppDataProvisionParameters
set container.name=testvdb
set container.group=Untitled 
set source.allowAutoVDBRestartOnHostReboot=true
set sourceConfig.repository="(MySQL Community Server (GPL)) 5.7.38"
set timeflowPointParameters.container=testdb
set sourceConfig.name=testscfgv
set source.parameters="{\"vdbUser\":\"root\",\"vdbPass\":\"Password_String\",\"port\":3310,\"baseDir\":\"/usr\",\"serverId\":202,\"mPath\":\"/mnt/vdb_mount\",\"config_settings_prov\":[]}"
commit

Enable

CODE

Example - 

source
select testscfgv
enable
commit

Disable

To disable VDB, select the sourceConfig name given during VDB creation as above.

CODE

Example - 

source
select testscfgv
disable
commit

Stop

CODE

Example - 

source
select testscfgv
stop
commit

Start

CODE

Example - 

source
select testscfgv
start
commit