The latest from the MySQL community

?What ever advice you got, keep it to yourself, your not the target market.”

Red Hat & One Laptop Per Child UI Designer to bunch of suits - MySQL Conference 2007

CollabNet acquires SourceForge Enterprise Edition from VA Software. Red Hat acquires MetaMatrix for JBoss offering. MontaVista acquires MontaVista Ltd and Liberte. (and more)

Note: Due to a cross-country conference trip and limited Internet access, there was no 451 CAOS Links on Monday 04/23/07.

CollabNet and VA Software Sign Asset Purchase Agreement for Acquisition of SourceForge Enterprise Edition Business by CollabNet, CollabNet (Press Release)

Red Hat Defines Next Significant Open Source Migration Opportunity, Red Hat (Press Release)

MontaVista Acquires Two Companies to Increase Professional Services Capacity and to Broaden European Market Coverage, MontaVista …

I spoke to Matt and Barry today, and it was great to see them at the DotOrg Pavilion at the MySQL Expo, since the last time we caught up was at WordCamp 2006. Since WordCamp, Wordpress.com is now spanning something like 900,000+ registered users! That number used to be over 300,000+, just a few months ago, so it looks like they’re really popular.

While Barry entertained a visitor, Matt and I got to talking about growing companies. He’s really happy with the size of Automattic, and is going to try for as long as possible to keep the company size, under fifty. He’s also found it interesting that some people are running WordPress 1.2 (ick! security holes galore), and while I worried that the database itself might not be migrate-able, he mentions that going …

Today’s keynote, by MySQL CEO Marten Mickos, was titled The Participatory & Disruptive Spirit of the Dolphin. Here are some random notes I took.

Tired                Wired

Packaged Apps        On-Demand

Closed Source        Open Source (jboss, php, mysql, apache, linux)

Complex Hardware     Commodity Hardware

Most innovative companies, are clearly wired, and are enjoying the technology market shifts. Small players can now swim around the big players.

“Open Source disrupts inefficient models and produces new wealth.”

Star Wreck - Finnish dry humor, production by amateurs, and exteremely popular. Catch it on YouTube?

“We hope you’ll travel to MECA” - MySQL Enterprise Connection Alliance. Probably not the most sensible comment, but it does humor in it ;-)

Serve the underserved - offer flying to those that would otherwise …

Using MEMORY tables in MySQL is very useful; they are stored in memory and they are usually not so big in order to avoid a huge utilization of RAM. They are very fast.

MEMORY tables are often used to store session user data, chat messages and to store small frames of data from a bigger table in order to achieve great performance.

But, if you use them in a replication environment, you can have some problem due to their "volatility"; MEMORY table rows are lost when the server shuts down.

If you restart a slave host for some reason, you will have empty MEMORY tables on it, while the master host will have the correct ones.

How to populate automatically MEMORY tables at slave start up copying data from master host?

We could use something like LOAD TABLE table_name FROM MASTER, but it's deprecated, so we will use something else.

I have developed a stored procedure you have to create on the …

MySQL AB and IBM today announced a joint technology and reseller agreement to bring support for the MySQL open source database to the IBM System i business computing platform.

The two companies will work together to offer the MySQL Server for i5/OS, the flagship operating system for System i, and plan to deliver DB2 for i5/OS as a certified MySQL storage engine on the System i platform. This will allow System i customers to implement online and transactional MySQL applications while storing all data in a single, easy-to-manage DB2 database.

In my second day at the MySQL Conference and Expo 2007, I attended keynotes, several sessions, and three BoF (Birds of a Feather) sessions. This article is about these sessions. Again, I’ll focus on the Big Ideas and let you read other people’s blog posts for the small details. Keynotes There were three keynotes this morning. Two I won’t comment on, but I want to mention the third because it was mostly about the One Laptop Per Child project.

Today I missed a bunch of good talks that I was hoping to attend, because I was figuring out a problem at the Guru Bar. Offending criminal: MySQL Connector/ODBC 3.51. Offending OS: Mac OS X/PowerPC.

OS X comes with an ODBC Administrator. Once you unpack the MySQL package, and the .pkg installs itself, you’ll find that all your files are installed in /usr/lib. You need to fire up ODBC Administrator, click on Drivers, and Add the driver. Give it an appropriate Description (MySQL), provide the location of the driver file (/usr/lib/libmyodbc3.dylib), and define it as available within the System (this enables you to enable at the System DSN as well as the User DSN, in the next step).

Later, etiher add as …

I've described this idea to a few people, but I figured I would post it here.

I've had an idea for using Amazon AWS S3 to distribute MySQL cluster replication data.

The existing architecture for MySQL clustering is as follows:

1. The master has N slaves
2. The master copies each binlog replication to each slave. If there are 7 slaves, then the master has to push the same data out it's network pipe 7 times
3. The slave has a hot TCP connection to the master. The master has 7 hot TCP connections, one for each salve.
4. The slave takes each replication chunk and applies it.

Here is my idea.

• For each replication chunk, the master creates a handle name for it, and also the handle name for the next chunk.
• The server copies each chuck into an S3 item, once. The item's name is it's handle, and it has a piece of S3 …