Replication with Delphix-Initiated backups in DCT

The connector creates the initial backup by connecting to the source database. Delphix Continuous Data Engine configures MySQL native replication (binlog replication) from the source database to the staging database to ensure that the staging database remains in sync with the source database. Delphix Continuous Data Engine creates a staging database using an initial backup from the source database in this ingestion method. For more information, read Replication with Delphix-Initiated backups (binlog replication).

Prerequisites

Before you begin database ingestion and creating a dSource, ensure that you meet the following requirements.

• The environment requirements are met by the source and staging environments as described in Requirements for MySQL source hosts and Requirements for MySQL staging/target hosts 

• The environment user must have the necessary permissions to access the MySQL commands.

• A standard MySQL database must be installed on the Staging environment. For more information, refer to Requirements and Prerequisites.

Procedure

To create a dSource using the Delphix-initiated single database backup ingestion:

1. Log in to DCT.

2. Add a source config against the discovered staging or target MySQL environment . For more information, read Create a source configuration for Connectors in DCT,

3. Go to Data>dSources tab and click +dSource.

4. On the Select Data Source page, select the MySQL dSource.

5. Once the MySQL dSource is selected, the following configuration settings will appear. Do the following:

   1. Staging DB Server ID: This is the Server ID for the dSource database. For Replication Mode, this server-id must be greater than the source database server id.

   2. Staging DB Port: The port number used by the staging dSource instance. This port should not be used by any other application or MySQL server.

   3. Staging Initialization Password: This is the Password that the connector uses when it initializes the staging database MySQL instance. This password will be assigned to the 'root' user of the staging database. This password will be used only for the first time the staging database instance is initialized.

      Once replication starts, this password will be updated with Source DB’s root user password. 

   4. MySQL Base Directory: Provide the location of the default MySQL installation directory. This generally has the location of /bin/mysql.

   5. Mount Location on Staging Host: This is the Delphix mount directory on the staging host.This location should be unique and unoccupied. Additionally, refer to Requirements for MySQL staging/target hosts to understand user privileges to create mount directories.

   6. Source DB Host IP Address: IP Address or FQDN of the source host.

   7. Source DB UserName: Delphix database user that was created on the source database (refer Requirements for MySQL source hosts). When the initial backup is created or restored, this user is also created on the staging database. If Delphix Continuous Data Engine is initiating the backup generation of the source, Delphix Continuous Data Engine will connect to the source database using the Source DB UserName. This db user will be used by Delphix Continuous Data Engine to manage the dSource and sync operations.

   8. Source Connection Password: Password for the above source database user.

   9. Full path (including filename) to MySQL Backup: Do not enter anything in this field for this ingestion method. This field is meant to be filled only in case of Replication with Externally Initiated backup.

   10. Backup path for Delphix-initiated backup: Provide a valid path for creating backups while using Replication with Delphix-initiated backups. By default, the value is /tmp. Make sure that there is proper privileges for the folder which is provided.

   11. Provide different Replication User: The users can provide different Replication user credentials by selecting this checkbox, as illustrated in the image below. Providing separate replication user credentials is optional. If this checkbox is not selected, the source database user provided above will be used for replication. 
       

   12. Replication UserName: user with replication privileges to configure replication from source to staging db. If this user is not provided, then the Delphix Continuous Data Engine uses the Source DB user for replication, as mentioned in steps g and h.

   13. Replication User’s Password: The password for the Replication username.

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

7. On the Data Management screen, select the staging environment and the environment user.

   Select the Resynchronize dSource under the Snapshot Parameters section to initialize and refresh the MySQL staging database.

8. Click Next.

9. On the Policies page, select the snapsync and Retention policies for the dSource and click Next.

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

11. Review the dSource configuration on the Summary page and Submit. The Linking process has commenced. Wait for the snapshot to be created. From that snapshot, you can now provision a MySQL VDB.