Linking using replication with bin log mode

In Replication Mode, Delphix creates a staging database using an initial backup from the source database. This initial backup can be taken by Delphix or can be provided by the end user. In order to ensure that the staging database remains in-sync with the source database, Delphix can set up a MySQL native replication from the sourcedatabase to the stagingdatabase.

Pre-requisites

• Staging environment must be added to Delphix.

• A Source Config must be created on the staging environment-MySQL repository.

This is recommended to reduce the possibility of errors while restoring the backup from the source database.

Creating dSource

1. Login to Delphix Management application.

2. Click Manage > Datasets.

3. Select Add dSource.

4. In the Add dSource wizard, select the MySQL source configuration which is created on the staging host.

5. Select Replication from the dSource Type dropdown.

6. 

   Provide the additional details required for dSource creation

   1. Staging DB Server ID Server ID for the dsource (staging db. For Replication Mode, this server id must be greater than the source db server id.

   2. Staging DB Port Port for the dsource (staging db). This port should not be used by any other application or MySQL server. 

   3. Staging Initialization Password Password to use while initializing the dsource (staging db). This password will be assigned to the 'root'@'localhost'. We need to provide Password of the root user over source. Delphix does not connect to the source db using the root user. Source root user password will be inherited for this instance once the data ingestion starts.

   4. MySQL Base Directory MySQL installation directory. This generally has location of /bin/mysql

   5. Mount Location on Staging Host This is the mount directory for Delphix on the staging host. This location should be unique and empty.

   6. Source DB Host IP Address IP Address of the source db host.

   7. Source DB UserName Delphix database user on the source database. This user will be created in the dsource when the initial backup is created or restored. If the backup generation over source is driven by Delphix, then Delphix will be using the Source DB USerName to connect to the source database. Delphix will be using this db user to manage the dSource and other time travel operations.

   8. Source DB Password Password for the source database user.

   9. Databases List Selective database replication is not supported. Leave blank or fill in as ALL which indicates that all databases on the source instance will be brought in.

   10. MySQL Backup Path Full path, including the filename, of the full source db backup to use for the dsource creation. If this is provided, Delphix will not create a backup.

   11. LogSync Whether to enable replication or not. If checked, Delphix will set up the dsource (staging db) as a replicated slave of the source database.

   12. Replication UserName Delphix DB user with replication privileges to set up replication from source to staging db. Currently, Delphix uses the Source DB user for replication.

   13. Replication User Password Password for the replication database user.

7. On dSource Configuration screen, select the dataset group where the dSource will be placed and click Next.

8. On the Data Management screen, select the staging environment and the environment user and click Next.

9. On the Policies screen, select the Snapsync and Retention policies for the dSource and click Next.

10. On the Hooks screen, add any pre-sync and (or) post-sync hooks as required and click Next.

11. Review the dSource configuration on the Summary screen and Submit. The Linking process has commenced.

Done, what's next?

You have created a MySQL dSource. Next step - Provision a VDB.