Online Migration – Shadow Table Algorithm
gh-ost / pt-online-schema-change: copy rows in batches, tail the WAL, atomic swap
▶ Play
⏭ Step
↺ Reset
Speed: 1×
Press
Play
or
Step
to begin.
users (original)
id
name
email
users_gho (shadow)
id
name
email
status
WAL / binlog tail:
Original row
Copied to shadow
New / concurrent write
Pending (not yet copied)