Skip to main content
Skip table of contents

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.

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

Creating and discovering the environment

Run the following commands to discover the environment.

CODE
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.

CODE
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.

CODE
Example - 

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

Disabling the environment

Run the following commands to disable the environment.

CODE
Example - 

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

Enabling the environment

Run the following commands to enable the environment.

CODE
Example - 

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

Deleting the environment

Run the following commands to delete the environment.

CODE
Example - 

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

Enable encryption

Run the following commands to enable encryption of the environment.

CODE
Example - 

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

Disable encryption

Run the following commands to disable encryption of the environment.

CODE
Example - 

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

For more information, refer to the Data Communication Encryption.

JavaScript errors detected

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

If this problem persists, please contact our support.