MySQL
Sync MySQL operational data to your Shugyo digital twin with full refresh, incremental sync, or CDC.
Available data
- Tables
- All tables you grant access to
- Views
- Standard views
- Custom queries
- Choose the data to extract
Sync methods
| Method | Captures deletes | Best for |
|---|---|---|
| CDC | Yes | Production databases, real-time |
| Incremental | No | Simpler setup, smaller datasets |
| Full Refresh | Not applicable | Small tables, snapshots |
Connector features
Change data capture
Real-time replication via MySQL binlog. Captures inserts, updates, and deletes.
Large tables
Checkpointing and chunking support tables larger than 1 TB.
Read-only access
The connector requests SELECT and replication permissions and cannot write to source tables.
SSH tunnel support
Connect to databases behind firewalls via bastion hosts.
Supported versions
- MySQL 8.0, 5.7
- Works with: Amazon RDS, Google Cloud SQL, Azure Database, PlanetScale, self-hosted
Authentication
Username/Password
Credentials are sent over an SSL-encrypted connection. Use a dedicated read-only user for the integration.
Security
- SSL/TLS encrypted connections
- SSH tunnel support for on-premise
- SOC 2 Type II in progress
- You retain ownership of your data
INTEGRATION SETUP
Connect MySQL to Shugyo
Tell us which MySQL data you need and how often it should sync.