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.