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.
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. :)
ReplyDeleteThere 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.
ReplyDeleteI will blog about it when its ready.
So did you run your wordpress blog on MySQL Cluster formerly?
ReplyDeleteLOL! No, I didn't have enough servers, or traffic to warrant that :)
ReplyDeleteThe 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.
Is the approch is same as of Joseph Daly's (http://www.8bitsofbytes.com/?p=5)
ReplyDeleteUsing mysql libraries and protocal?
Yes, almost exactly. And I wish I had seen that earlier instead of doing it myself ;)
ReplyDeleteAlthough it is worth mentioning if you have the libdrizzle php plugin there is a WordPress plugin to use that instead.
ReplyDeleteI 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.
ReplyDeleteWell 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.
ReplyDeleteEverything I have learnt about the migration I will blog about shortly and will help me with writing the migration tool.