Amazon RDS for MariaDB Topics

Syniti Replicate supports use of Amazon RDS for MariaDB 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 MariaDB 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 MariaDB for use with the transaction log:

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

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

When setting up MariaDB 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.