Cool Dolphin SCI interconnect stuff

http://www.dolphinics.com/ make this cool SCI socket hardware that can be used with MySQL Cluster (for example, like their example setup).

Their tech provides high performance (350MB/sec avail to the user) and low latency (worst case is like 2 or 3 micro seconds to send 512bytes to another node). So can pretty much kick the butt of gig-e.

We could probably do some really cool stuff with boosting performance (even further) when using SCI with some of the things I have in mind for multithreaded ndb kernel – basically changing some of the ways we do sending and receiving signals and improvements in shared memory stuff.

Big points from the presentation are:

  • small messages sent using basic CPU instructions (it’s remote memory mapping)
  • low cost to write to remote memory address
  • raw worst case send latency for 8 bytes is about 210 nanoseconds
  • no need to lock down or register memory
  • TCP/IP processing not done in software
  • Just LD_PRELOAD the library and it does your (user specified) Ip communication over the SCI interconnect
  • can be fully redundant (dual cards, distributed switching)
  • each card is about 5w of power (rather insignificant compared to other techs apparrently)
  • really small time for failover

It’s also good to note that 10 gigabit ethernet doesn’t really buy you anything in reducing latency. SCI gives you both improved bandwidth and latency.

People looking into wanting more performance in MySQL Cluster should have a good look at it.

It’s also used in fighter planes – which make cool loud jet noises.

(err… i didn’t mean to sound to rah rah. hopefully i’ve just sounded like i think the tech is shiny)

UPDATE: corrected milli to nano.

UPDATE mk2: corrected nano to micro. Oh how I wish I just typed correctly to begin with. At least I’ve had some rest now :)

Mike Hillyer’s laptop melting and backup fun at UC

Mike Hillyer’s Personal Web Space » Blog Archive » It’s Alive!!

Mike’s laptop went funny, but he had a backup of his presentation.

So, something about my backup strategy.

I have a policy that anything that I really care about is backed up. If it’s not backed up, I don’t care about it.

e.g. while I’d be sad if my mythtv box suddenly had a disk failure, I can always put in a blank disk and I don’t loose too much.

My email is fetched onto a server at home, and I use offlineimap to keep an up to date (nearly) copy on my laptop. I also, at least weekly, burn the entire thing to DVD (it still fits, when bzip2 compressed).

Also, for all that other stuff that is pretty important (/home), I do a xfsdump to external disk.

I also now (on a paranoid spending trip at Fry’s) have a small portable drive that is roughly twice the size of my /home partition. The idea is that on the road I can regularly do an xfsdump to this  – in fact, two complete dumps (and one or two incrementals on it).

Call me paranoid, but I like my data.

I also make sure I burn photos to DVD, but that’s more periodic as there’s a lot of them now.

All your Cluster BOF is belong to us

So, we had a really good Cluster BOF last night. Started at 8:30 and at 11pm everybody was tired enough to go to bed :)

Healthy mix of people with deployed clusters, prototype clusters and even some who have looked at MySQL Cluster in the past, decided it wasn’t for them at that point in time, but are still interested enough to show up to the BOF.

It was really freeform (as in I got up and said “there is no agenda for this – what do we want to talk about?”).

We got some really valuable feedback about what people like, dislike and even did hands-up polls of “what do you want us to do first?”. Also got some good suggestions on what to tweak (small fixes) to make people’s lives a lot easier.

The room was pretty well populated as well. my guess was half full (which means nothing until you see the size of the rooms. i’ll try and get a photo at some point).

The consensus at the end seemed to be that people found the BOF valuable as well.

I’d love to hear further feedback. Be brutally honest too.

My UC Talk tomorrow (what you should know)

MySQL Users Conference 2006 – MySQL Cluster: New Features and Enhancements

If you are coming to my talk, make sure you know a bit about cluster beforehand. Being at Johan’s talk today was a good idea.

Or reading the manual chapter.

Otherwise you may end up being quite lost for a lot of the talk. Mine isn’t an intro to cluster one.

PostgreSQL 7.3: SQL Key Words

PostgreSQL: Documentation: Manuals: PostgreSQL 7.3: SQL Key Words

It’s very annoying that ‘user’ is a reserved word in postgresql. You also get really crappy error messages (at least with the various forms of quoting I’ve tried to use) when you try to create a table called ‘user’

$ psql web
Welcome to psql 7.4.8, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

web=# create table user (a int(10), b int); ERROR:  syntax error at or near “user” at character 14
web=# create table “user” (a int(10), b int);
ERROR:  syntax error at or near “(” at character 27
web=# create table ‘user’ (a int(10), b int);
ERROR:  syntax error at or near “‘user'” at character 14
web=# create table `user` (a int(10), b int);
ERROR:  syntax error at or near “`” at character 14
web=#
web=#

You will even get the “at character X” if you’re piping something into psql. Hrrm… a line number would be useful.

It also means that I can’t compare results from MySQL and Postgresql involving a table called ‘user’. Bummer.

Any postgresql gurus out there got a solution for me?

Boys Don’t Cry (She’s the Man) and other such cross dressing.

Boys Don’t Cry (1999)

Found the name of it! After seeing She’s the Man on Monday night we were discussing other movies where a girl has dressed up as a guy – and I was trying to remember the name of Boys Don’t Cry – I remembered Hillary Swank’s name though.

She’s the Man was an okay flick. Maybe 2 stars. I think Amanda Bynes should be in better films – something the two friends (both female – I wonder if this has anything to do with it) I went with disagreed with me on her acting ability.

But let’s face it – anything with Vinnie Jones in it is worth a look. Especially if it includes Soccer or killing people.

parent hacks: Cottonelle Kids shows kids how much toilet paper to use

parent hacks: Cottonelle Kids shows kids how much toilet paper to use
“Also, I buy the kind with aloe. If you’re sweet to your bottom, your bottom will whistle a happy tune.”

This gave me a good chuckle.

There has been way too much discussion about toilet habits in the free software community this year. Perhaps it was just the descriptions of gastro on the lca delegates list.

Mikal has also blogged about this.