Binlog change data capture
Stream changes straight from MySQL's binlog, thus avoiding full table scans.
MySQL
Polytomic connects MySQL to your data warehouse, databases, and SaaS tools for database ETL and reverse ETL. Replicate tables into your data warehouses, databases, cloud storage buckets using binlog change data capture, or sync data to SaaS applications like Salesforce, or sync data to MySQL from any of your systems.
Failover resistant
Polytomic's CDC streaming from MySQL is resistant to database failovers.
Schema changes handled
New columns are picked up and destination tables migrate automatically.
Example workflows
Replicate MySQL into data warehouses, databases, and cloud storage buckets
What you can sync
Move data between MySQL and your data warehouse, databases, and SaaS tools in both directions.
From MySQL
Tables and views across databases
Change data capture streaming through the binlog
Custom SQL as a model source
Tracking field incremental reading as binlog alternative
To MySQL
Tables, created and migrated automatically
Create, update, create or update, and replace
Merges keyed on the source primary key
Soft deletes by default, hard deletes optional
How it works
Connect Polytomic to your MySQL database and sync in either direction. Read tables into your data warehouse using binlog change data capture or write modelled data back into MySQL from anywhere else in your stack, whether other databases, data warehouses, SaaS applications, spreadsheets, or internal APIs.
- Connect MySQL directly or over an SSH tunnel
- Read tables and views, or write custom SQL as a model source
- Enable the binlog for streaming change data capture
- Resume reliably after failovers
- Write back with create, update, create or update, and replace modes
- Monitor sync health, record volume, and failures from one interface
How to set up
Polytomic connects directly or through an SSH tunnel using a bastion host and private key. For change data capture the server needs binlog configured in row format along with replication privileges for the Polytomic user.
How to get connected
- 1Create a MySQL user for Polytomic with read and replication privileges
- 2For change data capture, enable the binglog and set a retention policy
- 3In Polytomic, navigate to Connections, then Add Connection, then MySQL
- 4Enter host, port, database, and credentials, and configure SSL or SSH if needed
- 5Test the connection
- 6Select tables, choose a destination, set a schedule, and click Save
- 7
See the documentation for full setup details.
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with MySQL in minutes
No credit card required. Free trial available.