Wednesday, 25 August 2010

Wordpress and Drizzle

I am a firm believer in practising what you preaching so since I am working in Drizzle my blog should work on Drizzle.

After a few small conversions of table schemas this Wordpress blog is now running on a Drizzle database server!  I will over the next few weeks migrate the rest of the sites I host as well as other server-side things to use drizzle instead of MySQL.

I also suggest watching this space, I will soon be working on a tool to make such migrations much easier.

9 comments:

  1. Andrew, count me in as one of your early beta testers. I've wanted to migrate my wordpress blog to drizzle for a while, but haven't wanted to spend the time to move the data over or figure out what bits of the schema would need fixing. :)

    ReplyDelete
  2. There are a few things that need changing and I wouldn't recommend doing it manually to a pre-existing blog as some of the data needs massaging into shape too. But the tool I am working on will certainly work for pre-existing WordPress installations.

    I will blog about it when its ready.

    ReplyDelete
  3. So did you run your wordpress blog on MySQL Cluster formerly?

    ReplyDelete
  4. LOL! No, I didn't have enough servers, or traffic to warrant that :)

    The site I worked on a few years ago that did use cluster is: http://www.thefirstpost.co.uk/. Unfortunately it has since been moved to InnoDB to go in-line with the rest of the sites they own.

    ReplyDelete
  5. Is the approch is same as of Joseph Daly's (http://www.8bitsofbytes.com/?p=5)
    Using mysql libraries and protocal?

    ReplyDelete
  6. Yes, almost exactly. And I wish I had seen that earlier instead of doing it myself ;)

    ReplyDelete
  7. Although it is worth mentioning if you have the libdrizzle php plugin there is a WordPress plugin to use that instead.

    ReplyDelete
  8. I agree with you ;) The dog food test is very important for usability. Developers need to understand what annoys users, and be encouraged to fix low hanging fruit.

    ReplyDelete
  9. Well the good news is I spent most of my spare time the last couple of weeks finding and killing annoying but subtle bugs such as SHOW PROCESSLIST giving incorrect information in sleep states and a few strange client behaviours.

    Everything I have learnt about the migration I will blog about shortly and will help me with writing the migration tool.

    ReplyDelete