So… stealing the idea from Peter, does anybody have any suggestions for MySQL Cluster related things to have at the UC next year (April)? Either leave a comment or email me (first name at mysql dot com).
Author Archives: Stewart Smith
Practical MythTV for $14.95US
Julie at Apress let me know that over at Bookpool: Practical MythTV: Building a PVR and Media Center PC they’re having a big sale of Apress titles, including Practical MythTV.
So over there now for (a bit) less than $15US you can get Practical MythTV. Pretty neat. So everybody should go buy two copies (buy one get one free… right? :)
At some point soon, I’ll even post how I go with upgrading my MythTV box to Ubuntu 7.10 (Gutsy)… once I gather up the courage to do so :)
Problems with Tracker (and why I’m back to Beagle)
- If you have more than 8192 directories, it can’t monitor them (max inotify limit)
- No search results
- access(), stat() and then lstat() called on *every* file that it’s going to index… this takes a long time.
- Did I mention that search doesn’t actually give you any results?
- Even when you run strings on the database and then search for something there, you don’t get any results
- Even when you search for the name of an application, you get no results.
Everything that’s wrong (and right) with Ubuntu Gutsy
So, I’ve upgraded two boxes: my laptop and my mail server.
Wrong:
- courier-imap-ssl broke. My cell phone could no longer pull mail.
I got something like in the log:
imapd-ssl: couriertls: connect: error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number
The fix for this is to change the TLS_PROTOCOL option in /etc/courier/imapd-ssl to SSL23 (an option not listed in the “possible verions” list in the config file). So mail now works. - Evolution now seems to put a blank line at the top of emails when replying (before quoting the message). GRRRRRRR…
- The Window Manager (metacity) has changed how it arranges new windows. Instead of cascading them down, so if you’re opening a bunch you can easily switch between them, it now puts them right on top of each other GGRRRRRR.
- It set up my Xorg to *not* to X monitor hotpluggy goodness. I’ve managed
- Login seems to take a fair bit longer than before
- Tracker
- trackerd will index while on battery power… GRRR
- trackerd will hog disk and CPU
- I haven’t been able to get any results out of tracker.
- There is no tracker-status or something to check that it hasn’t just stopped working
- Tracker will use up all your remaining disk space… (I initially only had a few GB free.. and trackerd filled it up)
- I haven’t actually had a query work at all. i.e. it seems to be useless. I just get a “trackerd exited with status 0”.
- There is no “remember passphrase” button in Evolution for GPG signing anymore. I think this is now set in the global preferences… but the behaviour change is annoying.
- The pidgin icon is different than the gaim icon in the Notification Area… this is annoying as I can never find it anymore
- The Window List applet changed behaviour to now *not* group windows together at all… making having lots of windows open (as I often do) completely unmanagable as opposed to (previously) just annoying.
The Awesome:
- X monitor hotpluggy goodness (known to others as xrandr 1.2). VGA out works with the free radeon driver now! *YAY*. (I can rearrange screens using xrandr… awesome)
- Pidgin is quite nice… the likelyhood of reply plugin is neat. More compact IM windows (also cool).
- Syncing between Pidgin and Evolution with contacts seems to work okay now.
- Suspend and resume still works
- New version of f-spot – goodness!
- New OpenOffice.org (2.3)Â sucks less.
- emacs22 (shiny)
- New WINE does real neat stuff (such as have menu items for browse C drive, remove software)
- Evolution doesn’t seem to leak memory as much anymore. Only 316MB RSS at the moment!
- Lots of neat Liferea bug fixes – much nicer! (read items in the planet.linux.org.au feed stay marked read now!)
MySQL 5.1.22(ish)-stew1
I’ve decided to publish my patch series. The goal of the -stew patches is to collect things I find interesting and that at some point could (should) make it into the main MySQL tree (even if others don’t think so).
It’s not designed for use in production.. I don’t really care if there’s failing test cases…. if it builds it’s perfect.
It includes the following which could be interesting:
- Removal of ndb_use_exact_count (performance for NDB)
- NDB node status in an INFORMATION_SCHEMA table
- Compressed Backup and LCP for NDB
- Cluster log as CSV
- Skeleton Engine
- MyHTTP Engine
- PBXT Engine
- Skeleton of MyBS support for NDB
- (in the hope that somebody finishes it)
Currently the additional engines have to be built separately in their storage/ENGINE directories. I have some preliminary patches to get them to build in-tree via the plug.in file, but it’s not finished (patches welcome).
This is all currently based off the 5.1-ndb tree. In future, it will likely be based off 5.1-telco.
 http://www.flamingspork.com/mysql/patch-5.1-ndb-stew1-20071016.patch.gz
and broken out in:
http://www.flamingspork.com/mysql/patch-5.1-ndb-stew1-20071016/
(including the not-quite-working ENGINE_in_tree_build patches)
Known to apply against this tree:
http://www.flamingspork.com/mysql/mysql-5.1-ndb-20071016.tar.bz2
Comments, thoughts, patches to include, all welcome!
OpenOffice.org 2.3 better than 2.2
I wouldn’t yet say “brilliant” but I’d certainly say “less crap”. I haven’t (yet) completely stabbed it for being stupid.
xkcd – little Bobby Tables
Today’s xkcd is just wonderful. I think we need giant ones of these on the wall of offices around the world.
Jetlag (and recovering from it)
I am very good at just staying up late to adjust to a timezone. I can do this fairly reliably. Going to the US and Europe can be done by this method (rather well). Coming back is another story though. Going to sleep at an earlier time (for me) doesn’t come easy. Grr…
Compressed LCP and Compressed Backup (and switching them on/off online)
Quick experiment with online changing of enabling/disabling compressed backups and local checkpoints (LCPs).
Backup is incredibly trivial and correct (even have some nodes do compressed, some not).
LCPs are a bit trickier when it comes to restore… currently how the code sits is that a block using the compressed file interface in NDBFS must specify if it wants to use the compressed read/write interface or not. So when you have LCPs that differ in compressed/non-compressed than the current config file setting, you’re not going to be able to restore them (although setting CompressedLCP=1 should let you restore either compressed or non-compressed LCPs).
At some point, I’ll probably move AsyncFile (our async file IO class) to just use azio alway, and modify azio to be transparent for non-compressed files…. I just have to fix up azio for direct io.
I feel dirty
but I’m going to write it anyway…. “I think this is the best phone I’ve ever owned”. It’s about a device running Windows Mobile. Would I say it was “good”… hrrm… not sure… “okay” at least. It would be “very good” if syncing with my Linux desktop worked remotely easily.
One thing i love is that from the home screen (Welcome screen in WM5 language) you can start typing and you can choose to either dial that number, or choose from the search of your address book that just happened. Awesome. No jumping through menus just to search the address book!
If anyone knows how to make the in-built email client not do outlook style “include message in reply” and instead actually quote the message, i’d be rather grateful.
fring is also a rather cool IM/VoIP app that I can see myself making a fair bit of use of when on a WiFi network around the place (and IM on the go over GPRS).
I just have to go and get a 3G SIM card to make data work…
Changing the Windows Mobile 5 Internet Explorer Home Page from Linux
synce-registry -w HKLM Software/Microsoft/Internet\ Explorer/AboutURLs home ‘http://www.google.com.au/m’
Why you have to edit the registry to change the home page is certainly beyond me.
Things that break while travelling….
This year, it seesm that whenever I go out for significant travel, the following things will break on my trip:
- a laptop power supply
- a disk
At least this time the disk is part of a RAID1 array.
Oh, and for some reason my mythbackend stopped doing anything a few days ago…. and I wasn’t checking it. grr… annoying. At least there’s not much on TV.
Lack of Music while hacking at conferences
I need hack time with music as the only other thing going on.
I just stuck my earphones in for the first time since I got here and pressed that button on the ipod that makes Tool’s 10,000 Days start playing. Bliss, pure hacking bliss.
Monty Taylor’s UC2008 talk
possibly:
“Achieving Web 2.0 Social Networking Synergies with NDBAPI through MySQL Proxy”
(yet another possible cool thing coming from a quick hack at DevConf)
ndb_mgmd on Win32 (an Alpha)
So, here is an Alpha quality port of the MySQL Cluster management server to Win32 based on the current MySQL 5.0 tree.
This isn’t going into 5.0, so don’t expect to ever have that.
This isn’t going into 5.1 either, so don’t expect it there.
It’ll go into some future release at some level of general “supported” status that has yet to be decided.
ONLY USE THIS FOR EXPERIMENTAL PURPOSES.
IT IS EARLY RELEASE – IT HARMS PUPPIES!
But, it would be great for those who may be interested in having a ndb_mgmd on Win32 at some point to grab the binary, have a play and find some bugs.
For any bugs filed, please submit to bugs.mysql.com and explicitly mention that it’s version “5.0.50-ndbwin32r1” and mention that it’s the specific build (i.e. it shouldn’t go through the normal bug verification procedure and instead end up with me looking at it directly).
So, here’s the files:
- Patch series
http://www.flamingspork.com/mysql/mysql-5.0.50-ndbwin32r1/patches - Source tree used to build (11.8MB):
http://www.flamingspork.com/mysql/mysql-5.0.50-ndbwin32r1/mysql-5.0.50.tar.gz - Built source tree (the ndb_mgmd.exe, all the intermediate object files, symbol files and whatever else cmake and Visual Studio go and create) (32.7MB)
http://www.flamingspork.com/mysql/mysql-5.0.50-ndbwin32r1/mysql-5.0.50-ndbwin32r1-built.tar.gz - Just the executable (ndb_mgmd.exe – debug built) (3.2MB):
http://www.flamingspork.com/mysql/mysql-5.0.50-ndbwin32r1/ndb_mgmd.exe
Hopefully this brings you joy.
Oh, and yes, you can go and run it under WINE so you don’t have to actually use MS Windows.
enjoy!
I wants me a sticker…
“MySQL Cluster: We don’t need no stinkin FOREIGN KEYS”
and, of course: “Ban HP-UX Now!”
Any design for a “I’m Highly Available” shirt is pure speculation…. but totally awesome (and a cookie for anybody who a) makes them or b) wears them)
ratting on “leading” platforms…
Yes, I really, really really dislike the Microsoft Windows platform. I think you have to approach insanity to even remotely consider using it in a HA environment.
That doesn’t mean that we shouldn’t support it. Switching an entire software stack can be a lot of work. Much better to gradually move to complete freedom and sanity.
MySQL Cluster (NDB) on Microsoft Windows
Well… there’s been some work. Even some in-progress patches. Being involved with this has just perfectly refreshed my memory of why I left the platform. Oh my it’s a horrible, horrible platform. Everything from UI to API… ick.
Expect something around soon….
Photos from UC-J
Go see either my Flickr stream, and I’ll get things onto my Gallery as well.
In Tokyo for the MySQL User Conference Japan
Arrived early morning, not much sleep, took forever to get to hotel and then had to wait for room (double not happy), got some work done in the office and am now in desperate need of sleep before a way too early start.