Add a MySQL environment in DCT

Add a MySQL source, staging, and target environments so DCT can host connector operations, dSources, and VDBs. Each MySQL host must have an operating system user that meets Delphix requirements. You add your environment as a new infrastructure connection.

Procedure

  1. Log in to DCT.

  2. Go to Home > Infrastructure Connections.

  3. Click + Infrastructure Connections.

  4. On the Create Infrastructure Connection page, enter a Connection Name and select the CD Engine you connected earlier.

  5. Click Next. On the Host & Server page, select the Host OS and Server Type:

    • Host OS: Select Unix or Windows. For MySQL data sources, only Unix is supported.

    • Server Type: select Standalone or Cluster.

  6. Click Next. On the Settings page, enter the following details:

    • Host / IP Address: Hostname or IP address of the environment host.

    • SSH Port: SSH port for the host. The default is 22.

    • Login Settings: Select the following options and then enter login credentials:

      • Username and Password: Enter the environment username and password.

      • Username and Public Key: Enter the environment username.

      • Password Vault: Select from an existing Enterprise Password Vault.

    • Toolkit Path: Enter a Toolkit Path. The toolkit directory stores scripts used for Delphix Engine operations, and should have a persistent working directory rather than a temporary one. The toolkit directory will have a separate subdirectory for each database instance. The toolkit path must have 0770 permissions and at least 345MB of free space.

    • Java Development Kit: By default, Delphix installs its own JDK. If you select Provide my own JDK, enter the absolute path to the JDK on the host.

    • Advanced Options: Optional settings such as Discover the SAP ASE, Set Network File System (NFS) Address, or Set Delphix Session Protocol (DSP).

  7. Click Validate, confirm that validation succeeds, and then click Next.

  8. Review the summary and click Submit.

Your environment is now added as an infrastructure connection in DCT.

After you add the environment

The environment appears in the Infrastructure Connections list. From the connection detail page, you can manage encryption, environment users, notes, and tags.