8
Optimizing Backup and Recovery
Once you know there is a valid backup and restore process for your environment, how can you improve and refine this process? Depending on your locking strategy, diskspace availability, or business data recovery service level agreement (SLA), there are various techniques you can use to optimize and streamline your process. There are also architectural considerations for further optimizations.
In this chapter we will discuss:
• Use and benefits of compression
• Levering streaming
• Parallelism with mydumper
• Full and incremental backups
• Architectural considerations
Example Backup Environment
Chapter 2 discussed ...
Get Effective MySQL Backup and Recovery now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
