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 DBA, Okta
Gillian joined Okta in March 2015. She's worked as a DBA at such companies as PalominoDB/BlackbirdIT, Pythian and Disney, and spent 3 years on the MySQL support team at Oracle. Her home base is Vancouver, BC.