This is a project that I have been working on that I have just uploaded to launchpad. It is not directly related to my work on the BLOB streaming engine for MySQL but it does contain code and ideas that I hope to work into it. The project name on launchpad is 's3daemon'.
The Amazon S3 file transfer daemon is a daemon process that runs in the background and monitors folders. When it finds a file in one of the folders that matches a specific pattern it transfers that file to S3 storage and then removes the local copy. The folders monitored and the patterns searched for are controlled by a configuration file.
Included with the daemon is an apache module that handles requests for files in the folders monitored by the daemon. If a request comes in for a file and the file cannot be found locally the caller is sent a redirect to get the file directly from the S3 server.  The redirect contains a signature created by the module using a …

Hey all, a quick and short note that I will be spending much of December near and around Quito, Ecuador. If there are any MySQL or MySQL-related community, Open Source community, developers or partners that would like to get together, please let me know. My spanish collation is problematic ;) (currently non-existent) but would still love to meet you.

Drop me a note via this blog!

Señoras y señores, I am happy to have been part of the MySQL launch in Argentina yesterday. Visiting Argentina has been a great opportunity to meet with the MySQL users and not-yet-users in a country with 30 degrees Celsius, with colourful houses in La Boca, with an omnipresent Diego Maradona, and only minor challenges in the form of payment methods when using local transport.

On Monday evening, I visited the Universidad Nacional De La Matanza. Together …

The rise of the "Open Source Software Stack" reached another milestone today.  

Sun released a SPECjAppServer2004 performance result using top-to-bottom Open Source Software stack components:  OpenSolaris/MySQL/Glassfish.   At 1197.10 JOPS, the performance is highly respectable - not setting any land speed records, but it is in the ball park with other results using the same class of hardware.   The difference (of course) is in the price/performance.

The other contenders were two [1][ …

It is widely acknowledged that Barack Obama put together the best minds and team together to run his campaign. One of the proof points is that his website www.barackobama.com was driven by MySQL! 

From Jonathan's blog:
http://blogs.sun.com/jonathan/

" On behalf of Sun Microsystems, I would like to offer my sincerest congratulations to President elect Barack Obama. What an extraordinary accomplishment.

I would also like to extend my congratulations to his web team for having chosen MySQL as the platform behind their election web site, BarackObama.com. "

What can open source companies learn from Mark Benioff? Plenty. READ MORE

Interpreting the output of the MySQL EXPLAIN command can be tricky. From all the information you get, some of the most important information is:

• Full table scans
• High join size product
• Using filesorts
• Using temporary tables

This can be hard to see in the raw output. Example query:

EXPLAIN SELECT b.item_id, b.bidder_id, u.username, MAX(price) AS price FROM bid b JOIN user u ON (b.bidder_id = u.user_id) WHERE b.item_id = '1' GROUP BY b.bidder_id ORDER BY price DESC

The explain outputs:

id, select_type, table, type, possible_keys, key, key_len, ref, rows, Extra
1, SIMPLE, b, ALL, null, null, 0, null, 22660, Using where; Using temporary; Using filesort
1, SIMPLE, u, eq_ref, PRIMARY, PRIMARY, 4, heavybidder.b.bidder_id, 1,

We've been experimenting how to visualize the output of …

Happy birthday to Giuseppe Maxia, a wonderful community organizer for MySQL.

And happy birthday to Leslie Hawthorn, Google’s geek herder.

Thank you for making life better for open source volunteers like me!

It is widely acknowledged that Barack Obama put together the best minds and team together to run his campaign. One of the proof points is that his website www.barackobama.com was driven by MySQL! 

From Jonathan's blog:
http://blogs.sun.com/jonathan/

" On behalf of Sun Microsystems, I would like to offer my sincerest congratulations to President elect Barack Obama. What an extraordinary accomplishment.

I would also like to extend my congratulations to his web team for having chosen MySQL as the platform behind their election web site, BarackObama.com. "

It is widely acknowledged that Barack Obama put together the best minds and team together to run his campaign. One of the proof points is that his website www.barackobama.com was driven by MySQL! 

From Jonathan's blog:
http://blogs.sun.com/jonathan/

" On behalf of Sun Microsystems, I would like to offer my sincerest congratulations to President elect Barack Obama. What an extraordinary accomplishment.

I would also like to extend my congratulations to his web team for having chosen MySQL as the platform behind their election web site, BarackObama.com. "