Skip to content
Cupcake-DRCP for Enterprise · Linux console walkthrough · Example dataLooking for the Mac app? →

Move the first big batch

MySQL snapshot synchronization

Copy data safely, then catch up what changed.

Snapshot and Sync jobs move rows from one database to another and show progress table by table.

18.4Mrows moved · example
642krows/min · example
0failed tables · example

Snapshot / Sync

Copy progress you can watch.

WorkspaceActive project: redacted - signed in as operator

Launch Control

Run snapshots, one-time syncs, and CDC streams.

Create the job, watch the status, and drill into transfer results only when you need detail.

Active job running
5Visible jobs
3In progress
2Completed
0Need attention

Snapshot

2

Sync Once

0

CDC

3

Recent Run Mix

Source load3%
2 running / 4 connected
Target load2%
2 running / 3 connected
Query rate292.0/scombined source/target activity
Data footprint3.1 MB34 tables visible
Mapping SummaryDefault mapping: redacted_scope, foreign key mode inherited.
Schema Drift NoteSnapshot recreates target tables from source schema. Sync Once applies compare/repair diffs without rebuilding schema.
Show deleted jobs
NameJob IDDry RunRequested ByCreatedCompletedStatus
Mapping for sample_apprjob_redacted_001nosystem2026-05-08 12:072026-05-08 12:08completed
Mapping for redacted_scoperjob_redacted_002nosystem2026-05-07 13:272026-05-07 13:27completed
Mapping for redacted_scoperjob_redacted_003nosystem2026-05-06 16:01-running
Mapping for employeesrjob_redacted_004nosystem2026-05-06 13:05-running

Job Detail: rjob_redacted_003

Table Summary

Comparison run: -
Mapping: redacted_scope
Target DB: redacted_target

Operation Summary

Type: CDC Stream
Scope: replication
FK mode: inherit

Status

running
filter table_nameoperation: alloutcome: allsearch events

Transfer Summary

Source TableTarget TableRows Transferred
No per-table metrics recorded yet--

Event Log

WhenTableCreatesUpdatesDeletesOutcomeResult
2026-05-08 21:03:08-000completedCDC cycle completed
2026-05-08 21:03:08-000n/aCDC stream heartbeat
2026-05-08 21:03:03-000n/aCheckpoint updated

Snapshot / Sync Wizard

Create snapshot job

Choose endpoints, mapping, target controls, and the sync mode for this run.

1RouteEndpoints selected
2Mappingredacted_scope
3Modesnapshot

Route & Mapping

source: source-host-redacted:3306target: target-host-redacted:3306Mapping for redacted_scope

Sync Controls

Snapshot (schema + full copy)target db: redacted_targetFK mode: inherit mapping

Illustrative Enterprise interface with example data. Controls are shown for reference; operations run in your installed application.

Product details

How Snapshot / Sync works

Snapshot and Sync jobs move rows from one database to another and show progress table by table.

What this page does

Snapshot / Sync is for moving rows in bulk. A snapshot is the initial copy of selected tables. A sync pass can catch up rows that changed after the first copy started.

How jobs run

The operator chooses an approved mapping, starts a job, and watches table-level progress. Cupcake reports rows moved, tables completed, active work, failures, and recent job events.

Why it matters

Large data moves should be visible while they run. Progress by table helps a team understand what is complete, what is still running, and where a problem occurred if the job stops.

What to look for

Useful signals include rows transferred, remaining time, failed tables, current table, throughput, and whether a follow-up compare should be run after the copy finishes.

Feature highlights

From the operator’s perspective

Watch the copy

Know which tables are done and which are still moving.

Use approved rules

Run from the saved mapping instead of a one-off script.

Catch errors fast

See failures and row counts while the work is running.