So the first ever Phoenix MySQL Meetup finally happened tonight. Four of us went to The Yardhouse to sit around and talk geek talk about MySQL and related topics. Hopefully more will come to future meetings. The focus seemed more social than technical, comparing notes on individual backgrounds and occupations. We'll have to see how it evolves as it grows. It'll be interesting seeing what the core group is and what the common interests, an opportunity to compare notes and do some networking of the social variety.

Alfresco has published the results of their enterprise content management benchmark using MySQL 5.0 running on 64-bit Red Hat Enterprise Linux (RHEL). The benchmark uses a 10 million document repository across 10,000 folders and Alfresco was able to demonstrate linear scalability in a real-world scenario. The benchmark demonstrates online performance of batch load with mixed concurrent read and write operations under different user loads with different machine configurations.  The benchmark was validated by Optaros, a consulting firm that specializes in open source project implementations.

Alfresco's design has been implemented in a modular, de-centralized fashion in order to enable highly efficient scale-out and the benchmarks showcase the efficiencies they have achieved.  More details are available from Alfresco in their …

Alfresco, MySQL and Red Hat Deliver First Open Source JSR-170 Benchmark, Alfresco (Press Release)

Corel WordPerfect Office To Support Open Document Format and Microsoft Office Open XML, Corel (Press Release)

Open-Xchange Publishes ‘The End of FUD’ Position Paper, Open-Xchange (Press Release)

CollabNet unveils new global community for collaborative software development, CollabNet (Press Release)

…

The other day I did a blog post on ethernet latency.

The next morning I was number two in Google for this search term. I was actually planning a blog post about how quick I owned the keywords and how blogs are doing a great job at SEO.

Five minutes ago I did a search and I'm not even on the first page!

What is on the first page? Well my post as it was re-syndicated from MySQL Planet (which isn't even a permalink to the real content btw).

I'm not on the second page either. Rojo pushed me down with their RojoLink of my content.

I am on the third page mind you but it's not the link to the post but a link to my blog.

What's going on here? …

ZRM for MySQL requires binary logging to be enabled on the MySQL server to do incremental backups. Enabling binary logs has minimal impact on MySQL performance. But, in an active database, the binary logs can grow to hundreds of gigabytes or even terabytes.

ZRM of MySQL has multiple plugin interfaces to customize the backup and recovery process to user environment. One of the plugin interfaces is the post backup plugin. The binary logs are no longer required after a backup. The post backup plugin can purge the binary logs after the backup. This will allow the system administrators to balance between the need for …

Ok, here’s an evil idea for you. Say Oracle wanted to hurt MySQL financially but still look like a community player.

Simply take the Oracle Linux move and extend it to an Oracle Managed fork of the MySQL GPL code. Keep the APIs for storage engines and development and throw developers at improving the internals in some areas that need it, release more regularly than the new Community Edition, only under the GPL.

Oracle could sell support for their GPL edition to make some money, though the department as a whole might operate at a financial loss. The gain is PR and control of course.

How does it hurt MySQL? Well, one of the big reasons for Community v. Enterprise MySQL is to provide differentiation to get GPL compliant users to pay subscription fees. You take away the pain the Community edition provides, you take away the incentives of buying the Enterprise edition.

Mmm, so deliciously evil… I think I need to buy …

One may have notice we were not blogging too much recently, this is because we were quite busy, mainly building BoardReader.com - Search Engine which indexes tens of thousands of forums from all over the world. This project was built by us as consulting project so too bad we do not own it completely but we're still quite excited it is live now. We did not work on crawler in this project only on database Backend and full text search engine implementation. In this part it is standard LAMPS application. I guess you know what LAMP is and S Stands for Sphinx - Full Text Search Engine which we love to use where large scale search is needed. At this point we have over 300 millions of posts indexed with only 3 search servers and still counting. I guess we'll have half a billion of forum posts soon.

To share few more technical details …

With the recent release of CouchDb 0.6.0, I sat down and updated CouchDbX, the MacOS X GUI for CouchDb. It comes with a brand-new and shiny user interface that is (hopefully) easy to understand. Thanks to Dominik Harijanto it has a set of nice buttons. The application icon is still my temporary icon, but Dom will update that as well.

What does it do? With the three buttons, you can start and stop CouchDb as well as launch the Peek admin utility. Thrilling. Since CouchDb is still alpha-quality software and is suited only for early adopters, this is all you need for now. Once CouchDb matures, CouchDbX will become a full fledged GUI to all of CouchDb's features.

It still looks like the teaser

Download CouchDbX.

I wrote a while ago about a program I wrote to export GnuCash data into a MySQL database, including a couple of queries against the resulting schema. I've made some improvements since then to allow a simple overlay of my wife's expense categories onto the GnuCash hierarchy. This article explains the improved schema, and includes some more useful tools and queries.

From me, to Ross and license-discuss:

Socialtext which wishes to find a resolution for the attribution issuethrough the proposal of a Generic Attribution Provision.  A copy ofthe following message is available in HTML format here:https://www.socialtext.net/stoss/index.cgi?attribution_memo

I look forward to the conversation,

Ross, as I commented on a ZDNet thread, you’ve earned my respect (not that it matters) by bringing your license to OSI and having a real discussion about UI attribution.  I’m one of the critics of UI attribution licenses, but I’m glad someone brought it to place where forced UI attribution can be vetted to OSD in a reasonable manner.  I do hope you receive the criticism of this provision in that light.

needs than Linux. These application products could be “lost” in thelarger distributions. The …