Fine Tuning Percona XtraBackup to your workload
Percona XtraBackup now has several features that allow for the parallel execution of data export, compression and encryption. I will explain the best ways to use the various XtraBackup features in order to get the ideal performance curve for your application.
In this talk I will cover:
- Comparison of the XtraBackup internal implementations of compression and encryption to common external utilities such as gzip, quicklz and gpg, complete with benchmarks.
- How to maximize XtraBackup resource usage through careful selection of parallel export, compression and encryption options including new memory usage controls. I will provide some simple architectural views of the XtraBackup internals and a wide range of benchmark results to help illustrate how the various options impact XtraBackup performance and system utilization.
- How backup target storage location effects XtraBackup performance and common approaches that can be taken to help reduce its impact.
- Cloud based storage solutions for your backup data and their possible impact on backup performance.