MySQL Transactional Replication Settings

Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog

The information below explains how to configure the transactional replication settings for MySQL in the Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog available from the Transactional Setup > Manage option on the connection in the Metadata Explorer.  

When replicating from MySQL using mirroring or synchronization, three transactional modes are available: Log Reader, Log Server Agent and Triggers.

Log Reader Settings

Make sure that you have configured your MySQL server as explained in MySQL Server Setup. You will not be able to complete the transactional setup without these settings.

Case Sensitive Table Names

Check this option if the MySQL database contains case-sensitive table names for tables that you wish to replicate.

Verify (appears only in the Transactional Log Settings dialog)

Click Verify first to see that the log options are correctly set up on the MySQL server. TheVerifybutton checks to see if the binary log is enabled on the server and if the user has the right permissions to access to it.

Log Server Agent Settings

Triggers Settings