MySQL Break/Fix Lab

Database Administration
1 April 9:30AM - 12:30PM @ Ballroom A

Experience level: 
Beginner
Duration: 
3 hours tutorial
In this hands on lab, Rene Cannao will walk through evaluation of operational errors and issues in MySQL 5.6, and recovering from them. This will be a hands-on workshop where possible. Specific items that cannot easily be reproduced will be done via Amazon/EC2 and screencast. 1. Instance Crashes and Hangs - * Evaluating error logs and troubleshooting methodologies. * Determining issues (OOM, panics, system crashes, filesystem freezes/space issues, corruption. * Recovery methods and follow-up after triage. 2. MySQL Replication - * Replication high level overview and diagnosing issues. * IO thread and SQL thread issues, relay log corruption, binlog corruption, duplicate errors, non Deterministic SQL/data drift * Recovery methods and follow-up after triage, including checksum/sync methods. 3. Significant Performance Issues * Diagnosing performance issues via OS tools, performance counters/graphs and MySQL utilities/commands * Mitigating/Triaging issues with such techniques as relaxing durability, dynamic variable changes, command line fixes and managing connections/commands


Speakers

Lead Engineer, Self Employed
Biography: 
René has 10 years of working experience as System, Network and Database Administrator mainly on Linux/Unix platform. In the last 4-5 years his experience was focused mainly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle and now as Senior Operational DBA at Blackbird, (formerly PalominoDB). In this period he build an analytic and problem solving mindset and he is always eager to take on new challenges, especially if they are related to high performance.
Service Delivery Manager, Pythian
Biography: 
Alkin has extensive experience in enterprise relational databases working in various sectors for large corporations. With more then 20 years of industry experience he has acquired skills for managing large projects from ground up to production. For the past five years he's been focusing on e-commerce, SaaS and MySQL technologies. He managed and architected database topologies for high volume site at eBay Intl. He has several years of experience on 24X7 support and operational tasks as well as improving database systems for major companies. Currently leading global operations team on Tier 1 support for MySQL customers.
MySQL Database Consultant, Pythian
Biography: 
Gillian is a MySQL DBA at Pythian (formerly BlackbirdIT and PalominoDB), where she focuses on performance troubleshooting and scaling issues for multiple clients, and where she finally gets to try out the advice she gave in her three years on the MySQL support team at Oracle. In her earlier years she worked in such industries as e-commerce and online gaming as a software developer and MySQL DBA. Gillian is based in Vancouver, BC.

Slides