Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

MySQL Break/Fix Lab

MySQL Break/Fix Lab

 18 April 1:30PM-4:30PM @ Ballroom A
Experience level: 
Beginner
Duration: 
3 hours tutorial
Tracks:
Operations and Management
Topics:
MySQL
Tools and Techniques
Fundamentals

Description

In this hands-on lab you will learn to troubleshoot and fix common MySQL errors. You will be given a preconfigured EC2 instance to use, so please have an ssh client installed on your laptop. This tutorial is for beginner MySQL database administrators who are comfortable with the command line. 1. Instance Crashes and Hangs * Basic troubleshooting methods * Evaluating MySQL and system error messages * Determining issue causes (OS, filesystem, MySQL configuration, MySQL crashes) * Recovery methods 2. MySQL Replication - * High level overview and diagnosing issues * IO thread and SQL thread issues, relay log corruption, duplicate key errors and data drift * Recovery methods including checksum and sync 3. Performance Issues and Bottlenecks * Diagnosing performance issues via OS tools and MySQL utilities * Determining problems queries and connections * Reducing contention with MySQL configuration changes and commands

Speakers

Alkin Tezuysal's picture

Alkin Tezuysal

Senior Technical Manager, Percona

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 six 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. He has led MySQL global operations team on Tier 1/2 support for MySQL customers. Recently joined Percona's expert technical management team.

Emanuel Calvo's picture

Emanuel Calvo

Sr. Technical Services , Percona

Biography:

Emanuel has being working with MySQL for more than 8 years. He is originally from Argentina and has also lived and worked in Spain and other Latin American countries. He also lectures and presents at universities and local events. Emanuel currently works as Sr. Technical Services at Percona, focusing primarily on MySQL. His professional background includes experience at telecommunication companies, educational institutions, and data warehousing solutions. In his career, he has worked as a developer, Sysadmin and DBA in companies like Pythian, Blackbird.io/PalominoDB, Siemens IT Solutions, Correo Argentino (Argentinian Postal Services), Globant-EA, SIU - Government Educational Institution and Aedgency among others. As a community member, he has lectured and given talks in Argentina, Brazil, United States, Paraguay, Spain and Belgium as well as also written several technical papers.

Okan Buyukyilmaz's picture

Okan Buyukyilmaz

Mysql Database Consultant, Pythian

Biography:

Experience as mysql & oracle dba at Ebay Turkey for two years. Responsible for mysql to oracle migration project for dwh purposes. Currently a mysql database consultant at Pythian.

Share this talk