~/talk

Backup and Restore: Discover Best Practices for a Distributed Database Backup Strategy

Talkat Distributed SQL Summit 2022 · on Wednesday, 2022-09-14· [databases, devops-and-delivery]
links:none on file
slides:none on file

YugabyteDB runs online backups that are topologically independent, copying tablet-level snapshot hard links in parallel to S3/GCS/Azure or NFS with SHA-256 checksums; YCQL supports table/keyspace backups while YSQL is database-level. Restores map tablet IDs (example: RF3 → RF1) and replay data; PITR uses in-cluster snapshots plus PITR with MVCC (snapshots every 24h, three-day retention yields continuous history and microsecond RPOs). Backups 2.0 adds a per-node sidecar and delta uploads, claiming 4-5x faster backups and lower network/storage costs.

AI-written summary · about

  1. 0:00Start
  2. 0:32What Is the Purpose of Backup
  3. 6:50Backing Up a Database
  4. 8:06Create a Backup
  5. 13:44Restoring a Database
  6. 17:42Point in Time Recovery
  7. 21:27Point in Time Recovery Management
  8. 22:09Backup Studio
  9. 25:51Distributed Snapshots
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.