Become a MySQL DBA (Part 1)
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.
Senior Support Engineer, Severalnines AB
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.