Percona XtraBackup: install, usage, tricks

8.375
Average: 8.4 (8 votes)

Vadim is main architect of Percona XtraBackup, In this tutorial he will cover every details of XtraBackup: - Original idea behind product - Internal design - Comparison with other backup solutions for MySQL - Work principles - Purpose of files in package - Basic usage - Parallel backup - Streaming backup - More complex usage: * Incremental backups * Differential backups * Partial backups * Move InnoDB tables between servers * Parallel compressed backups * lock and lockless modes * synergy with Percona Server All this with real-time detailed examples. We will measure how long it takes to backup 100GB database and what is size of incremental backup after some load. After this tutorial you will know as much Vadim knows about Percona XtraBackup

Track: 
Tutorials
Experience level: 
Beginner

Schedule info

Time slot: 
10 April 13:30 - 16:30
Room: 
Ballroom E

Schedule Info

10 April 13:30 - 16:30 @
Ballroom E

Speakers

Vadim Tkachenko's picture
CTO, co-founder, Percona Inc

Vadim leads Percona's development group, which produces the Percona Server, Percona XtraDB, and Percona XtraBackup. He is an expert in LAMP performance, especially optimizing MySQL and InnoDB internals to take full advantage of modern hardware using his multi-threaded programming background.

At Percona Vadim also designs no-gimmicks benchmark tests of hardware, filesystems, storage engines, and databases. He focuses on real-world performance and functionality scenarios that are often missed by standard benchmarks. Vadim actively consults for many Alexa Top 1000 web properties, but has an increasing focus on hardware appliances and storage engines. He is leading Percona's emerging expertise in solid-state storage with his launch of the SSD Performance Blog.

Alexey Kopytov's picture
Principal Software Engineer, Percona

Alexey joined Percona in November 2010 as a member of the development group that produces Percona Server, Percona XtraDB, and Percona XtraBackup.

Before joining Percona, Alexey worked in MySQL AB's High Performance group for two years and then in MySQL development at MySQL AB/Sun/Oracle for over four years. He is also the maintainer and, until recently, the sole developer of SysBench, a popular utility for MySQL performance evaluations.

Slides




Sponsored By