Syniti Replicate supports use of MySQL and 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
When setting up MySQL/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 MySQL/MariaDB for use with the transaction log:
Modify the MySQL Server Instance Configuration file, my.ini (Desktop editor)
Grant REPLICATION SLAVE privilege to the MySQL user ID that will be used by Syniti Replicate(DBMS tools).
When setting up MySQL/MariaDB for use with triggers:
Create or assign tables for Master Table and Log Table (DBMS tools).
Assign a tablespace for the Master table and Log Tables (DBMS tools).
This section contains topics that describe:
MySQL/MariaDB Transactional Replication Settings (in the Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog)
MySQL/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.