Skip to main content
Skip table of contents

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
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.