The Percona Live Europe Open Source Database Conference 2016 in Amsterdam got off to a great start on Monday with a day of tutorials. One of the ones most anticipated was Become a MySQL DBA Part 1 and Part 2, given by Severalnines’ Johan Andersson (CTO) and Krzysztof Książek (Senior Support Engineer).
This hands-on tutorial is intended to help you navigate your way through the steps that lead to becoming a MySQL DBA. Johan and Krzysztof discussed the most important aspects of managing MySQL infrastructure, as well as shared best practices and tips on how to perform the most common activities.
They covered:
- Monitoring and trending for your MySQL installation
- Differences between NDB Vs. Galera
- MySQL Cluster: Pros and Cons
- Galera Cluster: Pros and Cons
- How to ensure you are proactive in monitoring the 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
- Most common maintenance operations
- Schema changes
- Batch operations
- Replication topology changes
- Database upgrades
After their talk, Percona’s EMEA Field Marketing Manager Kamal Taibi was able to quickly chat with the two about their talk, and about the conference. Watch it below!
