Stream into Google Cloud SQL for MySQL with your free account
Deliver data from databases, SaaS apps, APIs, files, and streaming systems into Google Cloud SQL for MySQL using Estuary's pre-built connectors. Run pipelines from real-time streaming to scheduled batch based on connector capabilities.
- <100ms to batch
- 200+ connectors
- Managed data pipelines
Google Cloud SQL for MySQL connector details
The Google Cloud SQL for MySQL materialization connector in Estuary delivers data from Estuary collections into MySQL tables hosted on Google Cloud SQL. It supports continuous materialization from real-time or batch pipelines, using standard merge-based updates by default with optional delta updates for applicable workloads.
- Supports MySQL 5.7 and later
- Standard merge-based updates by default to keep destination rows synchronized
- Optional delta updates for workloads where changes should be applied incrementally
- Automatic table creation for configured materialization bindings
- Custom SQL after table creation for additional table configuration
- Direct Google Cloud SQL connectivity or SSH tunneling
- Configurable SSL modes, including certificate and hostname verification
- Configurable timezone handling using IANA timezone names or UTC offsets
- Automatic conversion of date-time fields to UTC when materialized
- Automatic quoting of MySQL reserved words when used as field names
The database user must have permission to create tables, and MySQL’s local_infile global variable must be enabled. For direct connections, enable a public IP on the Cloud SQL instance and authorize Estuary’s IP addresses; alternatively, an SSH tunnel can be used for private connectivity.
How to connect your data source to Google Cloud SQL for MySQL in 3 easy steps
- 1
Connect your data source
Select from more than 100 supported databases and SaaS platforms including PostgreSQL, MySQL, SQL Server, MongoDB, and Kafka.
- 2
Prepare and transform your data
Apply transformations and schema mapping as data moves whether you are streaming in real time or loading in batches.
- 3
Sync to Google Cloud SQL for MySQL
Continuously or periodically deliver data into your destination with support for change data capture and reliable delivery for accurate insights.
Trusted by data teams worldwide
All data connections are fully encrypted in transit and at rest. Estuary also supports private cloud and BYOC deployments for maximum security and compliance.
![Deel logo]()
Read success storyDeel
How Deel Powers Real-Time Customer-Facing Analytics with Estuary
![Together AI logo]()
Read success storyTogether AI
How Together AI Uses Near-Real-Time Data to Understand Inference Economics
![Logo for Envoy]()
Read success storyEnvoy
Right-Time Visibility for a High-Velocity Business: Envoy’s Estuary Story
![Logo for the Coltene Group]()
Read success storyColtene
From SAP on SQL Server to Snowflake: How Coltene Built Reliable Replication with Estuary
HIGH THROUGHPUT
Distributed, event-driven architecture scales for demanding data workloads.
DURABLE COLLECTIONS
Store data as it moves so you can transform, replay, and deliver it downstream.
FLEXIBLE LATENCY
From <100ms CDC and real-time streaming to scheduled batch, depending on connector capabilities.
From <100ms to batch
Estuary supports CDC, real-time streaming, incremental syncs, and scheduled batch across its connector ecosystem. Bring data from databases, SaaS apps, APIs, files, and event streams into Google Cloud SQL for MySQL, with capture and delivery cadence based on connector capabilities and pipeline configuration.
- Connect data from operational databases, SaaS applications, APIs, files, and streaming systems to Google Cloud SQL for MySQL through Estuary.
- Transform and route data through Estuary collections before delivering it to Google Cloud SQL for MySQL.
See what you can connect to Google Cloud SQL for MySQL:
Don't see a connector?Request and our team will get back to you in 24 hours
Pipelines as fast as Kafka, easy as managed ELT/ETL, cheaper than building it.
Feature Comparison
| Estuary | Batch ELT/ETL | DIY Python | Kafka | |
|---|---|---|---|---|
| Price | $ | $$-$$$$ | $-$$$$ | $-$$$$ |
| Latency | <100ms to scheduled | 5min+ | Varies | <100ms |
| Ease | Analysts can manage | Analysts can manage | Data Engineer | Senior Data Engineer |
| Scale | ||||
| Maintenance Effort | Low | Medium | High | High |
One platform for real-time and batch data pipelines
Deliver real-time and batch data from DBs, SaaS, APIs, and more
