Famous on dev.mysql.com

MySQL AB :: MySQL: The World’s Most Popular Open Source Database

Screenshot.jpg

The cool thing is I wasn’t the one who noticed it. A holler goes out to Timmeah!

Interesting SSL with Australian System Administrator’s Conference 2006

The Australian System Administrator’s Conference 2006
It’s interesting that the online registration doesn’t have an SSL certificate that matches. I now have to find a printer to produce dead tree to mail.

Considering that I don’t actually own a printer, this is getting interesting…

P.S. come to my tutorial on MySQL Cluster!

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.

talk went well

I can relax now, My talk is done and I’ve been talkinq to people about more specific things. Several have congratulated me on it.

Looking forward to the BOF, although sleep would be nice.oh how I’m going to sleep on the plane

About a third of the keynote room at MySQL UC

DSCN8983.JPG

It should be also noted that showing up can win you stuff. Mikal did a survey thing ore something and his name has been flashing up on the screen saying he’s won stuff. Don’t know if he knows yet :)

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.

Welcome to the USA

Today my TV told me to be scared, I had a good (late) sandwich for lunch. Some nice local beer (no big brewery), a salad and the most scary looking pasta for dinner. Also hung with people. Now sleep.

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?