Since my last post I have been working on Pre-fetching relay binlogs to speed up MySQL replication. While I will be writing more and eventually posting my script, I wanted to mention that I am extremely satisfied with the results I am seeing. Very soon I will be posting a before and after graph so stay tuned.

I recently had the opportunity to return and speak at the Brisbane MySQL Users Group. I spent some time talking about MySQL User Conference 2007 Summary and Life as a Consultant. My summary of included:

• Overview
• Keynotes
• Marten Mickos - MySQL
• Guy Kawasaki
• Michael Evans - OLPC
• Rasmus Lerdorf - PHP
• Paul Tuckfield ? YouTube
• Community Awards
• Product Road Map
• Google
• Storage Engines
• Dorsal Source
• What’s Next

One question was posed to me. “What new did MySQL do this year?” being from the last User Conference. …

"But what happens if Microsoft sues us?"

"What if they shutdown the Internet?"

Both are examples of statements that have been IM'ed to me today.

Guess what, Microsoft is bluffing.

They say these things, and then hope people either people will switch
to Suse, or more likely question everything they are doing with open
source.

The Suse angle is new, and frankly I don't believe its very thought
out either.

Basically though, this is a shakedown.

I've been in several companies where we have gotten the MS form
letter that states "you are in violation!".

One company actually did ante up some cash to them. Paid the fee and
agreed to some IO audit every X number of years. It was pretty silly,
since once we admitted to the IP they had to spend a few weeks to
determine if we were even …

Microsoft speaks out on sotware patents and Linux. MySQL Conference survey shows scalability as top concern. Sybase and Red Hat partner for database appliance. (and more)

Scalability, Manageability Top Priorities for MySQL Users, Solid Information Technology (Press Release)

Sybase and Red Hat Announce Plans for Expanded Alliance to Unlock Customer Value, Sybase / Red Hat (Press Release)

Black Duck Software Extends Software Governance Leadership at Third Anniversary of Flagship Product’s Debut, Black Duck Software (Press Release)

OpenSEA Alliance …

MySQL AB today announced that Quantel, a UK-based company behind one of the world's most popular server-based newsroom systems, has selected the MySQL database server as a critical component in its ?Enterprise sQ? product line.

I promised to write little articles about all storage engines which sessions I attended during MySQL Users Conference but I did not get too far yet, too busy. So today it is time for PBXT.

I was very interested about session about PBXT because this is storage engine does not target the same general purpose transactional storage engine market a lot of other people targeting. It also has number of unusual design decisions which will position it further away.

Paul was for a while comparing PBXT to MyISAM with multi versioning and transactions and this is valid comparison for good and for bad. At its current state (as of the conference) PBXT does not offer Durable transactions (meaning you can lose committed transactions if power goes down) furthermore in case of crash database may become corrupted, just as with MyISAM, and you might need to repair tables. This is of course something which is scheduled to be fixed before stable release …

One thing that Statcounter provides me is how often certain keywords are found in my blog. Some of the more popular are:

• ORA-27054: I assume this is by people trying to backup using RMAN over NFS. I hope they found my problem and most importantly, my solution.
• Some combination of DB Links and ORA-01017: I'm sure people found my distributed issues with 9i and 10g working together. But that's not always the issue. If you are using what I call "unauthenticated" database links (no password in the definition) then the user authentication on both the source and …

While going thru the process of putting the presentation for my China trip (and describing it to a friend part way through the process), it occurred to me that I have a specific method that I seem to follow each time.

Before I describe it, I should point out that there are really two types of presentations I've had to create over the last few years: new and derived.

As I thought about this, it occurred to me that I seem to find myself presenting over and over on subjects in the same specific topic area for roughly 9 to 24 months before I move on to something newer and different. Those phases, unsurprisingly, coincide with my role at work at the time.

Past phases were roughly:

• MySQL, Perl, and Open Source in general
…

New OpenSolaris Project: Web Stack 

We just launched a new OpenSolaris project called Web Stack.  With the great response we have seen for Cool Stack, we thought this would be a good time to get the community to participate. Although the starting point for Web Stack is Cool Stack 1.1, we hope it will grow much beyond that. Please vist the project site to get more details on why we are doing this. We'd love to get your feedback on whether you think this is a good idea and what open source web technologies/apps you would like to see added.

And of course, we hope that you will participate in the project. You can help by building portions of the stack, add new libraries and applications, …

Last week I posted on MySQL Quiz Show, where among several videos I took with my camera, there appeared a guy singing a very geeky song. Well, the singer turns out to be Solomon Chang, a MySQL-certified DBA, and the song “Coder McKinnan o