10 Deadly Sins of MySQL Database Administration

Best Practices for Businesses
4 April 3:00PM - 3:50PM @ Ballroom H

Experience level: 
50 minutes conference
"Don't bother me with DBA 'best practices,' we have real work to get done." So go the famous last words from overworked IT managers (we’ve all been there at one time or another). Best practices don't have to interrupt your work or make it harder. Ideally, they should make database operations more predictable and less fraught with emergencies or surprises. This presentation provides a short list of common failures of DBA’s, and makes the case that you can save yourself time (and grey hair) by adopting better habits. For example, how to save up to 20% of your database size at the same time as reducing the query optimizer's work. How to protect yourself against unrestorable database backups. How to assure maximum uptime during schema migrations or version upgrades.


Senior Database Architect, SchoolMessenger
Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.