image
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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.