We have released an update to Beta 5, which contains several bug fixes. This release is solidmysql-5.0.27-beta5-0040 (note 0040 instead of 0036 from the original Beta 5). You can get it from the usual place (http://dev.soliddb.com/download/). We also have new mirrors set up through sourceforge, which should improve the download speeds for people, especially for those who are in Europe or Asia. You can access the mirrors from the same download page. ¶

From Paul Kedrosky:

Does this mean you should move to the Bay Area? Maybe. Plenty of open source companies have successfully grown outside the Valley (actually, the most successful ones - Red Hat, JBoss, MySQL), but it's certainly the case that there's more venture money in the Bay Area than anywhere else.

Of course, the primary VC complaint is having to get on a plane for board meetings, so maybe it's enough to do what Zend, MySQL, etc. have done: move management to the Bay Area. They may well be the only ones who can afford it. :-)

ADVERTISEMENT
…

Nearly at the same time as the release of yesterday's XAMPP, the developers of ProFTPD released a new version of ProFTPD (1.3.0a). The new release fixes a security vulnerability which allows an attacker to install and run malicious code: More about the security vulnerability.

As usual, in case of security-relevant upgrades, we decided to release an suitable XAMPP upgrade as soon as possible. But to cut a long story short, here it is:

Download XAMPP for Linux 1.5.5a

Here's a way to write join clauses so they are more compact, more readable, and less confusing.

Many users may be unaware of the fact that there is a great tool for automatically testing MySQL called mysql-test-run. The most recent version of this program is written in perl and resides in the mysql-test directory of the MySQL source code tree.

Tests are written as scripts (.test files) which contains SQL statements and a number of meta-commands. Each .test file has a corresponding .result file which is used to verify the test output. A text-based "diff" is used to confirm that the output generated by the test is identical to the expected result.

To run a test mysql-test-run automatically sets up a clean environment and starts the MySQL server. It then executes the test scripts specified (by default all tests are executed) and verifies the output.

Most of the tests shipped with MySQL are intended to run with the MyISAM storage engine. There are also tests specifically created for other MySQL …

In MySQL Cluster a statement like

update t1 set counter=counter+1 where pk=1

can be executed in a few different ways with great difference in performance.

If we do it from the MySQL server then the update is implemented as:

read_ex(counter) ; //one round trip to MySQL Cluster, read with exclusive lock
counter++
update(counter); //one round trip to MySQL Cluster, update - write back


If we are using the NDBAPI (Cluster Direct API) we could implement it as above as well, but for the operation above, the NDBAPI offers a way of performing the update in just one round trip! This can be done using Interpreted Programs, which are instructions defined in your NDBAPI application and upon execute, sent to the ndbd kernel and executed there. Cool. What I will show you here is how to do an update using the interpreted program, which is called …

Few days ago I’ve started migration of some of my non-critical servers to Debian Etch (from Sarge). Just after first apt-get update && apt-get dist-upgrade, when apt has been upgraded, I noticed really strange (as for me) error: when I’ve tried to do “apt-get update” it worked fine, but there was annoying message like following:

# apt-get update
......
Fetched 5562B in 13s (421B/s)
Reading package lists... Done
W: There are no public key available for the following key IDs:
A70DAF536070D3A1
W: You may want to run apt-get update to correct these problems
#

UPDATE: Thanks to Kurt Fitzner we know, that:

There is already a mechanism to do this automatically:

$ apt-key update

This will obtain the necesary keys and import them. No need to go through gpg directly.

After not so …

Jon Stokes writes about this on Arstechnica, looking at a forthcoming Virginia Law Review paper entitled "The Piracy Paradox: Innovation and Intellectual Property in Fashion Design," in which two law professors investigate how the fashion industry manages to thrive despite rampant copying of clothing designs.

While it's not simply applicable to other areas (such as software), quite a few interesting observations are made - the most interesting (to me) is that making a generalistic presumption about needing very strong IP protection in order to drive innovation is just plain wrong, as the fashion industry proves. It may apply to other areas, but it's clearly not a universal rule.

I actually think that fashion and software have a lot in common, particularly in terms of the …

Continuent Sequoia, an open source database clustering solution, is part of a suite of Continuent.org open source projects that deliver high availability for virtually any database environment, including MySQL and its all engines (MyISAM, InnoBD, SolidDB, etc.).

So I've expanded the scope of the NDB/Python wrappers I was working on. Now I've got Python, Perl and C# wrappers working, at least for basic functionality. I've setup a trac instance and put a roadmap and all of that type of stuff up. If you are interested in hacking, let me know and we can talk about subversion access and all that.

For the moment, I've turned off code downloading. I'll post again when I've enabled it again.