MySQL and Search at Craigslist

Architecture and Technology, Migration
Location: Ballroom C Level: Intermediate
Average rating: ****.
(4.47, 15 ratings)

Millions of people search for things every day on craigslist: tickets, cars, garage sales, jobs, events, and so on.

This talk will look at the recent evolution of database and search architecture at Craigslist, including performance, caching, partitioning, and other tweaks. We’ll pay special attention to the unique challenges of doing this for a large data set that has an especially high churn rate (new posts, edits, and deletes).

And we strive to do this using as little hardware and power as possible.

Photo of Jeremy Zawodny

Jeremy Zawodny

Jeremy joined craigslist after over eight years in a variety of roles at Yahoo! He now hacks on various back-end pieces of craigslist, including MySQL and search.

Jeremy blogs at and flies both small airplanes and gliders in his spare time.

Comments on this page are now closed.


04/21/2009 4:53am PDT

Great session, very informative into the inner workings of Craigslist. Comforting to know that even such a huge cornerstone of the web is doing things with a relatively small development team.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.