oh LugRadio how funny you are

How many other open source/free software radio/podcast shows could pull off discussing morals and free software with a discussion on machines running free software that a) used for efficient slaughter (of various things) and b) the violent anal raping of donkeys.

Apparently there’s people who think of these things…. and it’s hilarious.

(hrrm… what does that say about me finding that hilarious?)

hej hej

Great things:

  1. I get to see snow. I haven’t seen snow anywhere else in the world yet, just in Stockholm (apart from flying over places… but that doesn’t really count)
  2. The language is cool, a lot of people speak English (to varying degrees) and it’s not that hard to pick up enough to get by (especially since TV programs as subtitled… so watching Buffy on Swedish TV will educate you in enough Swedish to save the world from unspeakable demons)
  3. We have MySQLers here (including a good number of Cluster developers)
  4. They have the Internet here. Not like Australia, stuck on the arse end of the internet – oh no, 5Mbit is considered slow here.
  5. Stockholm really is a beutiful city.
  6. public transport is frequent and close by (at least for the Stockholm area… which is where I am). Further into the center it’s even better, but here it’s good (where here is about 15-20mins via bus and subway to Liljeholmen, where the office is)
  7. R&D is (again, unlike Australia) valued highly here, with a good amonut of high tech industry and a seeming respect for academia.
  8. There’s a chemist in Gamla Stan that’s been there for about 400 years. I haven’t bought anything from there, but I feel I should – to go with that beer from that pub that first got it’s license nearly 400 years ago that I had while in London.

And not so great…

  1. The only way to buy beer stronger than 3.5% is to go to the government run System Bolaget – which is closed at about any time you’d consider buying alcohol. Aparrently the locals get around this by going there and just buying heaps at once – so completely defeating the attempt to get people to buy less. Oh, and if you like any decent liquor – it’s probably cheaper to drive/fly to another country and bring it back. Aparrently that’s what people do… with vans. Lucky for me I picked up some Laphroigh on the way through London
  2. Some things are expensive… and there are relatively high tax rates… although you seem to actually get something for that, so it’s not all bad (unlike in .au… where you seem to get nothing).
  3. It’s a long way from Melbourne, especially in economy seats… urggh. Not exactly a company policy I agree with for such long trips.

for now, hej då

Stockholm

Currently in the MySQL Cluster team office in Stockholm – and have been since Wednesday. I’ll be here for the next 3 weeks working in the office. This will be the longest amount of time I’ve worked in an actual office (instead of working from home) in more than 2.25 years!

I found Veronica Mars on TV last night… which is great, because I’ve sort of become addicted. Unfortunately, Sweden is a few episodes ahead of Australia…. so I’ve skipped a few now (go MythTV, record them for me baby). One really good thing about Swedish TV is that things are subtitled instead of dubbed – excellent if your Swedish isn’t that great (mine isn’t). Whenever here, I also seem to find some TV shows that look really interesting, except for the fact that it’s all in a language I don’t understand… certainly an interesting dilemma.

Today I’ve been working on material for the MySQL Cluster: The Complete Tutorial at the MySQL Conference and Expo. The conference is April 23-26 in Santa Clara, California (and if you register by March 14 you save $200 on registration). It’s going to be a SIX hour hands on tutorial (with breaks, don’t worry).  The hands on part (I think) is very important… that way you walk away with real-world knowledge that you can directly apply – not just with theory that you could have gotten from reading a bit here and there.

I’m really hoping that as many people with existing knowledge (esp MySQLers) can be around during the session to help people when needed… I have a feeling there’ll be a few.

Nearly off to London and Stockholm

In about 4.5hrs, I’ll be in a cab to the airport. At about lunchtime (1:30pm or so) London time, I’ll be in London. I’ll be there for a few days – until the 27th. If you’re around London or can make it, it’d be cool to hang. I plan to be a bit of a tourist here and there as I haven’t seen heaps of London and I do hear it’s nice :)

After that, I’ll be in Stockholm for about three weeks (I leave on the 19th… as it’s currently planned). So if you’re around, give me a yell!

My cell (mobile) number is pretty easy to find (hint: google my name along with my employer and look for a post on a mailing list… my work email sig has my phone number).

I’m in Stockholm for work, I’m going to be working in the office (which will be the longest amount of time I’ve gone to work in an office in over 2 years).

SVN shows its’ true colours

I thought “svn”, I typed “cvs”. Hrrm… sounds about right.

In other revision control news, using quilt to manage work-in-progress patches in conjunction with BK is proving really, really great. I feel like an idiot having lived this long and not worked this way.

I have a feeling that if git was being used I’d just do everything there as it’s so quick anyway. I haven’t used bzr on these sorts of size of repos yet, but it should be good too.

Danger-Bomb alarm clock: reconnect the wires to turn it off

Boing Boing: Danger-Bomb alarm clock: reconnect the wires to turn it off

I think I totally need one of these – over the years I’ve become a complete expert in the art of not getting out of bed when an alarm goes off (even if I have several scattered around the room)

OpenOffice.org continues to hate you

Inserting bullets into slides where previously there were none. Thanks OOo, reformating a number of slides was exactly what I was missing in my life.

Oh, and waiting an entire minute to save my presentation is also a great use of time. Funnily enough, my laptop disk (although slow) is faster than 1.3MB/minute.

RAID, LVM2 on USB disks with Ubuntu makes me a sad panda

Talk about a total pain to operate. After a reboot, the following is needed:

  1. modprobe dm_snapshot (if you don’t do this, you get “device-mapper: reload ioctl failed: Invalid argument” in step 6 – a really helpful error message. no dmesg or verbose things gets you any closer)
  2. some magic foo to scan the md array back
  3. pvscan
  4. vgscan
  5. lvscan
  6. lvchange -ay FooVG/barLV
  7. mount
  8. urgh.

Why this doesn’t just all detect itself on boot who knows. I’m surely not the only one doing this….

timeout units

Following a discussion on mythtv on #xfs (as you do), and a wondering of “hrrm… i wonder what unit that timeout is” with some NDB code I wish to make the following announcement:

All timeout values in NDB related APIs will now be given in centijiffies of the server system. For APIs that can talk to multiple hosts, it will be furlongs per fortnight.

I feel that having a consistent interface such as this will lead to much less confusion and better apps.

wordpress 2.1 and the world has not ended

hrrm… neato, upgraded to WordPress 2.1 and nothing seems to have exploded too spectacularly (in fact, everything works). yay!

interesting rhythmbox bug…

It continued to play Tool, but wouldn’t let me pause (or, indeed, call up the window from the systray icon).

Gotta love the taste in music at least.

Larger inodes make for (some) happy apps

Mikal talks about Ted talking about Tridge talking about how larger inodes can improve samba4 performance. Well, not just Samba4. Beagle and SELinux are also common heaver users of extended attributes which can often be stored inside the inode (e.g. on XFS).

There used to be the case where the Fedora installer would run mkfs.xfs with the default options and enable SELinux. Turns out this setup is great for systems without SELinux but the xattrs were large enough to require more space than what could fit in the inode, causing an extra block per inode to be allocated for xattrs. Not exactly space efficient.

The same can happen with Beagle. So if you’re using SELinux and/or Beagle and/or Samba4 – large inodes are probably going to be a winner for you.

I think we’re getting to the time where xattrs are popping up here there and everywhere for all sorts of applications and we’re going to have to find good (and efficient) ways of storing them.

I’m increasingly warming up to the idea of variable sized inodes. For a FS like XFS this could be done per group of inodes (XFS typically will, when more inodes are needed, create 64 inodes at once). File systems such as ext3 don’t really have this option as there is an inode table that is fixed and created at mkfs time. Although Ted has some interesting ideas for ext4 in this regard.

I’m sure Val Henson would have some interesting ideas for ChunkFS too…  a very interesting concept that I’ve been thinking about the possibility of retrofitting into existing systems (which I don’t think is that silly).

It would be great for some of the XFS dudes to write about the parallelising of checking an XFS file system.

Testing Cluster Certification exam questions

I (like several other of my co-workers) have over the past few days (since about Thursday/Friday IIRC) spent quite a few hours testing exam questions for the upcoming MySQL Cluster Certification exam.

Currently, I hold the record for the most correct answers (and number of questions that have been commented on). Yes, this is a direct challenge to other MySQLers to try and beat me.

For MySQL certifications, there is a giant pool of questions, a selection of which are selected for a particular candidate. So those brave few who go and test every single question spend a lot of time doing so to make sure the end exam is the best possible.

I’ve really grown to repsect the MySQL certs even more than I did before after being involved in creating one… we really try to make sure that to pass these you have to know and understand what you’re doing… no superficial stuff here.

Oh, and Roland is going to be giving a MySQL Cluster Certification Primer at the MySQL Conference coming up in April.

LCA2007 Photos

I’ve added a LCA2007 section to my Gallery with a bunch of photos I took at and around the conference. Feel free to have a look. I’ve posted a bunch of these to flickr already, so you’ve likely seen some if you follow my flickr feed.

Note that this gallery install is usually running a top-of-tree mysql cluster install on a box that has a bunch of other load on it… so things may work, may not – whatever :)

Those of you listening in on Planet MySQL – you should be able to spot a few other MySQLers around there, and there’s photos from the MySQL miniconf.

bitkeeper unlock -s magic

If you ever get something like this:

bk clone -lq ndb bug25567

clone: unable to readlock /home/stewart/Documents/MySQL/5.1/ndb

then try this:

bk unlock -s

to remove stale locks.

I have no idea how anybody is meant to come to the command from the error message… blindly guessing ‘bk help unlock’ worked for me though.

lca rocks

lca2007 already totally rocks.

did the speaker thing this morning, which was awesome (and i won’t spoil the surprise)

mysql miniconf today, should rock.

MythTV Tutorial final prep

Mikal and I are putting the finishing touches on our MythTV Tutorial for linux.conf.au 2007. Enjoy the piccies of the machines we’ll be demoing with…

dsc_6050.JPGdsc_6052.JPG

NDB! NDB! The storage engine for me!

Today I set up a mysqld connected to my not-quite-HA cluster at home here to replicate from my MythTV database into cluster. The idea behind this is to eat an increasing amount of my own dogfood around the house.

To do this, I also set up the MySQL Instance Manager to manage the now multiple instances of MySQL Servers on a box here. I found it a pain to do, it should be a lot simpler, but isn’t. At least now things are going okay…. but the feature wish list I have is rather long (perhaps I should hack some stuff up in this “spare time” i’ve been hearing so much about).

I’m also about 10 minutes (or however long the build takes) off moving one of the data nodes off the machine so it will be a real 2 node system (but I still have to move the management server to a third machine to have any real HA… and I have a PowerPC machine marked for that, I just have to await some patches to make it work :)

Currently though, my Gallery is being served off this. There are so many more photos I should add, I just haven’t come up with a decent way to interface f-spot and Gallery together – especially when I go back and retouch, delete or tag photos.

book writing tools

I’m involved in the authoring of two books at the moment – both using different tools, neither of which would be my choice if it was up to me. One is using DocBook, writing raw incredibly verbose XML… which honestly, isn’t that much fun. The other is in Microsoft Word (well, OpenOffice.org Writer for me). The last time I really used Microsoft Word really seriously was probably around 1998/1999 with Office 98 on the Mac. It was a pretty awesome suite of software actually. Especially after the update that fixed a few crashing bugs :)

One thing I do notice though is the collaboration tools in OOo Writer are nowhere near good enough. The notes are small yellow rectangles where you either have to hold the mouse cursor over them to read them (ick, slow) or double click them and scroll right forever to read the whole or in conjunction with the last way, use the object browser.

Also, track changes doesn’t really track changes to things you’ve changed. i.e. i cannot edit the same thing twice and keep both changes. urgh. I’m pretty sure MS Word let me do that… It certainly allowed me to use versions in a Microsoft Word format document – which, unfortunately, a lot of the world still primarily deals with.

If these few things were fixed it would be a much better word processor.

It’s always frustrated me how poorly word processors handle large files too (except perhaps Nisus Writer… that was certainly a neat app). Add a bunch of images and your file now takes ages to open and save. blergh.

As for figures in DocBook, there seems to not be much input and output processing… i.e. if you put in SVG and you output to HTML it doesn’t output very nicely (puts in SVGs into small windows) and probably completely doesn’t work on browsers that don’t do SVG.

I sometimes wonder if we’ve really moved on to something better than LaTeX and xfig…. okay, there are better tools than xfig for a large number of diagram types.

Feeling blergh and trying to work

Been feeling rather blergh all today – bit fevery and headachey all day. Managed to spend most of it lying in front of the TV. Bit of Seinfeld, Scrubs and now Buffy. Memorable lines from the current episode include “Q from Bond, not Star Trek” and “can you help with the thinking?”
Speaking of Star Trek, it’s been way too long since I’ve watched any of the original series… or Wrath of Kahn (which, incidently was mentioned in a Seinfeld I watched maybe today)…

ode to feelking ick and not making much sense.