The MySQL UDF Repository is moving forward! Although it was only recently launched we've been contacted by quite a few interested parties already.

For example, the MySQL Repository has been mentioned by Ronald Bradford in this week's Logbuffer, the "Carnival of the Vanities" hosted by the Pythian Group. Thanks Ronald!

To facilitate the community process, we've set up a Google Group. The …

Interested in the XPath support in MySQL 5.1?

I have done a little with XPath over the years, but I've never spent that much time learning it in any detail. Since we have added XPath 1.0 support I'd thought I would site back and and learn a bit more about it.

For an excellent Tutorial that covers all of the basics of node discovery it is best to first read:
http://www.zvon.org/xxl/XPathTutorial/General/examples.html

If you only read one tutorial, this is the one to read. It will get you through all of the basics of finding nodes and searching in deeply nested XML documents. I particularly liked this tutorial since the author had went through a lot of trouble to visually explain the results of XPath queries.
…

In my last post I reviewed how to create a test case using multiple connections and it is quickly apparent that keeping track of concurrent connections within test cases is difficult and error prone. Creating a tool to make test case writing easier and more automated is the goal of my Summer of Code project. To start, I have looked at the test facilities of PostgreSQL.

PostgreSQL and their documentation on their test framework was short, but it seems they have a regression test suite to test the functionality of their code.

http://www.postgresql.org/docs/7/static/regress.htm

They use a directory of .sql files that are executed against their database and the results, like MySQL, are compared against an file with the expected result. The tests can be run sequentially or parallel like the MySQL tests but overall their framework …

If I recall correctly, I saw a post about Amp'd Mobile going bankrupt, but now that I wanted to read it, it's gone. So how can this be? I thought they were doing really good especially since they were one of the winners at this year's MySQL Application of the year. I wonder what went wrong.

UPDATE:
The official statement from Ampd Mobile:

"As a result of our rapid growth, our back-end infrastructure was unable to keep up with customer demand. We are taking this step as a necessary and responsible action to sustain and strengthen our momentum in the market place".

Ok, Now I am really curious. Which part of backend? Network? Application? Storage? ... Database?

And whatever these backend scalability issues were, why weren't they actively resolved? Could making a company scalable drive it bankrupt? If not, then …

Are you using the mysql-5.1-backup-prototype clone on http://mysql.bkbits.net/?
We recently fixed this clone by removing a changeset, so you need to reclone this if you are using it. Sorry for the inconvenience.  (By the way, if you use this clone, let us know what you think about it…)
More information about the Online Backup project is on MySQL Forge: http://forge.mysql.com/wiki/OnlineBackup

This is not strictly speaking about open source, but for anyone running a new Windows machine, it's a big issue.  PC Decrapifier is a free software which helps remove all the "craplets" (crippleware applications) that are installed when you buy a new PC.  Kudos to Walt Mossberg from the Wall Street Journal for helping to fight the fight against crapware.

"The problem is a lack of respect for the consumer. The manufacturers don?t act as if the computer belongs to you. They act as if it is a billboard for restricted trial versions of software and ads for Web sites and services that they can sell to third-party companies who want you to buy these products."

One …

And then there were two (software patent deals with Microsoft). Today, Xandros made its first newsworthy announcement in 10 years and indicated it has capitulated to Microsoft. I love how Microsoft tries to blur the lines between its patent folderol and interoperability agreements (notice how it tries to obscure this in the press release, talking about Novell, Xandros, XenSource (no patent agreement), JBoss (no patent agreement), Zend (no patent agreement), etc. They talk about them all as if they're the same thing, but they're not. The smart companies are buying into interoperability, not FUD. Yet Bill Hilf persists:Customers win when... READ MORE

Some applications require direct access to a block device, without an intermediate file system. Some Oracle and MySQL configurations are an example, as are some Xen setups, or IET. Can you do this with DRBD? Sure you can.

However, you need to fulfill two prerequisites:

1. Your application can’t access DRBD while it’s in the Secondary role. So, you must make sure DRBD is Primary before your application attempts using that device.
2. The user in whose context your application runs needs read/write access to that device.

Your cluster manager, when configured properly, normally takes care of item #1 for you. #2 is a little trickier:
Normally, DRBD’s device nodes are owned by root:disk, with permission bits set to 0660 (rw-rw----). So in order to allow your application to use the device, you have two options:

• Add …

A question I recently got from our friends at MySQL:

When speaking about DRBD, we mention that if you upgrade your Linux kernel, it is important that you also upgrade the version of DRBD appropriately.
Question: When upgrading the kernel via yum/yast, does it automatically detect that you should also upgrade your DRBD module?

The answer is, as always, a clear and resounding “it depends.”
Let’s break this down by distribution.

• If you’re on Debian and updating your linux-image package, dpkg will complain about an unresolved dependency from the DRBD kernel module package, forcing you to update that as well.
• If you’re on Debian and adding a more recent linux-image package, it’s up to you to remember to install a new DRBD kernel module package as well.
• If you’re on …

A few days ago, Alexander Barkov pushed some changes to the MySQL 5.1 tree that I’ve been waiting to see for some time — variable support for XPath functions used with ExtractValue() and UpdateXML(). (This was a fix for Bug #26518, BTW.) This will be available in MySQL 5.1.20 (or grab the MySQL 5.1 source from bkbits and build it yourself, if you just can’t wait).

Two slightly different notations are supported, depending on the context, and what sort of checking you want done on the values:

1. If you don’t want or need type checking, prefix the variable name with $@, like this: $@myvar. However, if you do this, and you make a typo, you’re on …