Category Archives: mysql

Handling Database Failover at Craigslist

There has been some interesting discussion on-line recently about how to handle database (meaning MySQL, but really it applies to other systems too) failover. The discussion that I’ve followed so far, in order, is: GitHub’s report on their automated failover … Continue reading

Posted in craigslist, mysql, tech, yahoo | 11 Comments

NoSQL is What?

I found myself reading NoSQL is a Premature Optimization a few minutes ago and threw up in my mouth a little. That article is so far off base that I’m not even sure where to start, so I guess I’ll … Continue reading

Posted in mongodb, mysql, nosql, programming, redis | 68 Comments

Databases 10 Years Ago

In preparation for the talk I’m giving tomorrow, I was assembling a slide that looks back about 10 years ago and remembering what our database infrastructure was like back then. I was at Yahoo! during that time and our leading-edge … Continue reading

Posted in mysql, tech | 1 Comment

Slides for: Fusion-io and MySQL 5.5 at Craigslist

The slides from the talk I gave at Percona Live San Francisco yesterday are now available on slideshare (hopefully the embed works here too): View more presentations from Jeremy Zawodny. Overall, I enjoyed the conference–not just meeting up folks I … Continue reading

Posted in craigslist, mysql, programming, tech | 5 Comments

When an example falls in your lap

As I recently noted, I’m giving a short talk at Percona Live about our experience with Fusion-io for MySQL at Craigslist. As is often the case, I agreed to give the talk before giving too much thought about exactly what … Continue reading

Posted in craigslist, mysql, tech | 8 Comments

Speaking at Percona Live in San Francisco

On Wednesday, February 16th, I’ll be attending Percona Live in San Francisco to hear about what’s new in the MySQL ecosystem and talk about our adoption of Fusion-io storage for some of our systems at Craigslist. Not only do we … Continue reading

Posted in craigslist, mysql, tech | 1 Comment

Always Test with Real Data

As I previously noted, I’m in the midst of converting some data (roughly 2 billion records) into documents that will live in a MongoDB cluster. And any time you move data into a new data store, you have to be … Continue reading

Posted in craigslist, mongodb, mysql, programming, tech | 7 Comments

MySQL 5.5.4-m3 in Production

Back in April I wrote that MySQL 5.5.4 is Very Exciting and couldn’t wait to start running it in production. Now here we are several months later and are using 5.5.4-m3 on all the slaves in what is arguably our … Continue reading

Posted in craigslist, mysql, tech | 16 Comments

Database Drama

There’s been a surprising amount of drama (in some circles, at least) about database technology recently.  I shouldn’t be surprised, given the volume of reactions to the I Want a New Datastore post that I wrote. (Hint: I still hear … Continue reading

Posted in mysql, nosql, tech | 15 Comments

MongoDB Early Impressions

I’ve been doing some prototyping work to see how suitable MongoDB is for replacing a small (in number, not size) cluster of MySQL servers. The motivation for looking at MongoDB in this role is that we need a flexible and … Continue reading

Posted in craigslist, mysql, nosql, programming, tech | 7 Comments