The MySQL community is just great. I’ve been suggesting that we get recordings for the Conference & Expo, alas, its generally not in the roadmap. I mean, look at Apple and their WWDC - all attendees get amazing video recordings that switch between slides and the speaker. Last year, they even delivered it via iTunes! In previous years, they distributed DVDs (valuable, though with WWDC a lot is generally new technology announcements, and I can hardly want to reference what was cool for Panther or Tiger any longer…) Mad props also to the linux.conf.au 2007 team, who also did amazing recordings - sessions were available by the evening they were given!

The MySQL conference is a lot different. There are lots of reusable sessions. Some that you attend, you’ll get knowledge committed for life. The tendency to not see too many roadmap talks makes it very useful for future reference.

Back to why the community rocks. …

Microsoft funds open source project for document interoperability in China. Apache Software Foundation announces new version of Axis. Apatar to launch enterprise data mashups application at OSBC. (and more)

Microsoft Continues to Expand Interoperability Options for Office Customers, Micrososft (Press Release)

The Apache Software Foundation Announces the Release of Apache Axis2/C v.1.0, Apache Software Foundation (Press Release)

Apatar to Unveil an Enterprise 2.0 Software Product Apatar Data Mashups at the Open Source Business Conference (OSBC), May 22-23, 2007 in San Francisco, CA, Apatar (Press Release)

…

Silly shit you discover when implementing a mysql server!

- The 5.0 MySQL CLI client autostrips comments (badly) from SQL before sending it to the server. I don't really get why yet. DBD::mysql doesn't.

- Even if you say "quit" to exit the CLI client, it doesn't send a COM_QUIT command to the server. DBD::mysql does.

Code release in a few days? Possible. Lua interface is still more pseudo than code still.

MySQL’s version-specific conditional comment syntax confused me for the longest time. Then I learned about printf formatting rules, and it all became clear. Read on if you don’t already know what I mean. First I’ll explain what I’m talking about. MySQL allows specially formatted comments with a server version number embedded in them. Servers newer than the version number will execute the commented-out code, and older servers won’t. This is really useful sometimes.

http://tinyurl.com/2qmusm

Need I say more? Go download the slides, video and audio from the 2007 MySQL Users Conference & Expo. I have no plans to take anything down, so please download wisely, and take only what you need. If there’s demand, I can make higher-quality versions available. I can also burn DVD’s of the content if that’s desired.

Enjoy!

There is a popular myth about the SQL GROUP BY clause. The myth holds that 'standard SQL' requires columns referenced in the SELECT list of a query to also appear in the GROUP BY clause, unless these columns appear exclusively in an aggregated expression. MySQL is often accused of violating this standard.

In this article I will attempt to debunk this myth, and to provide a more balanced view regarding MySQL's treatment of GROUP BY at the same time.

To do that, I will first demonstrate that MySQL can be instructed to only accept GROUP BY clauses that include all non-aggregated expressions referred to in the SELECT list, thus making MySQL's behaviour conform more to that of other well-known rdbms-products.

Second, I will show that it is very important to clearly define which …

273 people have cast their vote on the most wanted replication feature…

Cast your vote before the poll disappears:

http://dev.mysql.com/

Thinking further about Microsoft's FUD campaign to threaten patent lawsuits against customers for using Linux, I was wondering if this isn't really a result of a bigger issue facing the company: Google Envy.  As I mentioned previously, Microsoft is competing on several fronts.  And while they hate like hell to give up market share to open source that would threaten their cash cow Windows or Office business, the bigger issue for the company is that their core businesses are being disrupted.  And Microsoft is in last place when it comes to new online businesses like hosted applications, online search, email, blogging, videos, and music.  (Ok, to be fair, Microsoft has come from behind in the past in other markets like gaming and accounting software.)  As is the case in many mature markets, their core …

I get the opportunity see a lot of different MySQL Cluster configurations and most of them does not configure the disk subsystem in a good way. E.g, the redo log is way to often not correctly dimensioned. Wrongly dimensioned buffers affects system stability!!

There are also some buffers related to communication and disk, that is important to setup. At the end here you will find a good configuration template that you can use, but first we will have a brief discussion about the disk


Configuring the disk

In MySQL Cluster, it is very important to dimension the redo log properly in order for System restart and Node restarts to work. In MySQL Cluster, the redo log must be large enough to accomodate changes that happens over three Local Checkpoints (LCP). When the third LCP has been written, then the redo log can be recycled. The LCP is the image of the DataMemory which is written to disk, so if you …

Well this is going to be a short blog post that will not really manage to summarize all the experience on my San Francisco, Santa Clara, San Francisco, Austin, Tampa, Boston, Chicago, Zürich, Berlin, Güstrow, Berlin, Zürich round trip I was on for the last 4 weeks. But anyways, I wanted to mention that the slides from php|tek are now linked in the slides section.

I did a talk on various strategies of how to bridge relational databases and object-oriented programming. In retrospect I should have submitted this as a "double feature" talk, so that I could cover more ground on the actual using of the existing packages in the PHP space.

The other talk was on database locking. I think the biggest eye opener for people in that talk was about how MVCC, found …