The Accidental DBA - FileId - 137196.pdf - The Accidental DBA Jenni Snyder [email protected] http\/bit.ly\/the_accidental_dba Yelp\u2019s Mission Connecting

The Accidental DBA - FileId - 137196.pdf - The Accidental...

This preview shows page 1 - 34 out of 197 pages.

Jenni Snyder Yelp @jcsuperstar The Accidental DBA
Image of page 1
Yelp’s Mission Connecting people with great local businesses.
Image of page 2
9:30am: Welcome & Let's talk about the basics 11:00am: Break 11:15am: Running MySQL in the real world 12:15pm:Final wrap up 12:30pm: Lunch Administrative °
Image of page 3
Part 1: 0. Brief Introduction 1. MySQL History, Philosophy, Community 2. Installation, Basic Configuration, Launching 3. Using it, Backing it up 4. Replication basics, Monitoring 5. Database Defense & fast feedback to developers Agenda in More Detail ±
Image of page 4
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 Discussion Agenda in More Detail
Image of page 5
My name is Jenni Engineering Manager @ Yelp First DBA there in 2011 Who am I Why am I Here? !
Image of page 6
Got Into Databases by Accident "
Image of page 7
#
Image of page 8
$ Myth 1: databases are scary!
Image of page 9
²³ Myth 2: DBAs are scary!
Image of page 10
<image of frustration?> ²²
Image of page 11
Why Databases? ²´
Image of page 12
You may already have a database. It Was on Fire When I Got Here ²°
Image of page 13
" If someone is asking you who owns the database, it's probably you " - @mipsytipsy And it's Not Clear Who Fixes it ²±
Image of page 14
Yelp didn't have a DBA for >5 years We've acquired companies with great big DBs There are probably some easy things to fix Don't Feel Bad!
Image of page 15
Image of page 16
Database Flavors: SQL NoSQL Geospatial Graph Just in Case You Don't Have a DB Yet... ²"
Image of page 17
MySQL PostgreSQL SQLite SQL/Relational Databases ²#
Image of page 18
Cassandra MongoDB Couchbase Redis NoSQL ²$
Image of page 19
PostGIS Neo4j Titan Geospatial & Graph ´³
Image of page 20
Image of page 34

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture