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.
…

A new MySQL Virtual Appliance is now available for download.

This new virtual appliance runs MySQL Version 5.0.1 which provides some great new features, including new datatypes, support for schemas, increased performance and triggers.

As well, this is the first virtual appliance featuring fully automated use of extra Virtual Hard Disks, which opens the door to practically unlimited storage potential using a small appliance, in spite of a small disk image size.

Any VMware or Virtual PC VHDs working, including physical volumes and VI3’s ESX hosted
iSCSI or Fiber Channel SAN volumes.

We will post a pictorial on how to use VHDs shortly.

As usual, our download images are nice and tiny.  Just 27MB for all this MySQL goodness.

Driver Manager 

The ODBC Driver Manager (DM) provides some very important features to the application. Here are some highlights;

• dynamic binding to driver
• ODBC version mapping (data and calls)
• UNICODE/ASCII translation
• cursor emulation
• ODBC rule enforcement (state transition violations etc)

The vast majority of applications will use the DM. A C/C++ application uses the DM by linking to it (the DM is a library) at build time.

No Driver Manager

In some cases the DM is not important - or is even ‘in the way’. This may be the case when;

• an application wishs to take advanatge of the code portability ODBC offers but wishs to build the code to work with just one database product
• there is a need to reduce the dependencies/complexities of the application - perhaps for performance …

MySQL AB today announced that Toto-Lotto Niedersachsen GmbH has standardized on MySQL® for all its appropriate future IT needs. The German lottery company based its selection on the success it has had using MySQL Cluster to run its online business applications.

Some people who know I’ve used Gentoo asked me my thoughts on using it for MySQL servers. Here are my opinions and experiences while using Gentoo, both for desktop systems and for servers. This is long, but hopefully the brain dump is useful to you. I have so many thoughts on this subject that I’m having a hard time really organizing them well, and I’m censoring myself too because I know I represent only a very small, focused viewpoint on Gentoo.

I posted this over the weekend:
http://download.tangent.org/memcache_engine-0.3.tar.gz

Table spaces are now supported and it works with multiple servers out of the box. This is still very experimental.

Project URL:
http://tangent.org/index.pl?node_id=506