Fine Tuning Percona XtraBackup to your workload

Tools
24 April 11:10am - 12:00pm @ Ballroom D

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.

Speakers

George Lorch
Software Engineer, Percona
Biography: 
George joined the Percona development team in April 2012. George has over 20 years of experience in software support, development, architecture and project management. Prior to joining Percona, George was focused on Windows based enterprise application server development and network protocol classification and optimization with heavy doses of database schema design, architecture and tuning. George lives in the beautiful mountains of north-central Arizona with his wife and cat. His hobbies are fiddling with cool bits of technology, home brewing and winemaking, tending his ever growing garden, hiking, fishing, camping and otherwise enjoying the out of doors as much as possible.

Slides