The latest from the MySQL community

• MySQL AB :: MySQL 5.1 Article Recap
• MySQL AB :: MySQL 5.1 New Features: MySQL Partitions

Normally I don’t make a point of calling out other vendors by name, but this time I can’t resist. See, Oracle’s big party-turned-conference is this week. “Larry-fest” — I’ve heard it called by some cynics. I believe the tagline is something to the effect of “100,000 reasons to say thank you.” Thank you indeed, Oracle. Thanks for closing down a whole frickin street 3 WHOLE DAYS BEFORE your database love fest and creating 4 more extra days of traffic. Lucky for us, Hyperic is a few blocks away and gets to enjoy the fruits of Oracle’s closure of …

Ambition is the last refuge of failure --Oscar Wilde

The star schemas along with aggregates support the full scope of the data warehouse, the multi-dimensional database (MDB) can be used to support a limited scope where query performance is paramount:

This release fixes several bugs introduced in the last release as I replaced untested code with tested code – how ironic! Actually, I knew that was virtually guaranteed to happen. Anyway, all the bugs you’ve helped me find are now fixed. I also fixed a long-standing bug in MySQL Table Sync, which I am otherwise trying to touch as little as possible for the time being. (Remember to contribute to the bounty, and get your employer to contribute as well, so I can do some real work on it in the next month or so!

Greta and Lily Asay

Whom shall he teach knowledge? and whom shall he make to understand doctrine? them that are weaned from the milk, and drawn from the breasts.

For precept must be upon precept, precept upon precept; line upon line, line upon line; here a little, and there a little:

For with stammering lips and another tongue will he speak to this people. (Isaiah 28:9-11)

Anyone that has tried to ramrod open source into an organization will appreciate this counsel from Isaiah. As a market phenomenon, open source - be it Linux, Apache, MySQL, SugarCRM, MuleSource, or another project - almost always has begun on the fringes of IT. With Linux it was the edge-of-the-network server at first, until it eventually claimed the data center. With many commercial open-source projects, the first entree into an enterprise is at the departmental level …

It's been a while since I've written about progress on the book. I actually stopped working on it as much at the beginning of the month, because on October 31(st) I managed to finish a first draft of the last big chapter! Now I'm back to full-time work at my employer, and I'm working on the book in the evenings and weekends only. Read on for details of what I've been working on and what's next in the pipeline.

"Projectors are the essence of Communication"

Sums up how to communication between tech types.

Spending my Saturday at "Saturday House" (http://www.saturdayhouse.org/). So far I have explained how the new "skeleton-library" framework I put together works.

(obligatory link: http://hg.tangent.org/skeleton_library/)

Next is teaching people how to write storage engines (and talking about the memcached engine for MySQL).

This question seems to crop up again and again... In the words of one comment to my blog: "I've downloaded your External Language Stored Procedures package and am interested in trying out the JAVA part. Would appreciate if you could explain how use the downloaded stuff."Ok, on my download page, I have provided 2 different downloads which are automatically created from our source repository. A

The next upload of the MySQL packages to Debian (both branches, 5.0 in unstable and 5.1 in experimental) will disable binary logging in the default configuration file. I think most users of the MySQL packages in Debian don't really need it, and otherwise (e.g. on a replication master, or for point-in-time recovery) they know how to enable it.

This change only affects you when you're doing a fresh installation of the mysql-server package, or if you're still running the default configuration file shipped with the package. If you modified the configuration file in the past already (which should be the case when using replication, because the server_id line is disabled by default), the change will not be applied during an upgrade without explicit confirmation.

John Quinn writes about Scaling Drupal he is taking a one step at a time approach and is still writing his 4th and 5 stages.

His first step obviously is separating the drupal from a separate database server, and he chooses mysql for this purpose, moving your DB to a different machine is a good thing to do.

However then he gets this crazy idea of using NFS to share his his drupal shared files :(
(he even dares to mention that the setup ease is good) Folks, we abandonned NFS in the late nineties. NFS is still a recipe for disaster, it has performance issues , it as stability issues (stale locks), and no security admin in his right mind will tolerate portmap to be running in his DMZ.
(Also think about the IO path that …