What Not to Say to the MySQL DBA
3 April 5:30PM - 8:20PM @ Community Networking Welcome Reception
This talk is going to be a list of anecdotes of bad instructions and requests that MySQL DBAs have received from developers, managers, and users. Some of these come from personal experience, and others are stories I've heard in the industry. This is a lighthearted look at some of the difficult instructions that DBAs get, with an aim of being educational as well. Each listed request will be explained, and then followed with why (or when) it's problematic, and what happened in the end, if that is known. Possible examples include: -"Don't add an index, I'll code around it." -"Don't turn off the query cache." -"Tuning InnoDB gives it an unfair advantage over MyISAM." -"We're using the failover slave for testing; refresh it every night with a new backup." -"Port this to SQL Server Express, it's free software too."
MySQL Database Consultant, Pythian
Gillian is a MySQL DBA at Pythian (formerly BlackbirdIT and PalominoDB), where she focuses on performance troubleshooting and scaling issues for multiple clients, and where she finally gets to try out the advice she gave in her three years on the MySQL support team at Oracle. In her earlier years she worked in such industries as e-commerce and online gaming as a software developer and MySQL DBA. Gillian is based in Vancouver, BC.