MySQL
change data capture
TwinCommit captures changes from MySQL by reading its transaction log directly, then delivers each committed transaction exactly once to any supported target. Row-based binlog capture with GTID positioning.
MySQL
MySQL 5.7, 8.0, 8.4, 9.x · Amazon RDS & Aurora MySQL · Azure Database for MySQL · Cloud SQL
- ✓binlog_format = ROW and binlog_row_image = FULL
- ✓GTID mode recommended
- ✓REPLICATION SLAVE and REPLICATION CLIENT grants
Capture
How TwinCommit reads MySQL
TwinCommit connects as a replica, reads the row-based binary log and tracks position by GTID, so failovers and replica promotions are seamless.
MySQL source docs →Apply
How TwinCommit writes to MySQL
Multi-row INSERT … ON DUPLICATE KEY UPDATE and DELETE batches, committed with the checkpoint in one transaction.
MySQL target docs →Replicate MySQL to…
MySQL connector FAQ
Which MySQL versions does TwinCommit support?
+
MySQL 5.7, 8.0, 8.4, 9.x · Amazon RDS & Aurora MySQL · Azure Database for MySQL · Cloud SQL.
Does TwinCommit install anything in MySQL?
+
No. TwinCommit reads the MySQL log and creates no triggers, tables or procedures in the source database.
How does TwinCommit write to MySQL?
+
Multi-row INSERT … ON DUPLICATE KEY UPDATE and DELETE batches, committed with the checkpoint in one transaction.
Replicate your first table in five minutes.
Download the free Developer edition, or have one of our replication engineers walk you through a migration plan.