The Journey Continues ...

I was a leader in the Oracle community who joined MySQL two years ago to learn more about the open source world.  The two years at MySQL were fantastic.   The extraordinary camaraderie, spirit and energy of the company was unbelievable.  I worked with some fantastic people and made a number of life time friends.

On Monday I become a full time employee of Oracle, so I've come full cycle.   Everybody is very excited about the incredible potential of Oracle and Sun and what we are going to accomplish together.   Oracle employees are enthusiastically welcoming Sun and MySQLers into the Oracle family.  

I am really looking forward to continuing my journey.

Ken Jacobs a great advocate of the database user communities

Ken Jacobs has been a fantastic advocate of the Oracle and MySQL user communites.  I met Ken on the board of the Independent Oracle Users Group (IOUG).  While Ken was the board liasson on the IOUG board, he was always supporting the Oracle user groups and made very important contributions throughout his time on the board and afterwards.  After serving time on the board, Ken was still always available and continued to be a great resource to the user community.

Ken continued his important contributions in the open source community through his work with InnoDB and MySQL.

Ken thank you for always being there.  Your contributions made a big difference and continue to be felt today. I was very disappointed that Ken will no longer be serving in role with InnoDB, MySQL and Open Source.

Take care and thanks for all the great memories.  Your selfless efforts and friendship will always be appreciated.

Best wishes in all your future endeavors.

Oracle's Commitment to MySQL, MySQL Releases and Development Cycles

The last few weeks I am still being asked what is going on with Oracle and MySQL and where is MySQL with it's software releases.  So I am going to include some URLs to hopefully answer some of your questions regarding MySQL.

Oracle's press release on December 14, 2009 regarding MySQL.

• http://www.oracle.com/us/corporate/press/042364

Summary list MySQL software releases. A more detailed list can be found at Lenz grimmer's blog on February 5, 2010.

• MySQL 5.0.90
• MySQL 5.1.43 (InnoDB Plugin 1.0.6)
• MySQL Workbench 5.2.15 (beta)
• MySQL 5.5.1 (beta)
• MySQL Cluster 6.3.31
• MySQL Cluster 7.1.1 (beta)
• MySQL Proxy 0.8.0 (beta)

You can learn more about MySQL's development cycles at:

• http://forge.mysql.com/wiki/Development_Cycle

Configuring the InnoDB Plugin (1.0.6) in MySQL 5.1.43

Configuring the InnoDB Plugin (1.0.6) is just as easy in the MySQL 5.1.43 release.  There are a few subtle changes in the new release.  Set the following parameters to configure the InnoDB plugin in 5.1.43.  A few notes:

• Set the PLUGIN_DIR parameter to the location of the plugin libraries.
• Verify all the libraries listed below are in the PLUGIN_DIR directory.
• The PLUGIN_LOAD parameter needs to be set properly. Make sure the definition is one line and there are no spaces.

my.cnf configuration 

[mysqld]
ignore-builtin-innodb

plugin_dir=/opt/mysql/5.1.43/lib/plugin

plugin-load=innodb=ha_innodb_plugin.so

;innodb_trx=ha_innodb_plugin.so

;innodb_lock_waits=ha_innodb_plugin.so 

;innodb_locks=ha_innodb_plugin.so

;innodb_cmp=ha_innodb_plugin.so

;innodb_cmp_reset=ha_innodb_plugin.so

;innodb_cmpmem=ha_innodb_plugin.so

;innodb_cmpmem_reset=ha_innodb_plugin.so

Verify the new PLUGIN metadata objects are now available. 

mysql>  SHOW PLUGINS;

Have fun with the new InnoDB Plugin features. :)