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 most visible (and one of the busiest) user-facing cluster. Along the way we deployed some new hardware (Fusion-IO) but not a complete replacement. Some boxes are Fusion-io, some local RAID, and some SAN.  We have too many eggs for any one basket.

We also converted table to the Barracuda format in InnoDB, dropped an index or two, converted some important columns to BIGINT UNSIGNED and enabled 2:1 compression for the table that has big chunks of text in it. Aside from a few false starts with the Barracuda conversion and compression, things went pretty well. Coming from 5.0 (skipping 5.1 entirely) we had some my.cnf work to do to take advantage of all the new InnoDB tuning (especially on the boxes with Fusion-IO cards and more memory). Hopefully switching the master goes smoothly too.

Needless to say, we have some very good and dedicated folks working behind the scenes to make it all happen (hi, Josh). Most of my involvement was initial testing, prodding, schema changes, and finding my.cnf options for the InnoDB tuning.

About Jeremy Zawodny

I'm a software engineer and pilot. I work at craigslist by day, hacking on various bits of back-end software and data systems. As a pilot, I fly a Flight Design CTSW and high performance gliders in the northern California and Nevada area. I'm also the original author of "High Performance MySQL" published by O'Reilly Media. I still speak at conferences and user groups on occasion.
This entry was posted in craigslist, mysql, tech. Bookmark the permalink.

6 Responses to MySQL 5.5.4-m3 in Production

  1. Ramoonus says:

    Do you have any benchmarks or graphs from before and after the upgrade?

  2. No benchmarks, sorry. The real performance gains are expected on the newer hardware so it would have been a pretty unfair comparison without a lot of extra effort.

  3. mitesh says:

    Hi,

    I am confused for latest stable version of mysql.

    mysql server 5.5.4-m3-log (community license GPL )is beta release or final/stable release.

    thanks ,
    Mitesh S. Pandya

  4. Mitesh says:

    Hi ,

    Are you inactive on this blog.
    Still I didn’t got any reply from you.
    If this is inactive blog jst mark on this page so next time any one can have idea that not to post on this blog.

    Please don’t mind.

    thanks,
    Mitesh S. Pandya

  5. I simply could not go away your site before suggesting that I really loved the usual info an individual supply for your visitors?
    Is gonna be back frequently in order to check up on new posts

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s