The last two Pop Quiz entries seem to have garnered some interest, so let’s do another one.

Today’s question is quite short: What is the maximum amount of data you can store in a MyISAM table?

(more…)

Since PlanetPlanet aggregation for open source projects worked so well, why hasn't someone considered to do the same for the life casting sites? (Twitter and such...).

mysqllife.org? Peel the meme's tagged as MySQL off from twitter and put them in a stream to watch?

I've started testing the new Release Candidate (5.1.23) today. This was a version with a huge amount of fixes relative to latest MySQL releases - but I didn't expect to run into two bugs this fast.

• Bug #34626 which I just filed in today and was already verified. This is a basic scenario which is used in the deployment scripts we use at Delver. Just try and pipe an empty file into the mysql command line client - and it crashes.
• Bug #32633 which was apparently fixed in 5.1.24, and should have also presented itself in 5.1.22, but didn't for some reason. The upgrade brought it up.
  This one basically means that you just can't create …

Master-Master Replication With MySQL 5 On Fedora 8

This document describes how to set up master-master replication with MySQL 5 on Fedora 8. Since version 5, MySQL comes with built-in support for master-master replication, solving the problem that can happen with self-generated keys. In former MySQL versions, the problem with master-master replication was that conflicts arose immediately if node A and node B both inserted an auto-incrementing key on the same table. The advantages of master-master replication over the traditional master-slave replication are that you don't have to modify your applications to make write accesses only to the master, and that it is easier to provide high-availability because if the master fails, you still have the other master.

Master-Master Replication With MySQL 5 On Fedora 8

This document describes how to set up master-master replication with MySQL 5 on Fedora 8. Since version 5, MySQL comes with built-in support for master-master replication, solving the problem that can happen with self-generated keys. In former MySQL versions, the problem with master-master replication was that conflicts arose immediately if node A and node B both inserted an auto-incrementing key on the same table. The advantages of master-master replication over the traditional master-slave replication are that you don't have to modify your applications to make write accesses only to the master, and that it is easier to provide high-availability because if the master fails, you still have the other master.

Last week I uploaded MySQL 5.0.51a-1 to Debian unstable. Usually not worth a separate blog entry, but in this release I included the patch for MySQL bug #4541, which was opened more than three years ago. The problem results in an error like this, e.g. when migrating a database from latin1 to utf8:Specified key was too long; max key length is 1000 bytesThe patch from Ingo Strüwing now included in Debian raises the maximum key length to 4005 bytes or 1001 UTF-8 characters. It will not go into the official MySQL source repositories because it results in bigger buffers and as such increases memory footprint and decreases performance. See the bugreport for further details.

Update: After some criticism …

Since I wasn’t really blogging back then, I forgot to mention that Alert Logic received a great review at Security Magazine in its April 2007 issue. We got a “Best Buy” rating when compared against some of our competitors.

We were all very proud of the new releases of Threat Manager over the past year, so it was very good to be recognized for the work. A perfect score, no less! All 5 stars.

Velocity is the new O’Reilly conference aimed at discussing topics related to scaling web sites and applications on the Web. It seems really interesting, and I will try to attend.

Having access to some of the industry’s experts in scaling web sites will be really useful. In fact, Steve Souders is one of the program chairs of the conference, and he is also known as the creator of the very popular YSlow extension to Firefox.