MySQL environment-related operations via CLI

The operations explained earlier in this section can also be completed via advanced CLI operations. These operations include:

• Create & Discover

• Update

• Refresh

• Disable

• Enable

• Delete

• Update Encryption

Login and Authenticate

Before any command, ensure you are logged in to the Delphix Continuous Data Engine using the admin user account.

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

Creating and discovering the environment

Run the following commands to discover the environment.

Example - 

environment
create
set hostEnvironment.name=rh86-my15-s1
set hostParameters.host.address=rh86-my15-s1.dlpxdc.co
set hostParameters.host.toolkitPath=/opt/toolkit
set primaryUser.name=mysql
set primaryUser.credential.password=mysql
commit

Updating the environment

Run the following commands to update the environment.

The name of the environment can be updated fromrh86-my15-s to rh86-pg15-s1.dlpxdc.co using the following command.

Example - 

environment
select rh86-my15-s1
update
set name=rh86-my15-s1.dlpxdc.co
commit

Refreshing the environment

Run the following commands to refresh the environment.

Example - 

environment
select rh86-my15-s1.dlpxdc.co
refresh
commit

Disabling the environment

Run the following commands to disable the environment.

Example - 

environment
select rh86-my15-s1.dlpxdc.co
disable
commit

Enabling the environment

Run the following commands to enable the environment.

Example - 

environment
select rh86-my15-s1.dlpxdc.co
enable
commit

Deleting the environment

Run the following commands to delete the environment.

Example - 

environment
select rh86-my15-s1.dlpxdc.co
delete
commit

Enable encryption

Run the following commands to enable encryption of the environment.

Example - 

environment
select rh86-my15-s1
update
set encryptionEnabled=true
commit

Disable encryption

Run the following commands to disable encryption of the environment.

Example - 

environment
select rh86-my15-s1
update
set encryptionEnabled=false
commit