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