Category Archives: mysql
GNU Parallel and Block Size(s)
I’ve been a fan of GNU Parallel for a while but until recently have only used it occasionally. That’s a shame, because it’s often the simplest solution for quickly solving embarrassingly parallel problems. My recent usage of it has centered … Continue reading
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
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
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
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
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
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
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
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
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