Part 2 - Become a MySQL DBA
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
Art van Scheppingen is a Senior Support Engineer at Severalnines. He’s a pragmatic MySQL and Database expert with over 16 years experience in web development. He previously worked at Spil Games as Head of Database Engineering, where he kept a broad vision upon the whole database environment: from MySQL to MongoDB, Vertica to Hadoop and from Sphinx Search to SOLR. He regularly presents his work and projects at various conferences (Percona Live, Community Open House for MongoDB, FOSDEM) and related meetups.
System Support Engineer, Severalnines
Ashraf Sharif is a System Support Engineer at Severalnines. He previously involved in hosting world and LAMP stack, where he worked as principal consultant and head of support team and delivered clustering solutions for big websites in the South East Asia region. His professional interests focus on system scalability and high availability.