The latest from the MySQL community

New Lion Sniper program makes it possible for anyone to become an open source contributor READ MORE

I recently took up a position as an IT and Internet Manager at MobileFun UK.
The position itself is very interesting. The company is very aggressively trying to grow and has lots of new ideas. At the same time, I am stuck with some legacy systems that I need sort out asap. The people here are really very nice. Birmingham is also really nice and far cheaper then London for house prices.


My responsibilities include:

• Maintaining the web servers
• Leading the web development team
• Maintaining all the servers and desktops inside the company - some are quite old.
• Leading the internal application development team
• The databases and the business intelligence of the company - we use MySQL 4 and 5 (I need to upgrade them)
• And.. the phones for the entire company - don't know why.

So I have quite a lot of work to get done and I …

Update to tomorrow's MySQL University session: Petr will start presenting how to use NetBeans for writing PHP. David will continue showing how to use it with MySQL. To set expectations correctly, we've renamed the MySQL University to Working with PHP and MySQL in NetBeans.

Petr Pisl from the NetBeans team will be David Van Couvering's co-presenter for the MySQL University session this Thursday (see the announcement I posted yesterday). While David will focus on NetBeans with MySQL, Petr will demonstrate what NetBeans can do for PHP programmers, a species that uses MySQL all the time. Thanks for joining in, Petr!

In his recent …

I have accepted invitation from David Van Couvering to attend his session and present the PHP features in NetBeans. The session will take place this Thursday, 23rd October and will start at 9:00 Pacific Time (18:00 CET, 17:00 BST). We will use DimDim presentation system so everybody can attend. But  the session has limited capacity of attendees. More info about the session you can find here.

If you are interested, attend the session.

I get a few questions how to set DiskPageBufferMemory.

Before discussing that let's recap a few things:

• Non-indexed attributes (or explicitly defined in CREATE TABLE..) are stored on disk in table spaces.
  
• Indexed attributes are stored in DataMemory
• The hash of the Primary Key is stored in the IndexMemory

Determining how much IndexMemory/DataMemory/Tablespaces that are needed, you can use the dimensioning toolkit.

Now you can setup Undobuffers etc according to my post on disk data a while back.

But what about the DiskPageBufferMemory?! If you have used …

I just came upon a pretty good Hadoop introduction paper posted on Sunâ€s wiki. Apache Hadoop is a free Java software framework that supports data intensive distributed applications. It enables applications to work with thousands of nodes and petabytes of data. Hadoop was inspired by Google's MapReduce and Google File System (GFS) (wikipedia). I wouldnâ€t call it an alternative to mysql – theyâ€re in completely different weight categories. I like …

I think Giuseppe (the man with too many blogs!) was a little too optimistic in his last post… the MySQL Conference Call for Participation has received an amazing amount of proposals, but not enough by our standards.

I personally believe there should be a 1:3 accepted-rejected ratio. Currently, its not there yet. Why do I like such high ratios? It means that there are actually so many good talks, and we (the voting committee) pick the best of the best, to give attendees the most mileage for their time and money. Or am I too harsh?

Anyway, the word on the street is that we will extend the Call for Participation, mostly because it is the right thing to do, and lots of people expect it. Expect an official announcement to go out soon about this. But …

I've ported my AWS S3 storage engine to Drizzle.

The source is at bzr branch lp:~fallenpegasus/drizzle/awss3. Pull it and build it like you would the main Drizzle. The engine is built-in, no need to plugin load it.

Example use:

   CREATE TABLE colors
     (nam VARCHAR(32) NOT NULL PRIMARY KEY, val BLOB)
        ENGINE='AWSS3'
        CONNECTION='awss3 bucket_name aws_id aws_secret';
   SELECT val FROM colors WHERE nam='BlueViolet';

I will try to keep it tracking the main Drizzle dev tree.

Guy Kawasaki's latest book is a blueprint for tech entrepreneurs and intrapreneurs alike READ MORE

Microsoft wisely chooses to sidestep the "either/or" discussion around open source READ MORE