Home > datacenter, MySQL > My MySQL keynote slides and video

My MySQL keynote slides and video

April 15, 2010

Been asked a few times in the last few days about where my slides are from my MySQL keynote from *last* year.

Ooops.

Um, yeah.  Sorry about that.  Here’s a link to ‘The SmugMug Tale’ slides, and you can watch the video below:

Sorry for the extreme lag.  I suck.

The important highlights go something like this:

  • Use transactional replication.  Without it, you’re dead in the water. You have no idea where a crashed slave was.
  • Use a filesystem that lets you do snapshots.  Easily the best way to do backups, spin up new slaves, etc. I love ZFS.  You’ll need transactional replication to really make this painless.
  • Use SSDs if you can. We can’t afford to be fully deployed on SSDs (terabytes are expensive), but putting them in the write path to lower latency is awesome.  The read path might help, too, depending on how much caching you’re already doing.  Love hybrid storage pools.
  • Use Fishworks (aka Open Storage) if you can.  The analytics are unbeatable, plus you get SSDs, snapshots, ZFS, and tons of other goodies.
  • Use transactional replication. This is so important I’m repeating it.  Patch it into MySQL (Google, Facebook, and Percona have patches) or use XtraDB if you use replication.  We use the Percona patch.

Holler in the comments if something in the presentation isn’t clear, I’ll answer.  Apologies again.

Shameless plug - we’re hiring. And it’s a blast.

  1. Marshall
    April 15, 2010 at 4:37 pm

    What do you think of MySql-alikes such as MariaDb

    I know they have a lot of these patches and fixes already built into Mariadb and the team is as solid as you can get.

    Given that you were almost ready to throw your enterprise subscription away would you ever look to move to a more progressive engine or do you still think that Mysql / Oracle will drive as hard as when it was Mysql / Sun or even plain MySql

  2. April 20, 2010 at 8:07 pm

    Don – we’ve been working on ZFS for Linux. You might be interested in learning where we are at. Unfortunately ZFS is CDDL, not GPL (despite our trying to convince Sun to GPL it).

    What do you think of BTRFS?

  1. April 15, 2010 at 1:43 pm
  2. April 18, 2010 at 8:51 am
Comments are closed.
Follow

Get every new post delivered to your Inbox.

Join 34 other followers

%d bloggers like this: