how to connect to source from the delphix engine..?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
  • (Edited)
i have mysql database i need to connect to source from the delphix engine..how to i connect to source database from the delphix engine..?.
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Jaclyn Schoof

Jaclyn Schoof, Community Manager

  • 5,092 Points 5k badge 2x thumb
Hi Prakash,
Here are the directions for adding a MySQL database to the Delphix Engine, please note that you need to first add the Environment and then link the source. 

  1. Login to the Delphix Admin application using Delphix Admin credentials.
  2. Click Manage.
  3. Select Databases.
  4. Click Add dSource.
    Alternatively, on the Environment Management screen, you can click Link next to a database name to start the dSource creation process.
  5. In the Add dSource wizard, select the source database.

    Changing the Environment User

    If you need to change or add an environment user for the source database, see Managing MySQL Environment Users.

  6. Enter your login credentials for DB Username and DB Password.
  7. Click Next.
  8. Select a Database Group for the dSource.
  9. Click Next.
    Adding a dSource to a database group lets you set Delphix Domain user permissions for that database and its objects, such as snapshots. For more information, see the topics under Users, Permissions, and Policies.
  10. Select the Initial Load type.
    1. If selecting Existing MySQL Backup, provide the Path to the backup and select the Dump Type.
  11. Select a SnapSync Policy, a Staging Installation, and a Staging Port for the dSource.
    The Staging installation represents the MySQL binaries that will be used on the staging target to backup and restore the linked database to a replication slave.
  12. If you want to enable LogSync, check the LogSync checkbox.
  13. Click Advanced to select a Retention Policy and to manually specify replication coordinates.
    For more information, see Advanced Data Management Settings for MySQL Data Sources.
  14. Click Next.
  15. Specify any operations to run before and after the initial sync.
    For more information, see Using Pre- and Post-Scripts with MySQL dSources.
  16. Click Next.
  17. Review the dSource Configuration and Data Management information.
  18. Click Finish.
The Delphix Engine will initiate two jobs, DB_Link and DB_Sync, to create the dSource. You can monitor these jobs by clicking Active Jobs in the top menu bar, or by selectingSystem > Event Viewer. When the jobs have successfully completed, the database icon will change to a dSource icon on the Environments > Databases screen, and the dSource will be added to the list of My Databases under its assigned group.