The Future of MyDumper
summary
MyDumper now supports streaming with full compression so restores can start while a backup is still running, and the stream implementation reliably pushes closed chunk files to the loader. Compression uses zstd halves time and storage on backups in practice. Imports avoid building indexes during inserts with deferred index creation for InnoDB, speeding large-table loads, and there is pause/resume (resume after Ctrl-C), PMM metrics, CircleCI/Docker testing, and ongoing chunk-size and single-file workflow work.
AI-written summary · about
chapters (4)
- 0:00Start
- 30:11Use Cases - With Stream
- 33:09Masquerade
- 38:18Performance impact - Innodb fast index creation optio
related talks
46mLock, Stock and Backup: Data Guaranteed
51mHeavy Duty Backup w/PgBackRest
26mCurrent state of MongoDB Backup options
50mWeb-Scale Backups for MySQL
49mWhat can't pgBackRest do for you?
12mThe Dilemma between Deduplication and Locality: Can Both be Achieved?
31mHighly Efficient backups with Percona Xtrabackup
39mLessons Learned from Our Main Database Migrations