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 here.

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 source's server-id value. This is required in order for replication between the source and staging databases to be enabled. Server-id can be checked in my.cnf file and MySQL database configuration file. It holds a list of parameters to configure the MySQL database server.