Amazon RDS for MySQL Topics

Syniti Replicate supports use of Amazon RDS for MySQL for:

• Refresh replications, both source and target
• Mirroring replications, both source and target. For source connections, Syniti Replicate offers the Log Server Agent, transaction log support and triggers
• Synchronization

When setting up RDS for MySQL for use with the Log Server Agent, configure Log Server Agent (Windows Service) settings in the Connection wizard, providing file locations for log details.

When setting up RDS for MySQL for use with the transaction log:

1. Modify the MySQL Server Instance Configuration file, my.ini (Desktop editor).

2. Grant REPLICATION SLAVE privilege to the MySQL user ID that will be used by Syniti Replicate (DBMS tools).

When setting up MySQL for use with triggers:

1. Create or assign tables for Master Table and Log Table (DBMS tools).

2. Assign a tablespace for the Master table and Log Tables (DBMS tools).

This section contains topics that describe:

• MariaDB Server Setup

• MariaDB Transactional Replication Settings (in the Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog)

• MariaDB Log Information (in the Create Replication wizard and Create Multiple Replications wizard

Source Log Info screen)

Further Resources

• For a complete up-to-date list of supported sources and targets, and information on where to obtain a .NET provider, check the Supported .NET Providers article in the Help Center.
• The Help Center also provides database-specific setup notes in PDF format.