OmniSQL (a command line tool for DBAs needing to issue ad-hoc queries against sharded data) version 0.0.7 is officially released. Instead of logging in separately to multiple databases to issue the same query, groups of databases can be specified in a configuration file and queries will be automatically issued against all targeted MySQL instances. Let me know [...]

Don MacAskill at SmugMug updated his blog a while back on ZFS and MySQL to include information on compression.  From his tests, he found that LZJB was a better choice than gzip -- performance improved while still leaving room on the CPU.  This was using InnoDB tables. 

See the full details here.

Recipe for conference talks: add a buzzword like "sharding" and show how mysqlnd helps you with asynchronous queries. Only two PHP database extensions give you asynchronous queries: mysqlnd and Postgres. Slides (OpenOffice) from the International PHP Conference 2008 have the details about the asynchronous query API in ext/mysqli (using mysqlnd).

Mysqlnd Async Ipc2008

View SlideShare …

Greetings! I have released Version 0.7 of the Memcached Functions for MySQL. This release mainly consists of modifications to the autoconf/automake files that caused some users problems linking to libmemcached, hence the UDFs failing. This should fix that problem, although I would like to make the "fix" I made a better fix.

BTW, did I mention how much autoconf/automake perplexes me and drives me crazy at times?!

The release can be found at:

http://download.tangent.org/memcached_functions_mysql-0.7.tar.gz

As well as

http://patg.net/downloads/memcached_functions_mysql-0.7.tar.gz

Could Linux be the key to instant-on for Windows laptops? READ MORE

The InnoDB plugin is now merged into the Drizzle mainline. There is still one weird outstanding bug that I know of. Why is this exciting? The main things found in the plugin that I'm excited about are:

• New compressed table format.
• Adding or dropping indexes can now bypass the table copy
• Information Schema plugins with InnoDB internals data

Not to mention, something tells me that the plugin will be getting more dev attention, and should be easier to track moving forward.
I've been doing my best to make the changes in such a way that they could be potentially merged back into the plugin upstream, should Oracle care to. (which I hope they will)

The InnoDB plugin is now merged into the Drizzle mainline. There is still one weird outstanding bug that I know of. Why is this exciting? The main things found in the plugin that I'm excited about are:

• New compressed table format.
• Adding or dropping indexes can now bypass the table copy
• Information Schema plugins with InnoDB internals data

Not to mention, something tells me that the plugin will be getting more dev attention, and should be easier to track moving forward.
I've been doing my best to make the changes in such a way that they could be potentially merged back into the plugin upstream, should Oracle care to. (which I hope they will)

It just goes to show that code isn’t the only way to contribute. Mike Shadle recently did some leg work the Drizzle world by not only fronting the domain cost for drizzle.org, but also in actually negotiating down the guy who owned it already. That being done, the time has come (if you’re so inclined) to chip in and help defray Mike’s out-of-pocket.

The goal is to raise roughly $1000 USD to cover the domain + Escrow costs. I’ve already said I would contribute a chunk of that. Please include in the PayPal description your full name/company/whatever identifying information you’d like and if you’d like it recorded, and I will record it and if the Drizzle guys wish, we can post your info on the [not established yet] website as a Drizzle supporter.

If you’ve got an extra few buck lying around, please feel free to …

I had so much to say in response to a recent post asking about virtualization from Jennifer Glore that I realized it was long enough to be a blog post.

It really depends on what you’re looking to do. Many companies don’t have the money and staff to have an in-house data center with proper power and network redundancy; others don’t want the depreciation associated with owning computer hardware (even if they leased space in a data center, they’d have to buy equipment to put in it).

Some reasons to virtualize:
1) you need a fresh machine and cannot wait to order a new one or re-purpose an older one.
2) your need for machines/services fluctuates (and again, re-purposing takes time). This need can be as broad as employee desktops or as …

OpenSQL Camp is a free unconference happening Friday, Nov. 14th through Sunday, Nov. 16th in Charlottesville, Virginia, USA. More details can be found at http://www.opensqlcamp.org.

Whether or not you have already registered for OpenSQL Camp by putting your name here:

http://www.opensqlcamp.org/index.php?title=Events/2008/AttendeeList

you should be aware of very important information.
(more…)