Got to love unicode! Importing Ken Ishii’s Jelly Tones album (btw, I won it at Studio Brussel in Belgium sending an email through BBS, somewhere in 1995!) I saw following in iTunes: Found it pretty cool that ケン・イシイ shows up! I’m leaving as is. The Composer field is filled with ‘Ken Ishii’, so looking it up still works.

We’ve added some new options in MySQL Cluster 6.3.22 which makes it possible to selectively restore tables. The new options for ndb_restore are: --include-databases=name Comma separated list of databases to restore. Example: db1,db3 --exclude-databases=name Comma separated list of databases to not restore. Example: db1,db3 --include-tables=name Comma separated list of tables to restore. Table name should include database name. Example: db1.t1,db3.t1 --exclude-tables=name Comma separated list of tables to not restore. Table name should include database name.

Just a small tip for using Bazaar on OpenSolaris: set the BZR_SSH environment variable to openssh if you don’t have the Python module Paramiko installed. For example, in your ~/.bashrc: export BZR_SSH=openssh Could be useful if you’re pulling MySQL stuff from Launchpad and use (Open)Solaris. Could also be useful on other Unix-like operating systems when the default is missing (Bazaar uses Paramiko as default).

Today I gave an introduction talk of MySQL Cluster at FOSDEM 2009 in Brussels. The room was full and I didn’t see anyone dozing! A good feedback later on was to show more usecases. This a good point and I think on working on a talk showing less how it works, but how it can be used. Doing both technical details and use-cases is hard to do in 50 mintes.

Since MySQL Cluster 6.2 it is possible to setup a pool inside the mysqld process opening multiple connections to a MySQL Cluster. This is pretty cool, but it might give troubles when you have to use Single User Mode. Take for example the following configuration for your SQL Nodes: [SQL] Id=10 Hostname= 10.100.9.6 [SQL] Id=11 Hostname= 10.100.9.6 [SQL] Id=12 Hostname= 10.100.9.7 [SQL] Id=13 Hostname= 10.100.9.7 No further slots are defined, and you setup your two MySQL Servers to use connection pooling: