A TokuDB Migration Case Study

Tuesday 4:30PM-5:20PM

@ Goldsmith 3

MySQL / MariaDB

50 minutes conference

Intermediate

Tracks:
Developer, Operations

In this presentation, we will discuss the migration of a rapidly growing production InnoDB system to TokuDB. This will include:

- Why TokuDB was chosen
- What features of TokuDB are used, and what features are not used
- Benchmarking and sizing evaluation used
- Additional dependencies and versions for software deployment
- Evaluating the backup options of Toku Hot Backup and LVM snapshots
- The impact of existing online alter statements procedures
- Balancing the memory configuration during migration to avoid OOM
- Tricks for a seamless production outage


Speakers

Ronald Bradford

Ronald Bradford (Pythian)

Senior MySQL Database Consultant

Biography:

Ronald has over 25 years of professional RDBMS experience in MySQL, Oracle, and Ingres. His expertise covers MySQL, LAMP and cloud-based consulting in architecture, performance, scalability and business continuity. Ronald is a former employee of the MySQL Inc consulting team (06-08) and Oracle Corporation (96-99). He has currently published 4 books on MySQL, his most recent titles available from Oracle Press include Effective MySQL: Optimizing SQL Statements, Effective MySQL: Backup & Recovery and Effective MySQL: Replication Techniques in Depth.


Slides



  Download Slides  

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA