We have lots of things on the go right now (over and above the normal process of keeping things up to date), and one of the main projects for me is to do a complete rebuild of the installation chapter (Installing and Upgrading MySQL). I’ll be starting with the 5.1 manual, then the 5.4 manual. Any future manuals should be based on these so we should be up to date for future generations. What I’m doing:

• Re-structuring the chapter to make it easier to follow on a platform basis. The old structure mixed content for different binary and source types, and different platforms, across a number of sections, making it very difficult to follow the instructions for your chosen platform.
• Make some things generic. There are sections which are generic and apply to all (or at least many) different installation types.
• Make some things …

I'm pleased to announce the release of Vertical Partitioning storage engine version 0.6(alpha).
Vertical Partitioning is a Storage Engine for vertical partitioning for a table.
http://launchpad.net/vpformysql

The main changes in this version are following.
- Add UDF "vp_copy_tables".
  This UDF is used for syncronizing Vertical Partitioning's child table data from old child tables to new added child tables.

- Add table parameter "choose_ignore_table_list", "choose_ignore_table_list_for_lock" and "zero_record_update_mode".
  This parameters are used for avoiding to use new added child tables at searching operation and separating child tables for searching with lock and without lock.

- Add server parameter "vp_udf_ct_bulk_insert_interval" and "vp_udf_ct_bulk_insert_rows".
…

Welcome to the metronome, every two weeks we drop a release of Drizzle.

Which makes it sort of boring to blog about each release since they are consistent :)

But no two releases are really the same, and this last one had a bit of fun in it:

drizzle> CREATE TABLE A (a int) ENGINE=Archive;
Query OK, 0 rows affected (0 sec)

drizzle> create table B like A ENGINE=innodb;
Query OK, 0 rows affected (0 sec)

drizzle> show create table B;
+-------+-----------------------------------------------------------+
| Table | Create Table                                              |
+-------+-----------------------------------------------------------+
| B     | CREATE TABLE `b` (
   `a` int DEFAULT NULL
) ENGINE=InnoDB |
+-------+-----------------------------------------------------------+
1 row in set (0 sec)

Being able to specify an engine when doing a CREATE TABLE LIKE has been long on …

Larry Ellison promises funds for MySQL, commits to community. The “open source vendor” debate in a nutshell. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# Larry Ellison promised MySQL will receive more money for development and research, while Oracle maintained that it is committed to Java and open source developer communities.

# GroundWork raised $5m series D funding from Canaan Partners, Mayfield, JAFCO Ventures and SAP Ventures.

# InformationWeek reported that Motorola has vacated …

I did not mean to stir up a hornets nest!

I received a lot of feedback on the last blog entry on shutting down the old MySQL system and that included the lists of certified candidates. Yes, I know how valuable these lists are. But you might want to check this out ORACLE UNIVERSITY LAUNCHES CERTVIEW. I will see if I can get some details the next time we speak to the fine Oracle Certification folks.

The certification industry have started initiatives like the ITCC to allow you to have your certifications listed for viewing by a potential employers or the world at large. So do not worry that we are taking some draconian action and the …

In response to Eric Day's post on "Eventually Consistent Relational Database?"... I started posting a comment there, but I realized I have my own blog for this sort of thing. :)

I've been thinking the same thing, it's nice to hear I'm not the only one. This is a neglected area of "cloud" development, mostly because it's a big scary problem. Everyone says "use NoSQL", but if we had strategies/systems to give us EC RDBMS solutions, nobody would use key/value storage (except where it actually made sense). NoSQL is a big golden hammer nowadays. It works, but it sure takes a lot of effort to code stuff the storage layer should be able to handle (joins, etc.).

read more

We have lots of things on the go right now (over and above the normal process of keeping things up to date), and one of the main projects for me is to do a complete rebuild of the installation chapter (Installing and Upgrading MySQL). I’ll be starting with the 5.1 manual, then the 5.4 manual. Any future manuals should be based on these so we should be up to date for future generations.

What I’m doing:

• Re-structuring the chapter to make it easier to follow on a platform basis. The old structure mixed content for different binary and source types, and different platforms, across a number of sections, making it very difficult to follow the instructions for your chosen platform.
• Make some things generic. There are sections which are generic and apply to all (or at least many) different installation types.
• Make …

Today I made a presentation to 100+ audience mostly comprising of DBAs and software consultants about MySQL Architecture and Solutions. You can download the presentation slides. This focuses on architecture overview of MySQL products and solutions.

Dear Community,

As of today the 19-th build of MySQL server with Percona patches is available.

Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.86
• Fix from Neil Katin to userstatv2.patch
• fix InnoDB slowness with large queries

Fixed bugs in the build:

• Bug #413858 in Percona patches: “Crash from failed assertion in dict0dict.c”

You can download binaries and sources with the patches here

…

Dear Community,

We are glad to present you release 8 of XtraDB.

The release includes following new features:

• The release is base on 1.0.4 version of InnoDB plugin. We thank Schooner Information Technology for sponsoring and testing the port of XtraDB to 1.0.4
• MySQL 5.1.39 as a base release

Fixed bugs:

• Bugs#413858: Crash from failed assertion in dict0dict.c
• Bug#417751:
  XtraDB crashes on startup on windows
• fix-import-extern-pages
• Number of mysql-tests are fixed

The builds for RedHat4,5 and Debian are located on …