I'm sitting in Kaj Arnö's Cloud Computing Shoot Out here in the MySQL Confernce & Expo. Great panel, great discussion! The important question, always, is about business models related to storage vs. compute clouds.

I'm sitting in Kaj Arnö's Cloud Computing Shoot Out here in the MySQL Confernce & Expo. Great panel, great discussion! The important question, always, is about business models related to storage vs. compute clouds.

I have moved on to InnoDB: Innovative Technologies for Performance and Data Protection by Ken Jacobs at MySQL Conference and Expo.

With a brief history lesson of inception from 1994, inclusion in MySQL in 2000 and acquired by Oracle in 2005. Most of the work was done by one person. InnoDB is based on sound database computer science using Gray & Reuters definitive text on database design.

Some key points in Ken’s discussion.

• Adaptive Hash indexing for frequent queries on keys.
• In plugin Adaptive Hash is configurable
• Insert Buffering - Deferring secondary index writes
• Fast Index Create - doesn’t requires all indexes to be rebuilt
• Table Compression - Changing the page size

The InnoDB plugin available in …

I am now sitting in on MySQL and Search at Craigslist by Jeremy Zawodny at MySQL Users Conference

Some of the technical difficulties that required addressing.

• High churn rate
• half life can be very short
• Growth
• Traffic
• Need to archive postings, e.g. 100M but be searchable
• Internationalization and UTF-8

Some of the Craigslist Goals

• Open Source
• Easy and approachable
• be green with energy use

A review of the Internals server configuration

• Load Balancer (perlbal like)
• Read Proxy Array (perl+memcached)
• Web Read Array (apache 1.3 + mod_perl)
• Object Cache (Perl + memcached)
• Read DB Cluster …

After 4hrs train / airport, 11hrs flight and another 2hrs commuting time on Sunday 19th I made it from London to Santa Clara. Practically exhausted I checked in, targeting a comfy hotel bed only to end up on a 1.5 hrs drive to Monterey with three good friends / colleagues! It was a great start [...]

Opening introduction from Colin Charles got us started. Karen Tegan Padir VP MySQL & Software Infrastructure was the opening keynote.

She comes from a strong tech background and is passionate about open source, the communities and how to make a successful product.

There isn’t a person that doesn’t go a day without interacting with a website or hardware system that uses a MySQL database.

The big news was the announcement of MySQL 5.4 - Performance & Scalability. Key features include.

• InnoDb scalability 16way x86 and 64 way CMT servers
• subquery optimization
• new query algorithms
• improved stored procedures, and prepared statements
• enhanced Information Schema
• improved DTrace Support

More information at …

I find it surprising that in the official Sun Announcement there is no mention of MySQL for two reasons. Firstly, this was Sun largest single purchase of $1 billion only 12 months ago. Second, MySQL’s largest competitor is Oracle.

While the Sun website shows the news in grandeur, the MySQL website is noticeably absent in any information of it’s owners’ acquisition.

On my professional side, as an independent speaker for Sun Microsystems with plans for upcoming webinars and future speaking on “Best Practices in Migrating to MySQL from Oracle”, this news does not benefit my bottom line.

I’ve just successfully configured Drizzle with the PHP Extension and successfully retrieve data to present on a web page.

Qudos to Eric Day for his work. I was able to identify a problem with the current tar release, and a quick confirmation on #drizzle at IRC confirmed a fix had already been commited.

I’m looking forward to evaluating WordPress and Drupal, two popular and common LAMP stack applications that run on MySQL, and to provide any feedback to the community for future support of Drizzle.

The BoF schedule for MySQL Conference and Expo (2009) is now published. Lenz Grimmer, Sergei Golubchik, Tomas Ulin and myself will be available during a BoF which focuses on MySQL Community Code Contributions. Lenz will be moderating. For background material, you may start here.

The BoF schedule for MySQL Conference and Expo (2009) is now published. Lenz Grimmer, Sergei Golubchik, Tomas Ulin and myself will be available during a BoF which focuses on MySQL Community Code Contributions. Lenz will be moderating. For background material, you may start here.