Don’t fix, work around – MySQL

I attended the MySQL EMEA conference last thursday where I enjoyed a talk from Ivan Zoratti titled “Scaling Up, Scaling Out, Virtualization – What should you do with MySQL?”

They have changed their minds quite a bit. Virtualisation in production is no longer a solid no-no according to them (a lot of people would argue). Solaris containers, anyone?

As most of us know by now, MySQL struggles to utilise multiple cores efficiently. This has been the case for quite some time by now, and people like Google and Percona has grown tired of waiting for MySQL to fix it.

Sun decided to not go down the route of reviewing and accepting the patches, but are now suggesting – are you sitting down? – running multiple instances on the same hardware.
I’m not against this from a technical point of view as it currently actually does improve performance on multiple-core-multiple-disk systems (for an unpatched version) for some workloads, but the fact that they have gone to openly and officially suggest workarounds to their own problem rather than fixing the source of the problem is disturbing.

Granted, I suppose it makes sense to suggest larger boxes if you’ve been bought by a big-iron manufacturer. Also, I should be fair and note that Ivan at least didn’t say scaling out was a negative thing and that it’s still a good option.

If anyone asks me though, I think I’ll keep scaling outwards and use the more sensible version of MySQL

This entry was posted in MySQL and tagged , , . Bookmark the permalink.

3 Responses to Don’t fix, work around – MySQL

  1. Baron says:

    Actually, I think Percona’s builds are the most sensible version of MySQL. They don’t have bleeding-edge storage engines etc built into them. OurDelta builds include both the Percona patches and a lot of other stuff that, unlike the Percona patches, is not yet proven in mission-critical environments.

  2. Erik says:

    The percona builds are very good indeed.
    I have quite a lot of confidence in the patches included in the non-Sail version of OurDelta though. Sphinx shouldn’t be too much in the way unless it’s actually used. I also think to a certain degree, it’s a different audience for the two builds.

    I’m happy to recommend the Percona builds to anyone.

  3. ايفون says:

    What you think about pgSQL ?
    Thanks ,
    David

Comments are closed.