Percona Toolkit, A MySQL DBA's Toolkit In Action
This presentation will present several Open Source tools which can provide DBA's, sysadmins and developers with additional information on the state and performance of their database while also facilitating the management of their database environment. We will present and discuss several following operational issues: - How to archive data from a large table while keeping an eye on the database performance. - How to verify the consistency of your databases. - How to gather information to troubleshoot performance issues. - Doing online replication aware schema changes. - Identifying queries which could use optimisation to get better response times. This talk will cover several Percona Toolkit scripts and demonstrate how to use them on your infrastructure.
Solution Engineer, Percona
At the age of 7, Dimitri received his first computer, since then he has felt addicted to anything with a digital pulse. Dimitri has been active in IT professionally since 2003 in which he took various roles from internal system engineering to consulting. Prior to joining Percona, Dimitri worked as a Open Source consultant for a leading Open Source software consulting firm in Belgium. During his career, Dimitri became familiar with a broad range of open source solutions and with the devops philosophy. Whenever he's not glued to his computer screen, he enjoys travelling, cultural activities, basketball and the great outdoors. Dimitri is living with his girlfriend in the beautiful city of Ghent, Belgium.
MySQL Practice Manager, Percona
Kenny is currently MySQL Practice Manager at Percona.