--- title: "MySQL Transactional Replication Settings" slug: "mysqlmariadb-transactional-replication-settings" updated: 2024-03-28T10:38:21Z published: 2024-03-28T10:38:21Z canonical: "skthelp.syniti.com/mysqlmariadb-transactional-replication-settings" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # MySQL/MariaDB Transactional Replication Settings ### [Enable Transactional Replication wizard](/v1/docs/enable-transactional-replication-wizard) or the [Manage Transactional Log Settings dialog](/v1/docs/transactional-log-settings-dialog) The information below explains how to configure the transactional replication settings for MySQL in the [Enable Transactional Replication wizard](/v1/docs/enable-transactional-replication-wizard) or the [Manage Transactional Log Settings dialog](/GUI/ManageTransactionalLogSettingsDialog.htm) 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](/v1/docs/choosing-a-log-type-for-transactional-replications). ## Log Reader Settings Make sure that you have configured your MySQL server as explained in [MySQL Server Setup](/v1/docs/log-server-agent-settings). 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. The **Verify** button 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](/v1/docs/log-server-agent-settings) ## [Triggers Settings](/v1/docs/ibm-informix-trigger-transactional-replication-settings)