Creating Backups for Various Transactional DBMSs Under Load
summary
WAL-G backup tool development for cloud environments is described, including added support beyond PostgreSQL to MongoDB, MySQL, FoundationDB and others. The talk compares these transactional DBMSs’ differences and specific challenges when making backups under load in the cloud.
AI-written summary · about
chapters (32)
- 0:00Introduction
- 1:11Backup goals at Yandex
- 2:14DBMS backup requirements
- 7:15Traditional backup limits
- 8:43Choosing wal-g
- 10:06Cloud backup storage
- 11:34PITR change archiving
- 12:58Delta backups for recovery
- 14:43wal-g for PostgreSQL
- 15:48Replica backup with lag
- 16:53Cluster backup selection
- 17:59Go for wal-g development
- 18:21Data compression issues
- 21:10Brotli compression
- 22:35Encryption fixes
- 24:21S3-compatible storage
- 26:06Google Cloud Storage
- 27:13Filesystem backups
- 28:36wal-g extensibility
- 31:06MySQL online backups
- 33:15MongoDB backup issues
- 35:23SQL Server backups
- 36:52FoundationDB and others
- 37:33Feedback and community
- 38:42Q&A: other DBMSs
- 39:26Q&A: table drop recovery
- 40:29Backup verification
- 40:53wal-g installation
- 42:17Backup practices survey
- 44:29Backup responsibility
- 45:11Compression reliability
- 46:37Q&A: Amazon RDS
