Open Database Alliance formed. Oracle buys Virtual Iron. AccesStream reaches version 1.0. And more.

Follow 451 CAOS Links live @caostheory

I’ve just met a fork named Maria
MySQL founder Monty Widenius and Percona CEO Peter Zaitsev announced the launch of the Open Database Alliance - “a collection of companies working together to provide the software, support and services for MariaDB, an enterprise-grade, community-developed branch of MySQL.”

Continuent and Open Query quickly announced their membership, while Monty later …

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 …

Javier Soltero, former CEO of Hyperic, has maintained that the sale of Hyperic to SpringSource was driven by discussion between himself and SpringSource CEO, Rod Johnson, but the fact that the companies shared investors - Accel Partners and Benchmark Capital - no doubt accelerated the deal (and I wonder whether either could have afforded to acquire the other without shared investors).

When examining the open source vendor landscape it is tempting to imagine that the combined total could be bigger than the sum of its parts - that a combination of many open source product specialists could mount a challenge to Red Hat and Sun to claim the title of biggest open source software vendor.

Benchmark and Accel are among …

The MySQL Workbench team would like to announce the availability of the first Alpha release of MySQL Workbench 5.2.

The major new feature in MySQL Workbench 5.2 is the SQL IDE, which offers the ability to edit and execute queries on MySQL servers. The new SQL query editor, based on the Open Source Scintilla text editor component, offers full syntax highlighting and other advanced editing features. The SQL editor was also extended to perform live syntax checking, detecting and indicating any syntax errors in your SQL code even before executing them. The IDE also provides ability to browse and edit the contents of individual table rows.

Note, however, that as this is a development version, there are known and unknown issues that might prevent the smooth use of the application. Backup your models often and before opening them with this version as the file format has …

One of the things that has always bothered me about replication is that the binary logs are written to disk and then read from disk.

There is are two threads which are for the most part, unaware of each other.

One thread reads the remote binary logs, and the other writes them to disk.

While the Linux page buffer CAN work to buffer these logs, the first write will cause additional disk load.

One strategy, which could seriously boost performance in some situations, would be to pre-read say 10-50MB of data and just keep it in memory.

If a slave is catching up, it could have GIGABYTES of binary log data from the master. It would then write this to disk. These reads would then NOT come from cache.

Simply using a small buffer could solve this problem.

One HACK would be to use a ram drive or tmpfs for logs. I assume that the log thread will block if the disk fills up… if it does so …

At MySQL Conference and Expo 2009, I explained how Linux I/O scheduler queue size affects MyISAM insert performance.

It is well known that Linux implemented four types of I/O schedulers (noop/deadline/anticipatory/cfq) in Linux kernel 2.6.10. The default is cfq in most distributions including RHEL, which is not so good then noop normally outperforms, but I'll talk this in other posts.

Linux I/O scheduler also has a functionality to sort incoming I/O requests in its request-queue for optimization. Queue size is configurable. Queue size is defined as "/sys/block/sdX/queue/nr_requests" then you can change queue length as follows.

# cat /sys/block/sda/queue/nr_requests
128
# echo 100000 > /sys/block/sda/queue/nr_requests

Changing queue size is even effective for noop …

OIN aims to cut the FAT. What is the point of the GPL? Black Duck takes flight. Ingres delivers Salesforce.com appliance. The ongoing fallout from Oracle-Sun. Feedback on the Bee Keeper model. And more.

Follow 451 CAOS Links live @caostheory

OIN aims to cut the FAT
# The Open Invention Network announced plans to review the Microsoft FAT patents at the center of its recent skirmish and settlement with TomTom. have been placed for prior art review on the Post-Issue …

After a turbulent week, where a few of our team were presenting workbench at this years MySQL Users Conference, we have finally uploaded the next beta packages for you to try. We’ve further improved the handling of the application. The problem with the missing table editor in the mac package is fixed in this release as well.

Please grab the package of your choice at our download page and give it a try.

I have published the very first sharable Drizzle Amazon Machine Image (AMI) for AWS EC2, based on the good feedback from my discussion at the Drizzle Developer Day on what options we should try.

This first version is a 32bit Developer instance, showcasing Drizzle and all necessary developer tools to build Drizzle from source.

What you will find on drizzle-ami/intrepid-dev32 - ami-b858bfd1

Ubuntu 8.10 Intrepid 32 bit base server installation:

• build tools
• drizzle dependencies
• bzr 1.31.1

From the respective source trees the following software is available:

• drizzle 2009.04.997
• libdrizzle 0.0.2
• gearman 0.0.4
• memcached 1.2.8
• libmemcached 0.28

Drizzle has been configured with …

Today I attended the Drizzle Developer Day which took place in the auditorium of the Sun Campus in Santa Clara.

Many of the the Drizzle core hackers as well as several other people interested in the development attended this event, hacking away and discussing various issues. Jeremy Zawodny gave a presentation about Craigslist's needs for Drizzle, Jay Pipes gave an overview over Google's protocol buffers library. I took a number of pictures, which you can find in my …