MySQL/MariaDB Topics
Syniti Data Replication supports use of MySQL and MariaDB for:
- Refresh replications, both source and target
- Mirroring replications, both source and target. For source connections, Syniti Data Replication offers the Log Server Agent, transaction log support and triggers
- Synchronization
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 DR(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 Server Setup
- 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.