Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

Become a MySQL DBA (Part 1)

Become a MySQL DBA (Part 1)

 3 October 9:00 AM - 12:00 PM @ St. Gallen
Experience level: 
Beginner
Duration: 
6 hours tutorial
Tracks:
Operations and Management
MySQL
Topics:
MySQL
Tools and Techniques
Fundamentals

Description

Someone came to your desk and said: “You seem to know MySQL, can you take care of our database? It looks like it needs some love”. Does that sound familiar? Lot’s of DBAs have gone that way. At the beginning, you need to learn a lot about MySQL and how to operate it. This hands-on tutorial is intended to help you navigate your way through the steps that lead to becoming a MySQL DBA. We are going to talk about the most important aspects of managing MySQL infrastructure and we will be sharing best practices and tips on how to perform the most common activities. In this tutorial we are going to cover: Monitoring and trending for your MySQL installation What’s the most important to look after? What tools to use? How to ensure you are proactive in monitoring health of your MySQL? How to diagnose issues with your MySQL setup? Slow queries Performance problems - what to look for? Error logs Hardware and OS issues Backups Binary and logical backup What tools to use? Most common maintenance operations Schema changes Batch operations Replication topology changes Database upgrades How to prepare for an upgrade? Performing minor and major version upgrades We will provide a setup using virtuals where you can freely test upon.

Speakers

Krzysztof Książek's picture

Krzysztof Książek

Senior Support Engineer, Severalnines AB

Biography:

Krzysztof Książek, Senior Support Engineer at Severalnines, is a MySQL DBA with experience managing complex database environments for companies like Zendesk, Chegg, Pinterest and Flipboard. He has presented at Percona Live and similar industry events before and is the main author of the Become a MySQL DBA blog & webinar series at Severalnines.

Share this talk


Slides