Why your backup strategy is wrong?
A brief overview of MySQL backup concepts
- Track: MySQL devroom
- Room: D.mysql
- Day: Sunday
- Start: 15:55
- End: 16:05
- Video with Q&A: D.mysql
- Video only: D.mysql
- Chat: Join the conversation!
"If you have a hammer, all you see is nails." also known as the Law of the Instrument describes the cognitive bias that involves over-reliance on a familiar tool. To protect MySQL data, a DBA must have a toolbox full of the proper utensils. To know only one approach is not enough.
In this talk, we will cover the following topics: - Why your backup strategy is probably wrong? - The Schröendinger Backup - Backups: Cold, hot... and warm? - The right answer is not always the logical one. - Replication is not the solution. - Point-in-time recovery. - Don't try this at prod: Test your backups.
Speakers
Pep Pla |