Question 1

Which file formats can MySQL data land as?

Accepted Answer

CSV, JSON Lines, JSON array and Parquet. Parquet is the one to choose when types matter downstream, since the others push everything toward text and leave whatever reads the file to work out what a column originally was.

Question 2

What write modes are available?

Accepted Answer

Replicate writes one stable file and replaces it with the full current dataset. Snapshot writes a new timestamped full file each run. Replicate with write incremental files enabled uses the snapshot layout but writes only the changes, including deletion tombstones. Paired with binary log capture on the MySQL side, that last mode is what most teams actually want.

Question 3

Where do the files land?

Accepted Answer

Under your configured bucket and prefix, then an optional subfolder which new syncs default to the source connection name, then the table output. Replicate produces a stable path you can point a loader at. Snapshot appends an RFC 3339 timestamp to the filename so each run is distinct.

Question 4

Can I get date partitioned paths?

Accepted Answer

Not automatically. There is no source column or Hive style partitioning on this path. Datetime expressions in the subfolder will give you date shaped paths, and bucket prefixes are supported, but real partitioning has to happen in whatever consumes the files.

Question 5

What does the binary log have to do with this?

Accepted Answer

Everything, if you want incremental files. Enable replication for bulk syncs on the MySQL connection and Polytomic snapshots the selected tables once, then follows the binary log using GTID checkpoints where they are available. Each run after that writes only the rows the log reported as changed, tombstones included. Without it the sync falls back to full or tracking field reads and every run rewrites the entire dataset into the bucket.

Sync MySQL to Google Cloud Storage

Sync MySQL to Google Cloud Storage with Polytomic

Four output formats

Changes only, if you want

Replace or snapshot

Or sync Google Cloud Storage to MySQL

Trusted by businesses worldwide

Step-by-step integration guide

Connect MySQL in Polytomic

Connect Google Cloud Storage in Polytomic

Create a sync between MySQL and Google Cloud Storage

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect MySQL with Google Cloud Storage?