OK, so I apologize for the obviously attention-grabbing title of this blog. If you're still with me, give me a chance to explain why we can ALL get drunk with Eben at the conference in the spirit of true open source bazaar participation.

Eben Moglen, who is the Director of the Software Freedom Law Center, will be opening up our Wednesday morning keynote extravaganza with a talk entitled "Freedom Businesses Protect Privacy". When I first received a title from Eben, he had proposed the following title (snipped from my email from him):

"Why Free Beer Isn't So Good if your Data are Getting Drunk: How Free as in Freedom Businesses Help Prevent the Ultimate Privacy Catastrophe"

The …

Track: Security and Database Administration
Date: Tuesday, April 24
Time: 7:30pm - 8:30pm
Location: San Thomas, Santa Clara Convention Center
</p>

Do you have more MySQL daemons than you can keep track of? Do you learn when one goes down only after things have hit the fan? Would you like some advanced or at least timely warning?

Do you use SNMP and a management station to monitor the health and availablity of your switches and routers, and possibly your hosts. Would you like to manage your MySQL servers the same way, using the same tools? Come learn how you can.

There's a RDBMS-MIB. And now there's an AgentX subagent for it.

Come learn how it will make your life a little less stressful.

Hi!

Version 0.6 has been released, the big news is:

Discovery Support was added
Implemented row level locks
Fixed bug in deletion of keys
Fixed duplicate key bug
Updated stats for server status
Fixed issues in update for replacement of primary key.

What is discovery mode? It means that a table found by one MySQL server can be found by another who has access to the memcache cluster. This works because on CREATE TABLE a copy of the definition of the table is placed inside of the memcache cluster for other MySQL servers to find. This is not perfect yet and it will need a bit more code to really scale (aka it needs resource counting). This version has gotten quite a bit more outside testing then previous versions so I expect quite a few SQL errors are now gone.

You can find the announcement here:
…

I've been linked to DZone.com. DZone appears to be like furl and digg, where people submit links and other readers vote them up or down.

Mark has released his S3 engine:
http://fallenpegasus.livejournal.com/579770.html

S3 is the Amazon storage system. Personally I am very interested to see how user's can put this to use. Being able to take data and store it in a remote service has a lot of really interesting possibilities (off lining OLTP, of site backups, simple ability to push objects to S3...)

He is also speaking on it at the MySQL User's Conference:
http://www.mysqlconf.com/cs/mysqluc2007/view/e_sess/10822

He also has a BOF on his SNMP plugin (which I would think would really shake people's worlds):
http://www.mysqlconf.com/cs/mysqluc2007/view/e_sess/14285
…

I just got mentioned on the official AWS blog

Independent developer Mark Atwood has been working on a MySQL interface to Amazon S3. Released under the GNU Public License, the code is compatible with version 5.1 of MySQL. Once the interface has been installed and configured with your AWS developer credentials, you can now create tables using the AWSS3 storage engine like this:

CREATE TABLE atst (s3id VARCHAR(255) NOT NULL PRIMARY KEY, s3val BLOB)) ENGINE='AWSS3' connection='awss3 bucketname aws_id aws_secret'

This is a bleeding-edge, first-cut release and, as is the case with popular open source projects, will undoubtedly evolve and mature rapidly over the coming weeks and months.

Based on Mark's S3 journal entries, the basic functionality is now in place. Each database table row is stored in an S3 object. The …

While reviewing the material for this session, I remembered a usability report that I wrote when the feature was …

I have just released PrimeBase XT 0.9.86 which will be my last release before the MySQL User Conference this year. The most significant change in this version is the reduction of the number of data logs used per table. This, and a number of other modifications, makes PBXT fit to handle databases with 1000's of tables.

If you would like to learn more about the development and design of PBXT then join me for my session at the MySQL User Conference in Santa Clara, on Wed, April 25, 10:45am - 11:45am, Ballroom F:

PrimeBase XT: Design and Implementation of a Transactional Storage Engine

Looking ahead, I would also like to invite all who are interested to the "Scalable BLOB Streaming Infrastructure" BoF, which is scheduled for …

LJ ate part of the post, so I am updating it with the original content.

I've not been posting a lot about my studies on bottlenecks in the
server and my work on what I am seeing with different engines, but I
thought I would comment on Peter's benchmarks on PBXT:
http://www.mysqlperformanceblog.com/2007/04/08/pbxt-benchmarks/

This is a bit off what I have found so far:










In all tests but the final, the task …

Today while waiting at the airport, I took a look at the news stand, and right there on the cover of Fast Company were two words Google, and Wikipedia. Given Wikipedia is a poster boy of MySQL it was an immediate purchase just to see what was being said.

So the title of the cover was Google’s worse nightmare - Wikipedia’s Jimmy Wales has his sights set on the search business.

Now, often I use Wikipedia to search for things directly rather then using Google. I’ve found it usually to be more accurate, particular on topics I know it will contain. References to search users being disappointed, Google and Yahoo tied with a 2.3 of 5 in user satisfaction hits about home for me as week, and that’s exactly the ideas …