This documentation site is no longer maintained. For the latest Delphix product documentation, please visit help.delphix.com
Continuous Data

MySQL environment-related operations via CLI

The operations explained earlier in this section can also be completed via advanced CLI operations. This 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 from rh86-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

For more information, refer to the Data Communication Encryption.