Question 1

What changes when the warehouse is serverless?

Accepted Answer

Standard Redshift takes a host, port and database user, optionally over SSH, and accepts either an access key or an IAM role for S3. Serverless instead uses IAM role authorization, identifies a workgroup, database and region, and connects through either the Redshift Data API or a Serverless VPC endpoint.

Question 2

What do I configure for writes?

Accepted Answer

Bind the IAM role to a Redshift database role, and make sure Redshift is permitted to assume it. This is the step most often missed, and the permission errors it produces look a lot like connectivity problems, which tends to send people debugging the wrong layer entirely.

Question 3

Is an S3 bucket still required?

Accepted Answer

Yes, and in the same region. Both standard Redshift and Serverless stage through S3, so there is no version of this pairing that avoids provisioning one. Serverless removes the cluster, not the staging storage.

Question 4

Does the load behave differently?

Accepted Answer

No. Serverless delegates to the same bulk writer. Polytomic writes chunked JSON to S3, optionally creates manifests, runs COPY with format as JSON, merges or rebuilds the destination table, then clears up the staging files. Knowing how loads behave on standard Redshift tells you exactly how they behave here.

Question 5

How much of my MySQL does it read each run?

Accepted Answer

As little as possible, provided you enable replication for bulk syncs. The first run snapshots the selected tables, and after that Polytomic follows the binary log and moves only what changed. Without it the sync falls back to full or tracking field reads, which on a large transactional database is a very different proposition.

Sync MySQL to Redshift Serverless

Sync MySQL to Redshift Serverless with Polytomic

IAM role authorization

Staged JSON then COPY

Data API or VPC endpoint

Or sync Redshift Serverless to MySQL

Trusted by businesses worldwide

Step-by-step integration guide

Connect MySQL in Polytomic

Connect Redshift Serverless in Polytomic

Create a sync between MySQL and Redshift Serverless

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 Redshift Serverless?