Today Pentaho released the first milestone of “Pentaho metadata” as a new core utility to make the life of BI professionals yet a little bit easier.

As you can see in the screenshot of the Pentaho metadata editor above, we offer a solution that bridges the gap between the worlds of the relational databases and business information. Here are a few of the key points that differentiate Pentaho metadata from the competition:

• Completely open
  • Released under an open source license (Mozilla Public License v1.0)
  • Persisting in the Common Warehouse Metamode, a recognised industry standard, potentially allowing for easier interoperability with 3rd party tools
  …

I needed SSL connection feature for secure offsite replication. The prebuilt binaries do not include the SSL option, so I had to build MySQL from source with the SSL option....

The next Belgian MySQL User Group is coming! On 29th of November, around 19:00, we will gather in Gent

Seems like a big crowd is already planning to go there ..!

I needed SSL connection feature for secure offsite replication. The prebuilt binaries do not include the SSL option, so I had to build MySQL from source with the SSL option....

Forrester Research has discovered the obvious: open source databases are much cheaper than proprietary databases:

Noel Yuhanna, a senior analyst at Forrester covering database management systems, estimated that average savings on the total cost of ownership are about 50 per cent. The data is based on surveys and customer interviews.

Open source databases such as Enterprise DB, Ingres and MySQL do not carry licence fees, and management tools tend to be less expensive than for proprietary databases from Oracle, Microsoft and IBM.

Open source offerings especially outshine their proprietary competitors in low-end applications with databases of less than 200GB in size.

"Eighty per cent of the applications typically use only 30 per cent of the features found in commercial databases," Yuhanna told vnunet.com. "The …

CouchDb PHP Demo Site

http://demos.couchdb.com/ now hosts two CouchDb Demos, BugShrink and Sofr (A Bugtracker and a discussion forum). Eventually, the site will revolve around all things CouchDb and PHP. Documentation, tutorials, HowTos, your demos and applications. But for now, and for the lack of material it only showcases the two CouchDb applications and links to the CouchDB PHP API documentation.

Please let us know, if you need anything else to get started with CouchDb!

Why PHP?

Currently, the CouchDb Project concentrates on the PHP community for its huge …

SugarCRM has announced an integrated stack offering that enables customers to get a one-stop-shopping solution.  The Sugar FastStack installs SugarCRM, Apache, MySQL and PHP on Windows, Linux or Mac platforms.  Faster to install, faster to get results.  It's a no brainer.

• ComputerWorld: SugarCRM Supports Full Open Source Stack
• SugarCRM: Product Editions, Downloads, SugarForge
…

I was restarting MySQL on box with 50.000 of Innodb tables and again it took couple of hours to reach decent performance because of "Opening Tables" stage was taking long.

Part of the problem is Innodb is updating stats on each table open which is possibly expensive operation, but really it is only great test case for general MySQL problem.

During warmup process I noticed I get very low CPU usage and disk Usage and IOWait about 25% (4CPU box) which indicates table opens and stats updates are serialized rather than performed in parallel.

I've checked with Heikki and he confirmed MySQL has global table cache mutex (LOCK_open) which is held for all open table operation so table opens are serialized.

Do not think however it is only Innodb problem. I've seen similar problems with MyISAM - these also take few IO operations to open and could take quite a while to close if there were unflushed key blocks and we have no …

MySQL Connector/ODBC is our next generation ODBC driver which allows access to the MySQL server using the ODBC standard - a cross-platform, cross-database C Call Level Interface.

This version is being released to get community feedback but is NOT suitable for production environments. It is now available in binary form from the Connector/ODBC download pages at http://dev.mysql.com/downloads/connector/odbc/5.0.html and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can’t find this version on some mirror, please try again later or choose another download site.)

Install Notes

Please uninstall any existing Connector/ODBC v5 before installing this version.

Changes

• ENH: Added support for column binding as SQL_NUMBERIC_STRUCT.
…