Requirements for MySQL source databases

Connectivity to the source database from the staging database for replication

The connector should be able to connect to the source environment’s database from the staging environment and take a backup of the source database(s) using the mysqldump utility.

Source DB user:

A Source DB user can connect to the source database both from the staging host and locally.

A Source DB user must be granted the following permissions in the source database:

• SELECT

• SHUTDOWN

• SUPER

• RELOAD

• SHOW VIEW

• EVENT

• TRIGGER

• REPLICATION CLIENT

• REPLICATION SLAVE

You are responsible for performing a logical backup of the source database with the mysqldump utility and initiating replication between the source and staging databases.

mysql -u<user> -p<password> --protocol=TCP --port=<port>mysql> CREATE USER 'delphix_os'@'<staging_host>' IDENTIFIED BY 'delphix_user_password';

​​mysql> CREATE USER 'delphix_os'@'localhost' IDENTIFIED BY 'delphix_user_passwd';


mysql> GRANT SELECT, SHUTDOWN, SUPER, RELOAD, SHOW VIEW, EVENT, TRIGGER, REPLICATION CLIENT, REPLICATION SLAVE on *.* to 'delphix_os'@'staging_host';

mysql> GRANT SELECT, SHUTDOWN, SUPER, RELOAD, SHOW VIEW, EVENT, TRIGGER on *.* to 'delphix_os'@'localhost';

'staging_host' = IP address of Staging Host

In addition, you have the ability to grant more permissive privileges; however this is not mandatory.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'%';

Remember that this is the user that Delphix Continuous Data Engine uses to manage the staging database. As a result, it is recommended that you create a dedicated source DB user for Delphix Continuous Data Engine with the privileges described above.

Binary logging should have been enabled on the source database.

Binary logging on the source database must be enabled in order to set up replication. You can check the status of binary logging as follows: 

mysql> SHOW VARIABLES LIKE 'log_bin';

If binary logging is enabled, the following status should be displayed:

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | ON    |
+---------------+-------+
1 row in set (0.01 sec)

The source database must have a non-zero server-id.

The source database must have a non-zero server-id, and the server-id value must be different from the staging server-id value. This is required for replication between the source and staging databases to be enabled. The server-id can be checked in my.cnf file (MySQL database configuration). It holds a list of parameters to configure the MySQL database server.

SDI requires MySQL 8.0 or higher on the sourceDB.

The following requirements apply when using the SDI:

SourceDB user permissions

• The source database user must have the following privileges:

  GRANT SELECT, SHOW VIEW, EVENT, TRIGGER, REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO 'delphix_user'@'staging_host'; 

• For Aurora sourceDBs, RELOAD permission is typically unavailable. The connector handles this by capturing GTID state separately. The RELOAD permission is not required for SDI.

Binary logging (for replication only)

If enabling continuous replication, binary logging must be enabled on the source:

SHOW VARIABLES LIKE 'log_bin'; 
-- Expected: log_bin = ON 

Aurora-specific source requirements

After modifying the Aurora parameter group, the cluster must be rebooted for changes to take effect.

Standard VM-specific source requirements

Database existence

All database names specified in the Selective Database List must exist on the source at the time of dSource creation. The connector validates this before starting the backup and returns an error listing any databases not found.