O'Reilly logo

Effective MySQL Backup and Recovery by Ronald Bradford

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required