Yelp’s MissionConnecting people with greatlocal businesses.
9:30am:Welcome & Let's talk about the basics11:00am: Break11:15am: Running MySQL in the real world12:15pm:Final wrap up12:30pm: LunchAdministrative°
Part 1:0.Brief Introduction1.MySQL History, Philosophy, Community2.Installation, Basic Configuration, Launching3.Using it, Backing it up4.Replication basics, Monitoring5.Database Defense & fast feedback to developersAgenda in More Detail±
Part 2:●Running in Production #realtalk●Being Prepared●Advanced Monitoring and Investigation●Fantastic Errors and Where to Find Them●When Things Are "Slow"●Advanced Tuning●Replication and Scaling Out●DiscussionAgenda in More Detail
●My name is Jenni●Engineering Manager @ Yelp●First DBA there in 2011Who am I Why am I Here?!
Got Into Databases by Accident"
$ Myth 1: databases are scary!
²³Myth 2: DBAs are scary!
<image of frustration?>²²
You may already have a database.It Was on Fire When I Got Here²°
"If someone is asking you who owns the database, it's probably you" - @mipsytipsyAnd it's Not Clear Who Fixes it²±
●Yelp didn't have a DBA for >5 years●We've acquired companies with great big DBs●There are probably some easy things to fixDon't Feel Bad!
Database Flavors:●SQL●NoSQL●Geospatial●GraphJust in Case You Don't Have a DB Yet...²"