The Lua plugin support has been finally fixed and will be working in the next release. Together with a few other improvements, it’s now possible to write your own commands to do all kinds of tasks. Documentation for the plugin system is not yet written (and the previous one is outdated), but it should be straightforward to copy the supplied Lua plugin and change it to do something else. All you need is to know a little Lua (which is a simple scripting language) and explore Workbench internals using the GRT Shell (View -> Advanced -> GRT Shell).The sample Lua plugin is located in the modules folder. You can copy it to the custom plugins folder which is shown in the GRT Shell at startup and change things like the module name and add your own functions. I’ll write more about how to write such functions in a future post, like after the next WB is actually released.There are a few ways that plugins …

The listing of Dynamic System Variables on the MySQL Reference Manual’s page is supposed to show those variables you can change on-the-fly. innodb_data_home_dir is listed there as a dynamic variable, but it is not one, and trying to change it on-the-fly doesn’t work:

mysql> set global innodb_data_home_dir="/data/mysql/data"; ERROR 1193 (HY000): Unknown system variable 'innodb_data_home_dir'

mysql> set session innodb_data_home_dir="/data/mysql/data"; ERROR [...]

Some people obviously think I`m still interresting enough to interview

Reminds me of my first interviews over a decade ago .. I`m still being remembered by one of my famous quotes back then rougly translated to "those toddlers steal my bandwith" , when being asked about how the growing userbase of the KULeuven PC rooms in the Dekenstraat influenced my network usage :) (Think 1994 ish :))

But the acutal news is that Profoss is coming closer and closer .. and you should now Register!
So all you Drupal and MySQL folks out there.. this is your chance to learn about virtualization !

By Tim O'Reilly

I was looking the other day at our internal sales reports, and thought I'd offer a few random reflections based on our changing mix of bestsellers. This is anecdotal data, and for O'Reilly books only, not to be confused with my State of the Computer Book Market posts. (Mike Hendrickson and I are working on one of those as well.) Nor is this a complete list of our bestsellers. It's a list of books that say something to me about the changing mix of needs and interests among our customers.

Mac OS X: The Missing Manual, Leopard Edition. Published just before the holidays, this book sold out of its 50,000 copy first printing in a matter of days. It's topped the …

For some reason, Germany and Open Source go very well together. That’s one of the reasons I moved to Germany a good year ago.

Now, I note a new Open Source marketing consultancy popping up in southern Germany. Not that such companies are very tied to geography. It’s Sandro Groganz, of Mindquarry and eZ Systems fame, who has set up shop.

Sandro will help companies and organisations, both in their capacities as creators, contributors, and investors. Read more about this on his well-organised blog. Good luck, Sandro!

There is a lot of information out there about how to setup circular replication but nothing about how to recover it when all else fails. This article will cover a quick and easy method I use. Depending on the size of your database and the interconnects between servers this method may not be suitable due to the need to copy all replicated databases from one good server to all other servers in the replication circle which requires a certain amount of down time respectively.

OK, so one server or more is showing Slave_IO_Running and/or Slave_SQL_Running as No and there is some error about a failed query when you run "show slave status;" and no amount of effort to fix it is working. First DO NOT PANIC. It is broken, OK, tell yourself that and realise that trying to fix something when you are in a panicked state is only liable to make the situation worse, hell I'd guarantee it, so …

How can software vendors engage with the open source community? An important step, according to Linus Torvalds, is to stop believing such a thing really exists and start engaging in the development process.

The Linux Foundation has kicked off its new Open Voices podcast series with an interview between executive director Jim Zemlin and its most famous employee: Linus Torvalds. The interview is available in MP3 and Ogg, as well as a transcript and provides some interesting insight into the Linux development process, Torvalds’ motivation, and the past and future of Linux (as well as …

I’ve just tried to run PHP with MySQL on my Leopard and the first problem: “Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’”

I’ve just changed php.ini to:
mysql.default_socket = /tmp/mysql.sock
The same situation with mysqli settings - be default it is not set so you should update it to the real path.
And it works!

One of my first tasks in my new position as Senior Programmer at mybanker.dk is to evaluate and/or create a CMS framework for upcoming versions of the several websites that we present to the world.

After evaluating the first many available frameworks and CMS systems out there. this entry, found on Planet PHP somehow seems to strike a cord or two…

I was reading through Expert MySQL over Christmas, and I thought I'd write a patch to solve some of the connection pooling problems I've mentioned earlier.

It was surprisingly pretty straight forward. Let's hope someone can clean it up, and reset connection is implemented into MySQL 6.0.