What I really like about having Lua and MySQL Proxy together is that it turns out to be very flexible, you can have the proxy do all kinds of things. And the last thing I made the MySQL Proxy do is to act like memcached.

Well, maybe not, but it handles key => value pairs now :P




What does it do?

It handles 5 basic query types:

mysql> INSERT "key" = "value";

Very simple, insert a key => value pair on a proxy.global.db table, if there is already a value for that query, it will overwrite it.

mysql> SELECT "key";

It retrieves the value for the specified key.

mysql> DELETE "key";

Deletes the key …

On my last count, there are now 20+ Sun Contributor Agreement (SCA) signatories whose names appear on the master list and who are interested in contributing to MySQL. Only this week, three new members signed the SCA.

These 22+ signatories have all been added since mid-February when we launched the new, Sun-compliant SCA signing process. Before the end of 2009, if we proceed at this same rate, MySQL SCA signatories list should grow to about 70 to 90 contributors.

In the meantime, contributions from many of these contributors have already been accepted and integrated. (I had earlier pointed to Armin Schöffmann's contribution as a simple example of how all this works.)

Some people continue to …

On my last count, there are now 20+ Sun Contributor Agreement (SCA) signatories whose names appear on the master list and who are interested in contributing to MySQL. Only this week, three new members signed the SCA.

These 22+ signatories have all been added since mid-February when we launched the new, Sun-compliant SCA signing process. Before the end of 2009, if we proceed at this same rate, MySQL SCA signatories list should grow to about 70 to 90 contributors.

In the meantime, contributions from many of these contributors have already been accepted and integrated. (I had earlier pointed to Armin Schöffmann's contribution as a simple example of how all this works.)

Some people continue to …

I've created a very simple MySQL scanning module for the metasploit framework.

1. Download the mysql_version file and rename it to mysql_version.rb and put it in the framework-3.2/modules/auxiliary/scanner/mysql directory of your metasploit installation.
http://compukid.no-ip.org/dev/scripts/mysql_version

2. Use using msfcli
./msfcli auxiliary/scanner/mysql/mysql_version RHOSTS=192.168.0.1 E
[*] 192.168.0.1:3306, MySQL server version: 5.0.81-1-log (Protocol 10)

3. More options:
set THREADS to 10 and RHOSTS to 192.168.0.0/24 to scan a whole network.

OK, so it happened, I knew it would. The PSU in my main desktop Linux box broke down (it has been noisy and unreliable lately). It was completely dead. I subsequently went out to get a new one, and once home, started the process of removing the old PSU from the case, which was an Antec Sonata II. This is not a bad case, but I was surprised that the PSU had broken down, as this was not a low-end PSU (it was an acclaimed Hiper PSU. Next time I'll go cheap again).

Now, getting the old Hiper out of the Sonata was turned more difficult than I expected, as the CPU cooler was in teh way of getting the PSU out. I tried any trick I could think of, but in the end, I had to remove the CPU cooler. That finished, I could now replace the PSU with the new (and cheap 500W noname). That done, I now had to replace the CPU cooler. Without looking (big mistake) I just placed the CPU cooler on the CPU and fastened it (with screws, this was an AMD 754 …

A while ago I posted about a comment a Sun performance engineer made about a scalable replacement for InnoDB. At the time, I did not believe it referred to Falcon. In hindsight, it seems even clearer that the Sun performance experts were already working hard on InnoDB itself.

Sun’s engineers have shown that they can produce great results when they really take the problems seriously. And I’m sure that InnoDB’s performance has untapped potential we don’t see right now. However, it does not follow that their work on InnoDB is what was meant by a scalable replacement for InnoDB. Or does it?

General-purpose MVCC transactional storage engines with row-level locking, whatever their performance and scaling characteristics in …

Everyone loves SSD.  It’s a hot topic all around the MySQL community with vendors lining up all kinds of new solutions to attack the “disk io”  problem that has plagued us all for years and years.  At this year’s user conference I talked about SSD’s and MySQL.   Those who follow my blog know I love IO and I love to benchmark anything that can help overcome IO issues.  One of the most exciting things out their at this point are the Intel x-25e drives.  These bad boys are not only fast but relatively inexpensive.  How fast are they?  Let’s just do a quick bit of review here and peak at the single drive #’s from sysbench.    Here you can see that a single X25-e outperforms all my other single drive test.

Yep you have probably seen this type of chart on other sites…   The great thing about the Intel drives is their performance on writes, this difference gives …

If you get the source code through the …

My customers tell me Oracle is winning the war with the Oracle Enterprise Manager (OEM) as the tool of choice for managing the Oracle Infrastructure across multiple tiers. With Oracle 11g, Oracle will be adding more RAC integration/functionality into the middle-tier with OEM. Part of the power of OEM is that it manages Oracle Database Servers, Application Servers, Services, Applications and

Just about every week I am asked by customers what storage engine they should be using. As well as, what storage engine should we be paying attention to in the future (i.e. Falcon, Maria, InnoDB, etc.).It's finally time to start looking very seriously at the InnoDB plug-in. It's in the final beta releases while Maria and Falcon are still in alpha stage. The really nice thing about the InnoDB