Tungsten University
TungstenCluster Master Class
Intermediate

Backup & Recovery

Learn how to design, take, and restore backups for Tungsten Cluster so you can meet realistic RPO/RTO goals and recover quickly from disasters.

This session covers backup planning, compares tools like mysqldump, xtrabackup, snapshots, and file copy, and shows how to run cluster-integrated backups with datasource/cluster backup commands and cron automation.

You’ll also walk through restoring both cluster and external backups using cctrl, handling binlog positions, purging THL, using the Tungsten tracking schema, and recovering nodes cleanly whether the backup came from a primary or a replica.

Topics Covered

  • 00:00 Introduction
  • 00:19 Topics
  • 01:14 Backup Plan – Considerations
  • 02:44 Backup Plan – Best Practices
  • 06:53 Backup Tools
  • 10:10 Taking and Restoring Backups Within a Cluster
  • 11:31 Automate Backups Within the Cluster
  • 13:06 Restoring a Backup Within a Tungsten Cluster
  • 14:33 External Backups
  • 16:40 Restoring an External Backup
  • 19:00 Restoring from a Primary - The Tungsten Tracking Schema
  • 21:20 Restoring from a Primary - Setting the Correct Position
  • 23:43 Summary
  • 26:00 Thank you