Demo: a backfill that has to be stopped and resumed
On This Lesson 3 topics
This lesson is planned. The outline below lists the topics it will cover. The full lesson has not been published yet.
In this lesson
pause and resume a backfill when production load rises; prepares SRB-017-LAB1.
Draft outline details
Step by step
- Start the backfill with checkpoints and a rate limit; show dashboards for source load.
- Observe database latency rising during a business peak.
- Lower the rate, then stop the job; confirm the checkpoint.
- Planned mistake: restart from the beginning and duplicate rows. Fix: resume from the checkpoint; confirm idempotent upserts prevent duplicates.
- Resume at a lower rate off-peak.
- Verify with counts and checksums per key range, and write the result into the migration report.
Check your understanding
What makes a stop and resume safe?
Show answer
Checkpoints and idempotent writes.
Practice
Apply this lesson with the module's lab, exercises and quiz.
Marking a lesson complete is optional and you can undo it any time. Your progress stays in this browser.