MySQL AB :: MySQL: The World’s Most Popular Open Source Database
The cool thing is I wasn’t the one who noticed it. A holler goes out to Timmeah!
MySQL AB :: MySQL: The World’s Most Popular Open Source Database
The cool thing is I wasn’t the one who noticed it. A holler goes out to Timmeah!
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!
so he remembers
Denial Of Sushi Attack
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:
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 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.
“there’s nothing here i can eat for morning tea, could I please get an apple?”
“no”.
fuck.
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.
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
“Not good to hear Monty arguing with Brian…”
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.
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: 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 quitweb=# 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?